Linking tables in Data Model

[linoyel]

Hi,

I have sales, bonuses and calendar tables.

Sales table holds agent sales data per date. It's linked to the calendar on date field.

Bonuses table holds MONTHLY agent bonuses. It has only year and month fields, but not the date.

I'm supposed to show in a table monthly sales and bonuses for agents.

How am I supposed to link bonuses table to the sales table?

Only by agent_id is not enough, I also have to link some date field in order to link it right to the calendar...

Please help

[marcus_sommer]

In my case linking these tables didn't work always properly. Often yes but not always. If some areas have sales and none budget or some have budgets and none sales then this will lead to links against null. Therefore my tables are concatenated and all calculations are fine.

Set analysis couldn't be used without an aggregation function but it could by also only(). In your case I think you didn't need set analysis and a sum(bonus) will work, too.

- Marcus