Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Slowness issue in opening prompts window while scheduling a BO4.1 webi report after upgrading to SP05 Patch05

Hello,

We are facing slowness in opening prompt window while scheduling a webi report, the problem occurs on all reports with more than one prompt.

The opening of prompts while schedluing the webi report in BI4 it takes around 4 minutes 12 seconds.
"
This problem has been there after upgrading the environment from "BI4.1 SP04 Patch 04" to "BI4.1 SP05 Patch 05" .

More information about our environment:

Environment:

BI4 SP05 Patch 05 on Windows Server 2008R2


Universes connecting to Oracle DB

About Report :
Report is very large with around 9 queries and with all type of data sources in it:
1. Data is fetched through custom sql queries along with prompts in the query.
2. Data is fetched through universe.
3. Report also has Excel source in it.


No. of prompts : 06


Performed steps:

In "mdas.properties" file changed one parameter from true to false
"multidimensional.services.variable.validation.enabled=false" but still the same issue

Your support on this issue is highly appreciated.

Thanks

Former Member
Not what you were looking for? View more on this topic or Ask a question