Forum Discussion
Best Way for work with Multiple Fact Tables
thanks smizgier for your suggestion, at the moment I have two alternatives for this situation, one is that you mention, concatenate tables into one, but I think this technique is most useful when table structures are similar, the other option I am considering is to create a central table containing the fields in common dimension, allowing the joining of two or more fact tables against a common set of dimensions. To be more specific this technique consists of:
1- In the query editor get the fact tables and concatenate the common key dimension fields into one compuond key.
2- create a new aditional table by appending the distinct values from the fact tables. this will be the central table that contain the new compound key with the key dimension fields.
3- in the model, you have to link each fact table and each dimension table to the new central table
it seems that this works...
That's like creating a linked, right? it shud works.
Hope it works