Hierarchy Performance in BO 4.0 direct to Bex query

[former_member360582]

Hi

We are using BO 4.0 using BICS connection.

Webi report is connected directly to BEx query.

We are getting perforance when selecting Hierarchy in new BO 4.0 environment.

In what way we can reduce this performance.

The report is taking around 30 minutes and some time time out.

Is this product issue

Regards

Gaurav Mang

[Henry_Banks · Accepted solution]

Hi,

1. you can "suppress unassigned nodes" in RSH1

2. you can enable Query Stripping in webi query panel and webi document properties

3. you can enable BICSLOVChunking registry settings

--> Note 1581323 - BI 4.0 Web Intelligence very slow performance when using BICS

4. modify the WebiParamMaxLovSize settings

--> Note 1671774 - "OutOfMemory exception" and poor performance when accessing large LOV's in WebIntelligence (using Desktop client or Launchpad) using BICS to connect to BEx query

5. you should implement all the latest BW correction from the BI-RA-BICS component, such as BICS Note 1593802 Performance optimization when loading query views

6. You should use the latest available Patch2.12 (optimizations since 2.10 are very good)

7. you should answer as many Filters (Bex variables) as possible during runtime.

Regards,

H

p.s. after these steps, the rest is down to Document, Query, and Datamodel design.

[Former Member · Accepted solution]

Thanks for the information.  I reviewed Note 1581323 and it made a lot of sense.  Is the sap note 1671774 not yet released? Can you forward it?  I'll try all the suggestions in Note 1581323 and update you on performance improvement.

Thanks again.

Lucia Chan

[former_member188911 · Accepted solution]

Hi Lucia,

1671774 has been fixed with patch 2.4 and above.

for more recent updated tips on performance please see this thread

http://scn.sap.com/thread/3205539

thanks

Simone

[Former Member · Accepted solution]

Thank you so much for your response.  I've gone to the provided link, and it has a few more tips that we can try.  Much appreciated.