Forum Discussion
Advocate IVSwitch 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 controll if the local or euro measure should be used in the vizuals
Is this posdible?
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
8 Replies
- GilbertQ
Super User
Hi jockefe
You can do this using a disconnected table. And if you are doing this with DirectQuery I am not 100% sure if you can create the table. But if you can, follow this blog post below which explains how to achieve this.
http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/
richbenmintzResident Rockstar
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
jockefe
richbenmintz wrote: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
Thanks, I think what I need to do is to create a measure that will return different "measures" depending on a dimension value
- jockefe
@guavaq wrote:Hi jockefe
You can do this using a disconnected table. And if you are doing this with DirectQuery I am not 100% sure if you can create the table. But if you can, follow this blog post below which explains how to achieve this.
http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/
Hinot sure if this will work in case where I use a live connection to an OLAP mutidim database
Am I able to create the new measures?
