Inventory facts and production facts

View previous topic View next topic Go down

Inventory facts and production facts

Post  exhortae on 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

View user profile

Back to top Go down

Re: Inventory facts and production facts

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Inventory facts and production facts

Post  exhortae on Wed Jun 06, 2012 6:53 am

Thank you

exhortae

Posts : 30
Join date : 2010-08-01

View user profile

Back to top Go down

Re: Inventory facts and production facts

Post  Sponsored content


Sponsored content


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