Forum Discussion

May_24's avatar
May_24
Frequent Visitor
1 year ago

Data Modeling for Specific project

Good Greetings, I have two fact tables. The first contains Sales Representative Expenses and other details, and the second contains Sales details. I want to connect the shops in both tables to ge...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for mh2587's concern about this issue.

 

Hi, May_24 

You can refer to the method provided by mh2587 .


Or you can also add unique identifiers for Shops to differentiate between stores with different Brand and Branch.


Of course you can also add Branch ID and Brand ID in Shops-Rep-Dim to accurately map the relationship.

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.