I have designed a many-to-many dimension which joins to main fact table using a mapping table that has keys from two other dimensions.
I am using all three dimensions (i.e. many-to-many dimension and other two dimensions) in one of the MDX query. I want the members of other two dimensions to get filtered automatically based on member selection in many-to-many dimension. Please let
me know how to achieve this.
Thanks in advance
View Complete Post