How do I write a Query In TSQL for Dimension Realtionships

See more:

SQL

MSBI

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.