slow reports (webi)

[Former Member]

Hi Experts!

We are experiencing slow Deployment webi 4.1 SP5 reports, we have found that the database is responding to the server webi with all neccesary querys in approximately 3 min, but webi is deploying the report in approximately 17 min.

This report has 20 querys that are executing on SAP IQ 16 Database.

Only the required dimensions are merging.

The query stripping option was enabled at universe level.

Automatic adjustment of the cells was removed.

Has anyone experienced any similar case?  or you know any way to run a trace to find out why take is taking so long to deploy webi the report?

This report only shows a table data, it not contains anything maps o graph.

[Former Member]

Hi,

You must be using some complex formulas on webi.

What you can do is simply remove all the formulas from report once and test the report without any formula.

You can then compare the result. I think in WEBI 4,1 there are so many calculation changes made by the SAP.

Refer the below links:

http://wiki.scn.sap.com/wiki/display/BOBJ/Calculation+Engine+Changes+for+Web+Intelligence+BI4+and+XI...