Cube question - Swapping Measure Depending on Dimension being used?

• bob pearman

  Mr or Mrs. 500

  Points: 567

  More actions

  May 15, 2013 at 1:43 pm

  #293356

  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.