SAP BW Queries behave different Bex analyzer vs Analysis for OLAP
SAP BW 7.01 SP7
SAP BO BI 4.0 SP4
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!