Sales Semantic Model

The Sales semantic model provides a consolidated, analytics-ready view of Sales Orders, Shipments, and Invoices. It centers on a unified sales fact (CUB_Sales) with role-based perspectives through dedicated measure groups for Orders, Invoices, and Shipments. Currency conversion is supported via target currency selection and daily exchange rates.

  • Dimensions: See a complete list in dimensions.
  • Facts: High-level description in facts.
  • KPIs/Measures: Full list grouped by folders in kpis.

Integration Highlights

  • Central fact table CUB_Sales containing all sales line transactions across Orders, Shipments, Invoices and Credit Memos.
  • Currency conversion via CurrencyTarget and CUB_ExchangeRate.
  • Order, Invoice, and Shipment perspectives implemented with separate measure tables: Measures Orders, Measures Invoice, Measures Shipment.