March 3, 2014 at 6:48 am
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
March 3, 2014 at 8:32 am
I got it to work. Not exatly sure why but it works as supposed for both hierachies is I take away the first one, maybe it has somethink todo with he fact that it is the key of the dimension.
Michael
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply