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

[Former Member]

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]

Mdas is for olap source and not for univers no need to change mdas.properties.

Try to dublicate webi processing server and see

[Former Member]

Hello,

Can anyone help on this issue?

Regards