MDMDataSetBW.GetCellData error - Problem with 1 Million Limit

[gilles_breton]

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

[gilles_breton · Accepted solution]

Thanks Ingo,

OK for upgrade on SAP side.

But what is the upgrade on BO Side, we have got the BOE and Integration Kit XI 3.1 is the Fix pack 1.1 needed????

Gilles

[IngoH · Accepted solution]

Hi Gilles,

as mentioned I would suggest to open a Support case and ask for the details. Yes it will require a fixpack on the BusinessObjects side

Ingo

[gilles_breton]

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

[gilles_breton]

Hi Ingo,

So I understand that the limit is on SAP side not on BO/Webi side?

And if we upgrade in SAP BI 7.01 SP3 the problem could be solved.

Thanks

[IngoH]

Hi Gilles,

it requires updates on the SAP side (as mentioned above) and on the BusinessObjects side.

Some of the changes are also available as correction notes. I think the best would be to open a case towards support to get the complete details

Ingo

[IngoH]

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