Slowness issue in opening prompts window while scheduling a BO4.1 webi report after upgrading to SP05 Patch05
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:
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
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.