Search code examples
many-to-manyssasolapcube

SSAS Many-to-Many relation without bridge table

Is it possible to do a many-to-many relation without a bridge table in SSAS ? I have one fact table with SubjectId and another fact table with FK_SubjectId and many others keys (related to others dimensions).

In my view datasource the two fact table are connected to each other, but I can't chose the many-to-many relationship in the dimension tab ?

I'm I missing something maybe ?

Thanks a lot.

Solution

  • You would at least have to define an intermediate dimension. This can be defined based on the first of the fact tables, and can have the SubjectId as its only attribute. And this could be invisible to users. But Analysis Services requires an intermediate dimension for many-to-many relationships.