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

calculated member apply formula Expand / Collapse
Author
Message
Posted Monday, October 7, 2013 8:39 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:17 AM
Points: 62, Visits: 321
SENARIO
I have an Measure from DSV - [Measures].[Total Water Qty].
When year dim selected > 2012, Apply formula on measure when year > 2012 , [Measures].[Total Water Qty]/ [Measures].[Total Production Qty]

On using scope, i am able to see only if year = 2012. Need Formula to apply for all the years greater than 2012.

SCOPE STATEMENT USED :
SCOPE ([Period].[Calendar Hierarchy].[Calendar Hierarchy - Year].&[2012],[Measures].[Total Water Qty]);
This =[Measures].[Total Water Qty]/ [Measures].[Total Production Qty];
END SCOPE;
ShanmugaRaj
Post #1502453
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse