Forum Discussion
Relationships in Direct Query Mode
best regards, I would be very grateful if someone could help me with this case, I have the tables to relate, a representation of sales by the seller and the other budgets, the table of budgets has th...
In your scenario, it seems you have Sales and Budgets tables which are fact tables. You should have other dimension tables like DimSeller, DimProduct, etc, and build the relationships to those fact tables based on the key column with unique values in dimension tables. It can became a snowflake/star schema. You can refer to AdventureWorksDW sample database.
Regards,