Scoped Assignments for mutiple measures

Hi,

   I have 15 measures in my cube. The name of Measures are like 'Sales1,Sales2....Sales10,Revenue1...Revenue5'. I have a calculated Dimension member. Let's say X.

  If I select X in the filter and Measurename starts with 'Sales' i need to apply a calculation.. Sales*10; Any idea would be greatly appreciated. In can write the scope statement for each sales measure but I want a single scope(or anything) that's enough for this calculation.

R

March 19th, 2015 3:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics