Facts
This module uses a central fact table for sales analytics.
CUB_Sales (Sales Fact)
- Purpose: Unified sales line transactions across Orders, Shipments, Invoices and Credit Memos.
- Grain: One row per sales line; role-based views through measures.
- Main Source(s):
Sales Line,Sales Line Archive,Sales Invoice Line,Sales Cr. Memo Line,Sales Shipment Line.
Notes
- Currency conversion uses
CUB_ExchangeRate(linked toCalendarandCurrencyTarget) for target currency calculations;CUB_ExchangeRateitself is modeled as a helper table, not a reporting fact.