SAP BO Webi working very slow

[Former Member]

Hi,

I am using SAP BO 4.0, working on webi reports.

I have a problem ,my webi runs very slow, it takes around 2-3 mins to open then also if i click on the window it hangs.For making any small change it takes 2-3 mins .Its really testing my patience.Its working like that from starting <working for last 3 months>

Please let me know what can be the issue for this behavior and also any resolution for the same.

Regards,

Javed

[Former Member]

Webi is extremely slow when using the Java viewer (also known as the Rich Internet Application viewer, and now in BI 4.1, "Applet Viewer"). Even on perfectly sized deployments, the Java viewer is the bottleneck.

The HTML / Web viewer is the best viewer choice in most situations. It has its shortcomings and is not quite as complete as the Java viewer, but it does work perfectly for 95% of users. And its FAST. Something that the Java viewer is NOT.

Why is the Java viewer so slow? No clue. Can we please have a new Service Pack to improve Webi report load times? That seems so basic.

[sachin_sachdeva2]

We are on SAP BO 4.0 patch 18 and having same problem , webi runs very slow, it takes around 2-3 mins to open if  click on View. in our case this in happening with BICS.

Please advise

[denis_konovalov]

there are many factors that can play in this, starting from proper Sizing, proper tuning of APS and WPS servers to configuration of Java app server used, network between BI servers and data sources and even report design.

This sort of question have been asked before in this forums, there are also SAP KB articles on sizing, performance and other areas that are part of this question.

I'd start here :

https://service.sap.com/sap/support/notes/0001570271

https://service.sap.com/sap/support/notes/0001694041

https://service.sap.com/sap/support/notes/0001522418

http://scn.sap.com/community/coil/blog/2012/06/12/best-practices-for-running-bi-4-in-virtualized-env...

http://scn.sap.com/docs/DOC-6191

http://scn.sap.com/people/james.rapp/blog/2012/07/03/bi4-pattern-books-are-now-live

[sachin_sachdeva2]

Thanks Denis for quick reply

Do we have sap Artical or link or note on how to increase Tomcat max heap size? step by steps

-Xms4g and -XmX4g

Also so far we have not done Wily Config., in that case what is the best practice to monitor Hava heap for tomcat and APS?

[denis_konovalov]

This information is not SAP specific, you should be able to find it here :

tomcat.apache.org

APS monitoring can be done thru built in Monitoring tools - see Admin guide

[former_member206455]

Hi Denis,

We're facing slowness when changing data source in WebI report. After clicking "Finish" button window got freeze. Specially this behavior observed in report with more then 2 data sources. Any help will be appreciated.

[Former Member]

This can be related to the size of your universe because Webi needs to check each object in your query/queries for corresponding objects in your new universe. How many objects are there in each universe?