Forum Discussion

alexanderg's avatar
alexanderg
Icon for Advocate II rankAdvocate 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
Icon for Advocate I rankAdvocate 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?!