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

Multiple fact tables

3 posters

Go down

Multiple fact tables Empty Multiple fact tables

Post  dellsters Wed Jul 21, 2010 4:08 pm

I have forecast and actuals information about budget. They would all share most of the dimensions and would have the same fact attributes. What are the benefits/ downsides of having a fact table for forecast, and another fact table for actuals vs. having one fact table and a dimension attribute that differentiates whether the fact record is a forecast or actual?

dellsters

Posts : 39
Join date : 2009-02-11

Back to top Go down

Multiple fact tables Empty Re: Multiple fact tables

Post  hang Thu Jul 22, 2010 7:03 am

It really depends on wether they share the same grains and dimensionality in both actual and budget facts. Normally the budget has been made on aggregate level (eg. month) and the actuals may take place at more granular level, say daily. So the consolidated fact might only be applicable at aggregate level for the actuals. You could also use views to cater for the same objective if they live in separate tables.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

Back to top Go down

Multiple fact tables Empty Re: Multiple fact tables

Post  ngalemmo Thu Jul 22, 2010 11:26 am

As Hang mentioned its all about the grain.

If this is GL data (account balances, not journals), then you should be able to use a single fact with a ledger type dimension (actual, budget(s), forecast(s)). If you are maintaining journal data (actuals only) this would be in its own fact. If you have both, the journal fact should include the ledger type dimension so you can easily reconcile the journal facts with the balances.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Multiple fact tables Empty Re: Multiple fact tables

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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