Facts
This article provides information on the used facts within the Power BI semantic model.
CUB_Inventory
Contains the base measures for calculating respective KPIs. The CUB_Inventory is primarily based on following Business Central 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 Calendar relation.