Inventory Snapshot - GMROI Calculation

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

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.

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.