Forum Discussion

alexanderg's avatar
alexanderg
Advocate II
10 years ago

Best Way for work with Multiple Fact Tables

Hi everybody!!   which is the best technique for working with models that have multiple fact tables and so get a star schema?. For example, in QlikView there is a technique called "linktable".   ...
Need Help
Show and Tell
Tips and Tricks
anagnostes's avatar
anagnostes
Frequent Visitor
9 years ago

I have a model that worked fine. Now I have to add some new fact tables (Adwords data) and I ended up with circular dependencies that I should solve so I can use the data in the dashboard:

 

The problems in my new model is something like this:

 

 

 

So what could be the solution to remove the circular dependencies? My issue is that my current model is working now, so i would like to fix the Adwords part without touching the less possible of the Orders part.

 

Thank you. 

Chris12's avatar
Chris12
Advocate I
8 years ago

I'm new to this so take it with a grain of salt...

 

Seems to me that duplicating the Calendar table would solve your problem, indeed improve your model since the order dates and "adword dates" shouldn't be collapsed?!

  • vikrantarora25's avatar
    vikrantarora25
    Helper I
    6 years ago

    Chris12 that's not required, if you have 2 or more date columns in same table (like order date & ship date) then you need another date dim table. A single date dim table can be connected to 2 fact tables no prblem with that.