asked
Many to Many relationship in SSAS cube
I have a situation in SSAS. In RDBMS DB I have three tables Country, States and Cities. User can see all the cities for a state within a Country. My solution for this in T-SQL is working fine but I am unable to implement this in SSAS Cube (SS 2008). Need help. Thanks, Anil
Need more information to answer this, however SSAS Multidimensional natively supports many 2 many dimensions. Dependant on how your data is structured - you can set up this relationship within the dimension usage area of your cube design. Instead of created a Regular dimension, you select Many 2 Many dimension and select the joining dimension table. in Tabular things are so straight forward but it can also be achieved there. This is by creating a specific M2M measure that filters the other side of the M2M dimension. There are quite a few articles on this, and it's reasonably achievable once you get to grips with the concept of Calculate, Calculate Table and filter DAX commands. Enjoy!
13 People are following this question.
