I am struggling in a model, maybe someone here can help me
Imagine that I have a sales fact table:
Date | ID_employee | ID_store | Sales
And I have a employee dimension:
ID_employee | ID_store | Name | Role
There are two possible roles: salesperson and supervisor
A salesperson has only one store.
The supervisor can have N stores. But his id_store is acctualy the id_store from the back office. There arent rows in the fact table with id_employee or id_store from a supervisor. I also have a table with the id_employee from the supervisors and the real stores they are responsible for.