Skip to Content
0
Former Member
Jan 22, 2010 at 09:28 AM

SAP BI Dimension Object Limit in Report

47 Views

Hi

I have a Rich Client (XI3.1) report over a SAP BI Universe. I can add all Key Figures to my Query and 60 Dimensions to my query and it will run fine.

If I add one more Dimension object to the results objects and the query fails with an MDX Error:

A database error occured. The database error text is: The MDX query SELECT  [Measures]....< rest of query >... failed to execute
 with the error Unknown error. (WIS 10901) 

Removing any of the Dimension objects will clear the error and the report will run.

I can however add more Detail objects to the query without any errors!

Is there a limit on the number of Dimension objects that can be returned from a SAP BI query documented anywhere? Anyone else seeing this issue?

Thanks