SAP BO 4.2 Webi working slow

[former_member553358]

Hi,

The user working on webi reports complains that it is too slow.
The web when run in HTML is slow and when run in java it is faster.

In HTML it is slower to make any small changes.

Please can you help me in the problem for this behavior and also any resolution for the same.

Thank you very much

SAP BO 4.2 SP5 Patch 2.

[omacoder · Accepted solution]

Questions:

1. Is there only one user reporting this issue? Or multiple?
2. If only one user, is it only one of their reports they are having issues with or multiple reports?
3. What is the size of the said report(s)?
4. What is the number of rows in said report(s)?
5. What is the number of tabs in said report(s)?

(Java applet will naturally always be faster, btw.)

[former_member553358 · Accepted solution]

Is there only one user reporting this issue? Or multiple?
R: Multiple users

If only one user, is it only one of their reports they are having issues with or multiple reports?
R: The problem occur in complex reports.

What is the size of the said report(s)?
R: The reports is on SAP BI Platform.

What is the number of rows in said report(s)?
R:The reports content more 5000 lines.

What is the number of tabs in said report(s)?
R: The reports contains 3 tabs and 3 query.
The universe is very complex. Contains multiple tables and columns.

Statistics the universe used.
683 classes
7050 objects
1027 conditions
556 tables
4 alias
798 joins
368 contexts

[former_member553358 · Accepted solution]

The universe used is unv.

[omacoder · Accepted solution]

It looks like you've already deducted that this is only a problem in large complex reports.

Have you tried increasing available RAM on the host(s) and expanding xmx settings in CMC servers to see if that improves performance of these reports while using the HTML editor?

I presume your APS's are split?

[former_member553358 · Accepted solution]

My APS are split, but is not equal the information KB 1694041.

[former_member553358 · Accepted solution]

The slowness occurs only in Design view of the report.

[omacoder · Accepted solution]

Sounds like there's opportinuty to review how you have your APS split and the amount of memory assigned to each of them.

Also, review your cache settings for the WIPS? See 1291966

[former_member553358 · Accepted solution]

sapboe.jpg

WebIntelligenceProcessingServer

[former_member553358]

https://launchpad.support.sap.com/#notes/2616011