on 06-13-2011 2:17 PM
Hi,
We have developed an universe on BI query and developed report on it. But while running this BO query in Web Intelligence we get the following error
A database error occured. The database error text is: Error in MDDataSetBW.GetCellData. MDX result contains too many cells (more than 1 million). (WIS 10901)
This BO query is restricted for one document number.
Now when i check in the BI cube there are not more than 300-400 records for that document number.
If i restrict the BO query for document number, delivery number, material and acknowledged date then the query runs successfully.
Can anyone please help with this issue.
Hi,
delete all the unwanted attributes in universe .....like display attribute......etc....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
take the mdx generated and try to execute the same in mdxtest transaction. do u get the same message ? if yes, u can try to split the query in mutually exclusive parts using query filters and then merge the dimensions. but i personally don't like such a report which deals with 1 million cells.
follow this article to get the mdx generated by the webi report.
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/90b02218-d909-2e10-1988-a2ca74547900
then try to execute the same in mdxtest transaction in bw
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.