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?