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

Production/Consumption products cube

Go down

Production/Consumption products cube Empty Production/Consumption products cube

Post  Aigass Mon Mar 16, 2015 12:35 pm

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.

Aigass

Posts : 1
Join date : 2015-03-16

Back to top Go down

Back to top

- Similar topics

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