MDX Restricted Measure in universe

[Former Member]

Hello Friends. Please help to solve this. I want to put in universe 2 restricted measure

1. AMT TO BE MULTIPLIED BY 100 IF PRICE LIST KEY IS "JY"

I wrote the below MDX but it failed when i run the report . please correct my code

<EXPRESSION>

IIf( [0PRICE_LIST].[LEVEL01].[[20PRICE_LIST]].[Value] = [0PRICE_LIST].[LEVEL01].[[20PRICE_LIST]].[JY] , [Measures].[ZNKF_ZRTAMTTC_L1] * 100,[Measures].[ZNKF_ZRTAMTTC_L1] ))

</EXPRESSION>

I also tried the below it does not work again

<EXPRESSION>

IIf( [0PRICE_LIST].CurrentMember.Name = [0PRICE_LIST].[JY].Name , [Measures].[ZNKF_ZRTAMTTC_L1] * 100,[Measures].[ZNKF_ZRTAMTTC_L1] ))

</EXPRESSION>

2. I also want to do the variable at universe for characteristic

like if price list type is jy or us then allocation territory

but code does not work

<EXPRESSION>

IIf( [0PRICE_LIST].CurrentMember.Name = [0PRICE_LIST].[JY].Name OR [0PRICE_LIST].CurrentMember.Name = [0PRICE_LIST].[US].Name , [ALLOC_TERR], NULL))

</EXPRESSION>

Please help with the above

Thanks

Soniya

[Former Member]

Hi,

I assume that JY is a value so the right MDX syntax for theexpression is:

<EXPRESSION>
IIF( [0PRICE_LIST].Currentmember.Properties("[20PRICE_LIST]") = "JY", [Measures].[ZNKF_ZRTAMTTC_L1] * 100, [Measures].[ZNKF_ZRTAMTTC_L1] )
</EXPRESSION>

Didier

[Former Member]

Hello Didier . Thanks for your help.I tried with the code you gave. But it is throwing the attached 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 so I can make it work in webi report

Thanks

Soniya

Edited by: SoniyaM on Feb 22, 2011 11:28 PM