Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Simple calculation doesnot evaluate Expand / Collapse
Author
Message
Posted Monday, March 3, 2014 6:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 2:22 AM
Points: 35, Visits: 256
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
Post #1546906
Posted Monday, March 3, 2014 8:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 2:22 AM
Points: 35, Visits: 256
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
Post #1546946
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse