Demand Planning Semantic Model
The Demand Planning module is built as a star schema: a central fact table surrounded by descriptive dimensions, with reusable measures and built-in time intelligence.
Generated from CA4BCF Demand Planning Model.SemanticModel.
At a glance
| Element | Count |
|---|---|
| Fact tables | 3 |
| Dimensions | 33 |
| Measures (KPIs) | 348 |
| Relationships | 99 |
Fact tables
Dimensions
The model provides 33 dimensions for slicing and filtering. See Dimensions for the full list and per-dimension details.
Relationships (star)
Relationships connecting the fact table(s) to their dimensions:
| From | To |
|---|---|
| CUB_Inventory[ClientBK] | Client[ClientBK] |
| CUB_Inventory[CustomerBK] | Customer[CustomerBK] |
| CUB_Inventory[DatabaseSourceBK] | DatabaseSource[DatabaseSourceBK] |
| CUB_Inventory[DataCategoryBK] | DataCategory[DataCategoryBK] |
| CUB_Inventory[CurrencySourceBK] | CurrencySource[CurrencyBK] |
| CUB_Inventory[DataSourceBK] | DataSource[DataSourceBK] |
| CUB_Inventory[DateBK] | Calendar[DateBK] |
| CUB_Inventory[Dimension1BK] | Dimension1[Dimension1BK] |
| CUB_Inventory[Dimension2BK] | Dimension2[Dimension2BK] |
| CUB_Inventory[Dimension3BK] | Dimension3[Dimension3BK] |
| CUB_Inventory[Dimension4BK] | Dimension4[Dimension4BK] |
| CUB_Inventory[Dimension5BK] | Dimension5[Dimension5BK] |
| CUB_Inventory[Dimension6BK] | Dimension6[Dimension6BK] |
| CUB_Inventory[EmployeeBK] | Employee[EmployeeBK] |
| CUB_Inventory[InventLocationBK] | InventLocation[InventLocationBK] |
| CUB_Inventory[InventTransactionStatusBK] | InventTransactionStatus[InventTransactionStatusBK] |
| CUB_Inventory[InventTransTypeBK] | InventTransType[InventTransTypeBK] |
| CUB_Inventory[ItemBK] | Item[ItemBK] |
| CUB_Inventory[VendorBK] | Vendor[VendorBK] |
| CUB_Inventory[InventVoucherBK] | InventVoucher[InventVoucherBK] |
| CUB_Inventory[ProductionOrderBK] | ProductionOrder[ProductionOrderBK] |
| CUB_Inventory[ProductionOrderLineBK] | CUB_ProductionOrders[ProductionOrderLineBK] |
| CUB_Inventory[SKUBK] | StockkeepingUnit[SKUBK] |
| CUB_Planning__Demands[ItemBK] | Item[ItemBK] |
| CUB_Planning__Supplies[ItemBK] | Item[ItemBK] |
| CUB_Planning__Demands[SKUBK] | StockkeepingUnit[SKUBK] |
| CUB_Planning__Supplies[SKUBK] | StockkeepingUnit[SKUBK] |
| CUB_Planning__Demands[DemandDateBK] | Calendar[DateBK] |
| CUB_Planning__Supplies[SupplyDate] | Calendar[DateBK] |
| CUB_Planning__Demands[InventLocationBK] | InventLocation[InventLocationBK] |
| CUB_Planning__Supplies[InventLocationBK] | InventLocation[InventLocationBK] |
| CUB_Planning__Demands[CustomerBK] | Customer[CustomerBK] |
| CUB_Planning__Supplies[CustomerBK] | Customer[CustomerBK] |
| CUB_Planning__Demands[DatabaseSourceBK] | DatabaseSource[DatabaseSourceBK] |
| CUB_Planning__Supplies[DatabaseSourceBK] | DatabaseSource[DatabaseSourceBK] |
| CUB_Planning__Demands[DataSourceBK] | DataSource[DataSourceBK] |
| CUB_Planning__Supplies[DataSourceBK] | DataSource[DataSourceBK] |
| CUB_Planning__Demands[VendorBK] | Vendor[VendorBK] |
| CUB_Planning__Supplies[VendorBK] | Vendor[VendorBK] |
| CUB_Planning__Demands[ClientBK] | Client[ClientBK] |
| CUB_Planning__Supplies[ClientBK] | Client[ClientBK] |
| CUB_Planning__Demands[UnitBK] | Unit[UnitBK] |
| CUB_Planning__Supplies[UnitBK] | Unit[UnitBK] |
| CUB_Planning__Demands[Dimension1BK] | Dimension1[Dimension1BK] |
| CUB_Planning__Demands[Dimension2BK] | Dimension2[Dimension2BK] |
| CUB_Planning__Demands[Dimension3BK] | Dimension3[Dimension3BK] |
| CUB_Planning__Demands[Dimension4BK] | Dimension4[Dimension4BK] |
| CUB_Planning__Demands[Dimension5BK] | Dimension5[Dimension5BK] |
| CUB_Planning__Demands[Dimension6BK] | Dimension6[Dimension6BK] |
| CUB_Planning__Supplies[Dimension1BK] | Dimension1[Dimension1BK] |
| CUB_Planning__Supplies[Dimension2BK] | Dimension2[Dimension2BK] |
| CUB_Planning__Supplies[Dimension3BK] | Dimension3[Dimension3BK] |
| CUB_Planning__Supplies[Dimension4BK] | Dimension4[Dimension4BK] |
| CUB_Planning__Supplies[Dimension5BK] | Dimension5[Dimension5BK] |
| CUB_Planning__Supplies[Dimension6BK] | Dimension6[Dimension6BK] |
| CUB_Planning__Demands[ProductionOrderBK] | ProductionOrder[ProductionOrderBK] |
| CUB_Planning__Supplies[ProductionOrderBK] | ProductionOrder[ProductionOrderBK] |
| CUB_Inventory[ReceiptLineBK] | CUB_PurchReceipt[ReceiptLineBK] |
| CUB_Planning__Demands[OrderBK] | SalesOrder[OrderBK] |
| CUB_Planning__Demands[ProductionOrderLineBK] | ProductionOrderLines[ProductionOrderLineBK] |
| CUB_Planning__Supplies[ProductionOrderLineBK] | ProductionOrderLines[ProductionOrderLineBK] |
| CUB_Planning__Supplies[OrderBK] | SalesOrder[OrderBK] |
| CUB_Planning__Demands[PurchaseOrderBK] | PurchaseOrder[PurchaseOrderBK] |
| CUB_Planning__Supplies[PurchaseOrderBK] | PurchaseOrder[PurchaseOrderBK] |
Build your own analysis
All measures and dimensions above are available in Power BI. Start from the KPIs catalog and combine measures with any dimension to answer your own questions.