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!