Production/Consumption products cube
Page 1 of 1
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
Fact_Consumption
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.
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 |
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
Similar topics
» Modeling Financial Products
» Modelling Products with Stages
» Modeling products that *didn't* sell
» Designing Sales Promotion for Packed Products
» Modelling Sales of Products and Product Packs
» Modelling Products with Stages
» Modeling products that *didn't* sell
» Designing Sales Promotion for Packed Products
» Modelling Sales of Products and Product Packs
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum