Forum Discussion
Get all data from one table, not only matched in data model
Hi, I need help to get all data from one table not only matched. Here is my data model. I got one table with revenue (Sales) and one table with budget (BudgetPM). They are joined by key like 20...
Hi krisstok
it is all in the data model. Don't create relationships between fact tables. Date table can filter Sales and can filter BudgetPM directly. Same for VendorDict.
tamerj1 BudgetPM contains salesmanID, category and dateKey. I can't create relationship with calendar table only by dates, It would not match on salesman and category filters in sales table.
Also:
- sales is by date (year/month/day) / salesman / product category related to salesman
- budget is by year / months (no days) / salesman / product category related to salesman
VendorDict is a dimension table.
How should I create data model to work it well?