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

Cube question - Swapping Measure Depending on Dimension being used? Expand / Collapse
Author
Message
Posted Wednesday, May 15, 2013 1:43 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 17, 2013 2:39 AM
Points: 69, Visits: 88
Hi, I am using SSAS 2012.

I have been asked to see if it is possible to change the measure depending on the dimension being used in the report.

For example. If i have two measures in my cube, say "Sales" and "Orders". Is it possible to introduce a third calculated Measure lets call it "Amount" and the value of "Amount" is "Sales" when the dimension is "Customers" but it's "Orders" when the Dimension is "Products".

It sounds a bit odd i know, the actual scenario is a bit more complicated but this is the bit i'm not sure about.

Any pointers greatly appreciated.

Thanks
Bob.
Post #1453261
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse