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

Inventory Snapshot - GMROI Calculation

3 posters

Go down

Inventory Snapshot - GMROI Calculation Empty Inventory Snapshot - GMROI Calculation

Post  Sophie Wed Nov 11, 2009 5:00 pm

We are developing a solution for our company. We currently have a sales cube and we are in the process of building an inventory cube. We are having a design problem in that we are not sure if we should include some of the measures which currently exist in the sales fact table (Qty Sold and Latest Selling Price) in the inventory snapshot table.

We are thinking of creating a separate cube for inventory and defining GMROI as a linked measure group using both sales and inventory cube.
What's the best practice in this area? Should we add the required fields for calculating GMROI to the inventory on hand fact table even though they are already in the sales fact?

Many Thanks,

Sophie

Sophie

Posts : 3
Join date : 2009-06-28

Back to top Go down

Inventory Snapshot - GMROI Calculation Empty Re: Inventory Snapshot - GMROI Calculation

Post  kapoor_dh Wed Dec 09, 2009 1:47 am

If the 2 facts (sales and inventory) are joined thru the conformed dimensions which are used to build the cube(which enforces that the 2 fact tables are at the same granularity level) then the measures of sales can be included in the inventory for the better performance or else they can be accessed thru the dimension key which are shared across.

If the granularity of the 2 facts currently is different for ex: if sales fact is at the poroduct category level and inventory fact is at the product level,and you still want to report both of them at the same level say product category,an aggregate or a Mat view can be formed and then a cube can be built out of it.

Hope I am clear.

kapoor_dh

Posts : 24
Join date : 2009-12-08

Back to top Go down

Inventory Snapshot - GMROI Calculation Empty Re: Inventory Snapshot - GMROI Calculation

Post  ngalemmo Wed Dec 09, 2009 7:02 pm

Since inventory is a snapshot, it would not hurt to include a snapshot of sales data in the fact table (or cube) itself. If you were dealing with other types of transactional data, rather than a snapshot, it would be better to maintain detail separately and aggregate the subject areas into a new fact/cube.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Inventory Snapshot - GMROI Calculation Empty Re: Inventory Snapshot - GMROI Calculation

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