Skip to Content
0
Former Member
Jun 14, 2011 at 12:55 PM

memory-intensive consumption executing a webi document

47 Views

Hi Experts,

When we execute a Webi document in an OLAP universe with a BexQuery on top at BW side we obtain following error message:

Error in MDDataSetBW.GetCellData. No more storage space available for extending an internal table.. (WIS 10901).

This execution should return aprox. 200 thousand rows. We are querying 10 dimensions and 2 ratios from universe. This 10 dimensions are 10 navigational attributes at BW side. There is an aggregate defiined in the cube that includes all these navigational attributes. When we use 8 or less dimensions the webi document finish successfully.

In ST22 we obtain a TSV_TNEW_PAGE_ALLOC_FAILED error because the process consumes 7GB of main memory.

We catch MDX instruction generated by webi document using RSTT:

SELECT {

[Measures].[4K1BCOQ4DGNEJQT7PX6JVDN4T],

[Measures].[4K1BCOXSWF942DCNVR8W5FLUL] }

ON COLUMNS ,

NON EMPTY

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

[0MATERIAL__ZBRANDTYP].[LEVEL01].MEMBERS,

{ [ZBOCALID__ZBOCALYFL].[X] } ),

[0MATERIAL__ZPURGRFAM].[LEVEL01].MEMBERS ),

[0MATERIAL__0RPA_WGH3].[LEVEL01].MEMBERS ),

[0MATERIAL__0RPA_WGH2].[LEVEL01].MEMBERS ),

[0MATERIAL__0RPA_WGH1].[LEVEL01].MEMBERS ),

[0CUSTOMER__ZDCHNG2ZT].[LEVEL01].MEMBERS ),

[0CUSTOMER__ZDCHNG1ZT].[LEVEL01].MEMBERS ),

[0CUSTOMER__ZRTPLTPZT].[LEVEL01].MEMBERS ),

[ZPRECIOAP].[LEVEL01].MEMBERS ),

[0CALMONTH].[LEVEL01].MEMBERS ),

[0SALESORG].[LEVEL01].MEMBERS )

DIMENSION PROPERTIES

[0CALMONTH].[40CALMONTH2],

[0SALESORG].[50COMP_CODE]

ON ROWS FROM [ZBORTSA01/ZBORTSA01_02]

SAP VARIABLES

[!V000002] INCLUDING [0CALMONTH].[201101]

[!V000006] INCLUDING [ZBOFNCM].[MESANT]

We are working with:

SAP BOE XI 3.1 SP3 FP2

SAP BI 7.00 (SAPKW70021)

If it is possible can someone please let me know how can i resolve this problem? What alternatives do we have? Upgrading to SAP BI 7.01 SP5 can solve the problem?

Best Regards,

Carles