Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

How to model target KPI Values in a Data Mart

2 posters

Go down

How to model target KPI Values in a Data Mart Empty How to model target KPI Values in a Data Mart

Post  dazzwatkins 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

Back to top Go down

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

Post  BoxesAndLines Mon Jan 31, 2011 11:57 am

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

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

Back to top Go down

Back to top

- Similar topics

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