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


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.



SAP BusinessObjects Business Intelligence Platform 4.x

Web Intelligence

Cloud DBs


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.