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.