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.