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

Getting Grand Total of a calculated member Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 11:18 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 2:57 PM
Points: 81, Visits: 227
I have a calculated member in my cube called [LY Pounds]. I need to get the grand total of [LY Pounds] as displayed in the cube browser against my time dimension Fiscal Period hierarchy in another calculated member for comparison.

The Fiscal Period hierarchy contains Year and month attributes.

CREATE MEMBER CURRENTCUBE.[MEASURES].[LY Pounds]
AS ([Measures].[Total Pounds],parallelperiod([Fiscal Period].[Fiscal Period Hierarchy].[Year],1,[Fiscal Period_2].[Fiscal Period Hierarchy].currentmember)),
FORMAT_STRING = "#,#",
VISIBLE = 1;

I know that [Fiscal Period].[Fiscal Period Hierarchy].[All] will get the grand total. But I don't know how to get the [LY Pounds] of all members against fiscal period hierarchy. Could anyone please help me? Thanks.

Post #1435262
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse