MDX Error

[Former Member]

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

[Former Member · Accepted solution]

Hi Rohan,

Check these OSS notes for 3.5

772340, 899343, 902769

hope this helps,

Sudhakar.

[srinivas_anilkumar]

Hi,

Search for this note.

Note 1049434 - MDX: Supporting non-numeric calculated members

Hope it helps

Regards

Srini