Hi
I am trying to prevent values for my "All" member to be shown in the cube when slicing on 2 exchange hiearchies. The statement works separatly, but together with the "or" I am missing all values when slicing on [Exchanged Currency].[Exchanged Currency]
What am I doing wrong?
CREATE MEMBER CURRENTCUBE.[Measures].[FX Rate]
AS IIF([Exchanged Currency].[Exchanged Currency Code].Currentmember is [Exchanged Currency].[Exchanged Currency Code].[All Exchanged Currencies] or [Exchanged Currency].[Exchanged Currency].Currentmember is [Exchanged Currency].[Exchanged Currency].[All] ,NULL,[Measures].[FX Rate LNE]),
FORMAT_STRING = "#,##0.000000",
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'xxx' ;
Thanks