Skip to Content
0
Former Member
Feb 04, 2011 at 07:41 PM

MDX Restricted Measure in universe

44 Views

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