Forum Discussion
Data model doesnt work when adding a 3rd relationship
I am creating a relationship between my main fact table HW Inventory and 3 other tables. All of the tables have a serial numbers I am making the relationship on. Here is the model that *Should* wor...
Ask yourself which of your tables are fact tables and which are dimension tables. Try not to join fact tables directly. Instead, have all your fact tables controlled by the dimension tables.