Table of Contents

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 to Calendar and CurrencyTarget) for target currency calculations; CUB_ExchangeRate itself is modeled as a helper table, not a reporting fact.