How to model target KPI Values in a Data Mart

View previous topic View next topic Go down

How to model target KPI Values in a Data Mart

Post  dazzwatkins on Mon Jan 31, 2011 3:06 am

The project I am working on has a requirement to report on actuals against targets. An example might be the number of sales calls made by a sales rep during the month for a specific customer compared to the targets set for that customer.

Is this effectively a new Fact table containing targets joined to the actuals through same dimension keys, but the major difference is that this table is a different grain.

The requirement would be to report on the actuals vs target each day and then at the end of the month product management monthly reports.

Any advice on best practice for this would be greatly appreciated.

dazzwatkins

Posts : 1
Join date : 2011-01-31

View user profile

Back to top Go down

Re: How to model target KPI Values in a Data Mart

Post  BoxesAndLines on Mon Jan 31, 2011 11:57 am

Yes, store targets in a different fact table and join on conformed dimensions.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum