SAP Knowledge Base Article - Preview

3361423 - Post migration from a non Cloud DB to Cloud DB, CAST function is added with "User Input Date format" in Webi report query script

Symptom

Slowness in Webi report refresh due to CAST function being added after migrating from non cloud DB to Cloud DB in Business object BI 4.x.

For all the cloud databases .prm file shows CAST as default function for parameter "User input date format".

<Parameter Name="USER_INPUT_DATE_FORMAT">\C\A\S\T('yyyy-MM-dd HH:mm:ss' \A\S \t\i\m\e\s\t\a\m\p)</Parameter

CAST function makes the query consume more time to run(due to indexing) causing slowness in Webi report.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x
  • Web Intelligence
  • Reporting Database: Any Cloud Database

Keywords

Webi, Cast function, Cloud Database, prm, user input, Date , KBA , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.