cancel
Showing results for 
Search instead for 
Did you mean: 

error MDX result contains too many cells (more than 1 million). (WIS 10901)

amruta_kedar
Explorer
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

delete all the unwanted attributes in universe .....like display attribute......etc....

amruta_kedar
Explorer
0 Kudos

Only required atttibutes are used in the query.

arijit_das
Active Contributor
0 Kudos

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.

amruta_kedar
Explorer
0 Kudos

I am new to BO.

Could you please elaborate how this can be done??

there are no 1 million records for the query for sure.

Edited by: Amruta_Kedar on Jun 13, 2011 4:08 PM

arijit_das
Active Contributor
0 Kudos

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