Forum Discussion

krisstok's avatar
krisstok
Frequent Visitor
4 years ago

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...
Need Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

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. 

krisstok's avatar
krisstok
Frequent Visitor
4 years ago

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?

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    krisstok 

    I would creat common bridge dimension tables to connect them. I would avoid direct many to many relationships as much as possible. This won't be the only issue. Other broblems will start to appear the further you go with your analysis