Forum Discussion

Advocate IV

9 years ago

Solved

Switch measure based on slicer

I have a report that is using a ssas multidimensional cube as data source (live connection) I have two amount measures (local amount and euro amount) I want to have a slicer that I can use the cont...

Need Help

richbenmintz
9 years ago
You wil have to create the disconnected role playing dimension in the cube in the SSAS MD cube and use scoping or calculated measures to display the appropriate measure based on the currentmember of the role playing dimension

atul9063

Helper III

7 years ago

Hi ,

I m facing same issue ,can you please tell how you have created scope and calculated measures in cube to display the appropriate measure based on the currentmember of the role playing dimension