Universe Measure MDX logic with if statement to derive the measure

[Former Member]

Thanks for your help folks on question's earlier.I tried with the code below. But it is throwing the MDX command not valid GET CELL DATA ERROR MDDATASETBW.GETCELLDATA Invalid MDX Command <usrdf_property>.Value

Code I have in universe

<EXPRESSION>

IIF( 0PRICE_LIST.Currentmember.Properties("20PRICE_LIST") = "JY", Measures.ZNKF_ZRTAMTTC_L1 * 100,

Measures.ZNKF_ZRTAMTTC_L1 )

</EXPRESSION>

Yes Price List Type Key (0PRICE_LIST.LEVEL01.[20PRICE_LIST].Value) is of type character and have value "JY"

Please help me fix the code in universe so I can make it work in webi report

Thanks

Soniya

[marc_daniau · Accepted solution]

Have you tried the following syntax?

IIF( [0PRICE_LIST].[20PRICE_LIST] = "JY", [Measures].[ZNKF_ZRTAMTTC_L1] * 100,

[Measures].[ZNKF_ZRTAMTTC_L1] )

I tried it against the Actual for NW Demo cube using mdxtest; it works fine.

WITH

MEMBER [Measures].[TEST] AS

'

IIF( [0D_NW_CNTRY].[20D_NW_CNTRY] = "GB",

[Measures].[0D_NW_NETV] * 100, [Measures].[0D_NW_NETV] )

'

SELECT

{[Measures].[TEST], [Measures].[0D_NW_NETV]} ON COLUMNS,

{[0D_NW_CNTRY].[LEVEL01].MEMBERS} ON ROWS

FROM [$0D_NW_C01]