Hi All,
I am New to SSAS, got chance to work in Existing SSAS Cubes, In Dimension Usage tab, they mentioned dimension relations like (Regular, Many-to-Many,Fact, referenced). I understood the Regular, Referenced relations by writing the SQL Queries to Cross check, but I could not understand the Many-To-Many & Fact Dimension relationship.
Can anybody please explain the the Many-To-Many & Fact Dimension relationship how to write SQL query to cross check the Relationships.
Thanks in advance.