We are having some performance issues on the Webi side. We have OLAP universe pointing to Bex query on BW side. Then we are running the Webi report. The webi report is taking 4 times longer to run than the BEX query.
How to debug such a problem. In a non sap environment we can take the SQL and fine tune the query by running explain plan.
But how to fine tune the MDX query on OLA universe side ?