Facts

This article provides information on the fact tables used within the Power BI semantic model. These tables contain the transactional data that forms the basis for demand planning analysis.

CUB_Inventory

The inventory fact table contains historical inventory transactions and forms the basis for on-hand calculations and inventory KPIs.

Base Tables:

• Item Ledger Entry
• Value Entry

Among others, it primarily uses the following fields for measure calculations:

• ItemLedgerEntryQuantity
• CostPostedToGL
• CostAmountActual
• CostAmountExpected

Note

Posting Date is used for the Calendar dimension relationship. This fact table uses time intelligence for historical analysis (ATD - All Time Data).

CUB_Planning__Demands

This fact table contains all demand transactions from various sources, essential for material requirements and identifying potential stock shortages.

Base Tables:

• Sales Line
• Prod. Order Component
• Service Line
• Purchase Line (Return)
• Planning Component
• Transfer Line
• Job Planning Line
• Production Forecast Entry

Note

Expected Receipt Date or Due Date is used for the Calendar dimension relationship. Demand values are represented as negative quantities.

CUB_Planning__Supplies

This fact table contains all supply transactions from various sources, critical for understanding expected inventory receipts and production completions.

Base Tables:

• Sales Line (Return)
• Purchase Line
• Prod. Order Lines
• Requisition Line
• Transfer Line
• Assembly Line

Note

Expected Receipt Date or Due Date is used for the Calendar dimension relationship. Supply values are represented as positive quantities.

CUB_ReservationEntry

This fact table contains reservation entries created by the Material Requirements Planning (MRP) system, showing the detailed matching between supply and demand.

Base Tables:

• Reservation Entry

Purpose:

• Tracks MRP-created reservations
• Shows supply-demand matching
• Calculates availability balance after MRP run
• Identifies reserved quantities

Key Information:

• Source of reservation (demand or supply)
• Quantity reserved
• Reservation status
• Item and location
• Related document information

Note

This table is primarily used for comparison against expected on-hand balance of raw data, derived from the system.

CUB_WeeklyHistoricDemand

This fact table aggregates historical demand data on a weekly basis, used for statistical analysis.

Purpose:

• Historical demand patterns
• Statistical analysis for ABC/XYZ classification
• Demand variability calculations

Note

This table provides aggregated historical data to support demand classification and replenishment parameter optimization.

CUB_ProductionOrders

This fact table contains production order transactions.

Base Tables:

• Production Order

CUB_Production__CLE (OutputFinalOps)

This fact table contains capacity ledger entries specifically for final operation outputs in production orders.

Base Tables:

• Capacity Ledger Entry

Purpose:

• Final operation completion tracking
• Production completion date analysis
• Production duration calculations

CUB_PurchReceipt

This fact table contains purchase receipt transactions for analyzing purchase order lead times.

Base Tables:

• Purch. Rcpt. Header
• Purch. Rcpt. Line

Purpose:

• Purchase receipt tracking
• Purchase lead time analysis