Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP BW Queries behave different Bex analyzer vs Analysis for OLAP

Platform:

SAP BW 7.01 SP7

SAP BO BI 4.0 SP4

Hello,

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!

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question