Skip to Content

Hierarchy Performance in BO 4.0 direct to Bex query


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


Gaurav Mang

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Feb 23, 2012 at 11:57 AM


    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.



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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.