Forum Discussion
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 Year/Month
BUT
if i want to create a filter in my report for "agente" (sales vendor) connected to both table (Sales & Product)
what i have to do ?
i have to create another table ?
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
1 Reply
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