memory-intensive consumption executing a webi document
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