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

Scope using MeasureGroupMeasures() and Hierarchy level Expand / Collapse
Author
Message
Posted Monday, January 13, 2014 2:36 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 2:17 PM
Points: 59, Visits: 209
Trying to evaluate all levels rather than a specific level. Is this possible? The example below is not working for me.
Basically, when level > 1, we want all measures in the measure group to be set to null else display the measures.

SCOPE(MeasureGroupMeasures("Marketing Cost"),[Enrollment Device].[Enrollment Device Hierarchy].AllMembers );

This = IIF( [Enrollment Device].[Enrollment Device Hierarchy].currentmember.level.ordinal < 2

,MeasureGroupMeasures("Marketing Cost")

,NULL );

END SCOPE;
Post #1530469
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse