Skip to Content
author's profile photo Former Member
Former Member

SAP BW Queries behave different Bex analyzer vs Analysis for OLAP


SAP BW 7.01 SP7



I have a BEX query which contains a hierarchy. This Query when executed with Bex Analyzer for either Web or Excel takes seconds to be executed. But when executed using Analysis for OLAP it takes about two minutes. (strangely enough it is always about 2 minutes).

When I look into BW while the run is being executed(refreshed) at Analysis for OLAP, I can see the system is doing a sequential read on a customer text table and it can be seen it takes around 2 minutes.

My question is why Analysis triggers this and not Bex Analyzer?

Other queries run perfectly fine, except for this with the hierarchy

I'll appreciate your comments!

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Dec 10, 2012 at 06:12 PM

    Hello Hugo

    Do you have access to Analysis edition for MS Office? If so could you try using this tool with the same query. The underlying connectivity to the BW query is different between the Analysis clients and the BEx clients. I'm keen to find out if the problem you are seeing is related to the connectivity used or if it is specific to Analysis OLAP. A test with Analysis for MS Office will help confirm that.


    Add comment
    10|10000 characters needed characters exceeded