Skip to Content
0
Former Member
Jul 03, 2007 at 11:32 AM

MDX Error

23 Views

Hi Experts,

Cud u pls tell me what is the mentioned below error in BW3.5 with MDX query?

Any suitable answer will be rewarded with suitable points.Pls let me know if you have any further clarifications.

<b>MDX Query:</b>

WITH MEMBER [0D_SOLD_TO].[CA] AS 'SUM(FILTER ({[0D_SOLD_TO].Members} , ([0D_SOLD_TO].[20D_COUNTRY] = "CA" AND [0D_SOLD_TO].[20D_INDUSTRY] = "2222" )))' MEMBER [0D_SOLD_TO].[DE] AS 'SUM(FILTER ({[0D_SOLD_TO].Members} , ([0D_SOLD_TO].[20D_COUNTRY] = "DE" AND [0D_SOLD_TO].[20D_INDUSTRY] = "2222" )))' MEMBER [0D_SOLD_TO].[FR] AS 'SUM(FILTER ({[0D_SOLD_TO].Members} , ([0D_SOLD_TO].[20D_COUNTRY] = "FR" AND [0D_SOLD_TO].[20D_INDUSTRY] = "2222" )))' MEMBER [0D_SOLD_TO].[GB] AS 'SUM(FILTER ({[0D_SOLD_TO].Members} , ([0D_SOLD_TO].[20D_COUNTRY] = "GB" AND [0D_SOLD_TO].[20D_INDUSTRY] = "2222" )))' MEMBER [0D_MATERIAL].[198] AS 'SUM(FILTER ({[0D_MATERIAL].Members} , ([0D_MATERIAL].[20D_MTLGROUP] = "198")))' MEMBER [0D_CO_CODE].[US] AS 'SUM(FILTER ({[0D_CO_CODE].Members} , ([0D_CO_CODE].[20D_COUNTRY] = "US")))' SELECT {[0D_SALE_EMP].[00001205], [0D_SALE_EMP].[00001264], [0D_SALE_EMP].[00001703], [0D_SALE_EMP].[00001706]} PROPERTIES MEMBER_NAME,MEMBER_CAPTION ON COLUMNS, {[0D_SOLD_TO].[CA], [0D_SOLD_TO].[DE], [0D_SOLD_TO].[FR], [0D_SOLD_TO].[GB]} PROPERTIES MEMBER_NAME,MEMBER_CAPTION ON ROWS, {[Measures].[0D_COST], [Measures].[0D_INV_QTY], [Measures].[0D_NETVLINV], [Measures].[0D_TAXAMOUN]} PROPERTIES MEMBER_NAME,MEMBER_CAPTION ON PAGES, {([0D_MATERIAL].[198], [0D_CO_CODE].[US])} ON 3 FROM [$0D_DECU] WHERE ([0D_DIS_CHAN].[All], [0D_DIV].[All], [0D_PROD_HIE].[All], [0D_SALE_ORG].[All], [0D_VERSION].[All], [0D_VTYPE].[All], [0CALDAY].[All], [0CALMONTH].[All], [0CALQUARTER].[All], [0CALYEAR].[All], [0DOC_CURRCY].[All], [0SALES_UNIT].[All])

<b>Error encountered:</b>

06-13 19:53:15 ERROR SAPDataQuery ADM Exception occured: BAPI_MDDATASET_GET_CELL_DATA com.sap.mw.jco.JCO.Exception:&INCLUDE INCL_INSTALLATION_ERROR

06-13 19:53:15 ERROR SAPDataQuery com.hyperion.ap.bapi.function.BAPIFunctionException: [0] BAPI_MDDATASET_GET_CELL_DATA com.sap.mw.jco.JCO.Exception:&INCLUDE INCL_INSTALLATION_ERROR

at com.hyperion.ap.bapi.function.BAPIFunctionBase.execute(BAPIFunctionBase.java:37)

at com.hyperion.ap.bapi.BAPICubeView.fetchDataCells(BAPICubeView.java:242)

at com.hyperion.ap.bapi.BAPICubeView.fetchDataCells(BAPICubeView.java:171)

at com.hyperion.ap.bapi.BAPIDriver.HssQryFetchDataCells(BAPIDriver.java:313)

at com.hyperion.ap.adm.HssConnSessionWrapper.HssQryFetchDataCells(HssConnSessionWrapper.java:3649)

at com.hyperion.ap.adm.HssQryCubeViewData.fetchDataCells(HssQryCubeViewData.java:53)

at com.hyperion.ap.adm.HssQryCubeView.fetchDataCells(HssQryCubeView.java:397)

at com.hyperion.reporting.haradm.SAPDataQuery.processAdmQueries(Unknown Source)

at com.hyperion.reporting.haradm.SAPDataQuery.execute(Unknown Source)

at com.hyperion.reporting.results.ExecGrid.executeGridObject(Unknown Source)

Thanks!

Rohan