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 purchasing analysis.

CUB_Purch

The consolidated purchasing fact table that combines orders, receipts, invoices, and credit memos into one model for end-to-end procurement analysis. It provides measures for amounts, quantities, discounts, cost amounts, and gross weight, with built-in currency conversion.

Base Tables (BC):

• Purchase Line
• Purch. Rcpt. Line
• Purch. Inv. Line
• Purch. Cr. Memo Line

Key Information:

• Amounts (net and gross), discounts (line and header), cost amount
• Quantities and gross weight
• Currency conversion via exchange rates (target vs. local currency)
• Document identifiers (Order, Receipt, Invoice) and vendor/item keys
• Multiple date roles for analysis (Order, Requested/Promised/Planned/Expected Receipt, Receipt, Invoice, Document)

Note

Use the dimension Purchase Document Type to slice measures into Orders, Receipts, and Invoices; dedicated measure groups are provided for each scenario.