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

Inventory Snapshot

2 posters

Go down

Inventory Snapshot Empty Inventory Snapshot

Post  jryan Wed Oct 24, 2012 6:19 am


I have to produce an Inventory Snapshot fact table that will need to be by Date, Product and Location. That should be easy enough.

However, there are lots of other dimensions that I've found out in the source system, such as the Supplier, Delivery Method, Delivery Vessel, Departure Port, Delivery Port, the PO, the Receipt Number etc.

Is there any reason why Supplier (for example) can't go in a Snapshot fact? All you would be holiding is the balance of inventory receieved from a supplier each day. I know that data volumes would probably be citied as a potential isssue, but is there any reason (if Supplier is suitable) not to include the others in the snapshot, such as Delivery Method?

Thank you in advance


Posts : 33
Join date : 2010-09-27

Back to top Go down

Inventory Snapshot Empty Re: Inventory Snapshot

Post  ngalemmo Thu Oct 25, 2012 5:54 pm

If the business segregates inventory by supplier, then yes, it would be an appropriate dimension. It is also not unusual to include bin or lot numbers.

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

Back to top Go down

Back to top

- Similar topics

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