Production/Consumption products cube

Hi everyone,

I need some advices about a cube implementation. I have to implement a cube concerning production quantities AND production consumption quantities of elements consumed from the same product dimension.

So I cerated two fact tables Fact_Production and Fact_Consumption.

Fact_Production

ProductDimension_Key

ProductionDate_Key

Company_Key

ProductionDate_Key

Warehouse_Key

ProductionScheduledQuantity

ProducedQuantity

Fact_Consumption

ProductDimension_Key

ConsumedProductDimension_Key

ProductionDate_Key [/td

Company_Key

ProductionDate_Key

Warehouse_Key

ConsumptionScheduledQuantity

ConsumedQuantity

1) First I'm not sure if the implementation of company dimension is necessary in the fact table, or I have just to add company as attribute in each dimension (companies can have the same production process with same products and same consumed products)

2) The second problem is that in a specific date, I can have a production without any consumed product and consumption without production until the end of the process. So when I create the cube grouping the two tables I have some confusing aggregations with lot of nulls.

Any help or best practices advices ?

Best regards.