Hello,
We get the following error message when executing our WebI Report based on a query SAP BI 7.
It might be caused by the fact that we are dealing with a lot of data.
MDMDataSetBW.GetCellData error Unknown error (WIS 10901)
In our case, when we run the MDX code generated by BO on SAP (transaction MDXTEST), SAP BI run it and we get the expected result.
See the code below :
SELECT { [Measures].[A_M_000_MONTH], [Measures].[A_M_000_CUMUL], [Measures].[A_M_000_QUANTITY], [Measures].[A_M_000_HEADCNT], [Measures].[A_12_B_MONTH], [Measures].[A_12_B_CUMUL], [Measures].[A1_M_000_MONTH], [Measures].[A1_M_000_CUMUL], [Measures].[A1_M_000_QUANTITY], [Measures].[A1_M_000_HEADCNT], [Measures].[A1_12_000_MONTH], [Measures].[A1_12_000_CUMUL], .... [Z_DASH_LN].[251], [Z_DASH_LN].[252], [Z_DASH_LN].[27], [Z_DASH_LN].[28], [Z_DASH_LN].[29], [Z_DASH_LN].[3], [Z_DASH_LN].[32], [Z_DASH_LN].[33], [Z_DASH_LN].[34], [Z_DASH_LN].[37], [Z_DASH_LN].[43], [Z_DASH_LN].[44], [Z_DASH_LN].[46], [Z_DASH_LN].[47], [Z_DASH_LN].[48], [Z_DASH_LN].[49], [Z_DASH_LN].[5], [Z_DASH_LN].[50], ....[ZOU__ZAREA].[LEVEL01].MEMBERS ) DIMENSION PROPERTIES [0CURRENCY].[20CURRENCY], [0FISCPER3].[20FISCPER3], [0VERSION].[20VERSION], [ZOU__ZAREA].[1ZOU__ZAREA], [ZOU__ZAREA].[2ZOU__ZAREA], [ZOU__ZAREA].[2ZRANK], [ZOU__ZDEL].[1ZOU__ZDEL], [ZOU__ZDEL].[2ZOU__ZDEL], [ZOU__ZDIV].[1ZOU__ZDIV], [ZOU__ZDIV].[2ZOU__ZDIV], [ZOU__ZDIV].[2ZRANK], [Z_DASH_LN].[2Z_DASH_LN] ON ROWS FROM [ZPCA_CO3M/ZBW_WEBI_CO_01] SAP VARIABLES [0P_VERS6] INCLUDING [0VERSION].[B3] [0_FPER1] INCLUDING [0FISCPER3].[010] [0P_GJAHR] INCLUDING [0FISCYEAR].[K42008] [DELEG] INCLUDING [ZOU__ZDEL].[DG2002]
We obtain a sample result of 500 rows...
For this request we are expecting more than 1 500 000 rows...
Our version are:
-SAPKW70017
-BOE XI 3.1 with SAP integration kit 3.1.
-On AIX
I made the following test in Webi:
-Create a table with 10 columns and 1 500 000 rows on Oracle Database
-Design a Universe on this table
-Create a Webi Report on it
The result is OK, I have got 1500000 rows => 15 000 000 Cells in webi report...
Have you got an idea or something I can do to solve my problem.
Thanks
HI Gilles,
the current OLAP BAPI is limited to 1 mill cells but this is being addressed in NW 7.01 SP03 to my knowledge.
On the other hand I would like to understand what you trying to do because 1.5 million rows with such an MDX looks like around 10 - 15 million cells to me and I would like to see what you trying to do in Web Intelligence with such a large data volume beacause there might be other options as well.
ingo
OK, Thanks for all Ingo.
My customer open a message with support team.
If you want to have general view of case, follow the link:
Case: MDMDataSetBW.GetCellData error when running WebI report ( 1094120 / 2008 )
[Message 1094120|https://service.sap.com/sap/support/message/F/002007974700010941202008]
Gilles
Add a comment