Forum Discussion

RRaj_293's avatar
RRaj_293
Icon for Helper III rankHelper III
2 years ago
Solved

Data Modelling Issue (Many to Many between Fact and Dimension)

Hello ,    Please help with the below data modelling question-   I have a fact table called purchase Order and few other dimensions connected in star schema . Now I have brought in a connection t...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Burhan_Jiru's avatar
    Burhan_Jiru
    2 years ago

    Hi,

    try creating a bridge/factless fact table it will solve your many to many relationship problem.
    if your don't know about bridge/factless fact table you can search on google that how to build one and what are the use cases of it.

     

    I hope this is helpfull

    thank you

RRaj_293's avatar
RRaj_293
Icon for Helper III rankHelper III
2 years ago

Hi , Thank you all for responding. A bridge table did not resolve it. I went with a M-M bi-directional join and enabled the 'show items with no data' so this gave me the expected results of a left outer join by bringing in only the program codes of the Purchase order used from fact.