Forum Discussion
Solved
Star Schema problem with relationship
Good Tuesday from Italy for all readers of the forum & apologize for my bad English from my datawerehouse i export two tables: Sales Product i have created a CalendarTable to filter my data by...
Hi mammifero,
Yes, I think you need to create 'agent' bridge table based unique agent id from three tables.
Tables which you listed on snapshots are linked with date key. If you create relationship with one table on agent id, it will filter current table with agent id and use related datekey to filter another table.
Regards,
Xiaoxin Sheng
Hi mammifero,
Yes, I think you need to create 'agent' bridge table based unique agent id from three tables.
Tables which you listed on snapshots are linked with date key. If you create relationship with one table on agent id, it will filter current table with agent id and use related datekey to filter another table.
Regards,
Xiaoxin Sheng