Forum Discussion
Modeling relation fact table / dimension table with missing keys
I want to improve an existing model that produces some errors during data preparation. Here's the scenario: I have a "sales line" table that includes a "product number" column and the user shoul...
HI Anonymous ,
In my opinion, I'd like to suggest you to use method 2 to achieve your scenario, it can work as a bridge table and link with other tables.
BTW, if you do not add too many fields to this table, it doesn't affect the performance of your report.Regards,
Xiaoxin Sheng
HI Anonymous ,
In my opinion, I'd like to suggest you to use method 2 to achieve your scenario, it can work as a bridge table and link with other tables.
BTW, if you do not add too many fields to this table, it doesn't affect the performance of your report.
Regards,
Xiaoxin Sheng