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