Solved: Star Schema problem with relationship

mammifero · ‎08-28-2018

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 ?

Anonymous · ‎08-28-2018

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

View solution in original post

Anonymous · ‎08-28-2018

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