on 06-14-2011 1:55 PM
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
Hi Ingo,
We're working with SAP BO XI 3.1 SP3 but not with SAP BI 7.01 SP5. Anyway, we tried launching webi document with query stripping checked. As was expected we obtain the same error.
We'll work with our Base team colleagues to plan the upgrade to SAP BI 7.01 SP5.
Thanks a lot for answer so quickly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you should move to SAP BusinessObjects XI 3.1 SP3 or higher, SAP BW 7.01 SP05 or higher and you should also make use f Query Stripping which is part of SP3.
Ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.