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

Inventory facts and production facts

2 posters

Go down

Inventory facts and production facts Empty Inventory facts and production facts

Post  exhortae Tue Jun 05, 2012 4:04 pm

Hi,

Considering they share the same dimensions, is it possible to put inventory facts and production facts in the same fact table ?

For example for a reseller :
- Number of items in stock.
- Number of item sold.

Thanks

exhortae

Posts : 30
Join date : 2010-08-01

Back to top Go down

Inventory facts and production facts Empty Re: Inventory facts and production facts

Post  ngalemmo Tue Jun 05, 2012 4:42 pm

Maybe in an aggregation, but I would not capture the data that way. Inventory and production are independent processes that occur at different times for different reasons. Capture each process independently into a star schema - each in their own fact table. Each fact would have its own load process, dimensions may be different, and it would be designed for the process it was capturing (timing, content, etc...). After facts have been loaded you could aggregate the facts to combine inventory and production information.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Inventory facts and production facts Empty Re: Inventory facts and production facts

Post  exhortae Wed Jun 06, 2012 6:53 am

Thank you

exhortae

Posts : 30
Join date : 2010-08-01

Back to top Go down

Inventory facts and production facts Empty Re: Inventory facts and production facts

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