Skip to Content
Former Member
Sep 30, 2009 at 05:20 AM

Troubleshooting SAP BW OLAP Universe



Please advise how to approach troubleshooting an OLAP universe created on a SAP BW query. The BW query is simple with no calculated or restricted key figures, but has a lot of characteristics (about 50). An OLAP universe was created (default MDX code, no custom objects). The Webi report almost works fine, but here is a summary:



BusinessObjects 3.1 (SP2) BOE and client

Universe -> BEx query -> Multiprovider -> DSO (data volume = 1600 rows)

Webi report:

1) Issues start when the number of result objects in the Webi query panel approach 50 to 60. At the high end of 60, the query takes much longer and returns "No Data to fetch". Removing some objects, the query will return data back again. No filters or any logic from the additional object should be causing the "No Data to fetch".

2) Certain combinations of objects causes MDX errors. The universe MDX code is default and the BEx query works fine. Avoiding the object combination and the report will run again.

3) The BEx query works fine. Although it has large number of characteristics, the objects are mostly flags and simple data stored on the DSO. Minimal Master Data or navigation attributes.

4) I tried to split the query into two in Webi and merge it back on the report level. I was expecting for the two queries to run separately (they work fine separately), but when using the "Run for all queries", it takes very long and does not finish.

Any information would be much appreciated. Thank you.