KPIs

This article provides information on the available KPIs (Measures) within the Sales semantic model. Measures are grouped by functional area and aligned with the Demand Planning documentation structure.

Sales KPIs (_Measures)

Name	Description
Sales Amount	Net sales in target currency including header end discount.
Sales Quantity	Total sold quantity (base unit).
Sales Cost Amount	Cost of sales in target currency.
Profit Margin	Sales Amount minus Sales Cost Amount.
Profit Margin %	Profit Margin divided by Sales Amount.
Sales Amount Gross	Quantity × Unit Price (gross, before discounts).
Gross Weight	Gross weight (base).
Sales Line Discount	Line discount amount in target currency.
Sales Header End Discount	Header end discount amount in target currency.

Time Intelligence (explicit KPIs)

Name	Description
Sales Amount PY	Prior year value of Sales Amount.
Sales Amount YoY	Year-over-year change of Sales Amount (absolute).
Sales Amount YoY %	Year-over-year change of Sales Amount (percentage).
Sales Quantity PY	Prior year value of Sales Quantity.
Sales Quantity YoY	Year-over-year change of Sales Quantity (absolute).
Sales Quantity YoY %	Year-over-year change of Sales Quantity (percentage).
Profit Margin PY	Prior year value of Profit Margin.
Profit Margin YoY	Year-over-year change of Profit Margin (absolute).
Profit Margin YoY %	Year-over-year change of Profit Margin (percentage).
Profit Margin % PY	Prior year value of Profit Margin %.
Profit Margin % YoY	YoY change of Profit Margin % (percentage points).

Average Amounts

Name	Description
Sales Amount Ø PerUnit	Sales Amount divided by Sales Quantity.
Sales Amount Ø PerUnit PY	Prior year value of Sales Amount Ø PerUnit.
Sales Amount Ø PerUnit YoY	YoY change of Sales Amount Ø PerUnit (absolute).
Sales Amount Ø PerUnit YoY %	YoY change of Sales Amount Ø PerUnit (percentage).

Counts

Name	Description
# Unique Items	Distinct count of invoiced items.
# Unique Items PY	Prior year value of # Unique Items.
# Unique Items YoY	YoY change of # Unique Items (absolute).
# Unique Items YoY %	YoY change of # Unique Items (percentage).
# Unique Invoice Customers	Distinct count of invoice customers.
# Unique Invoice Customers PY	Prior year value of # Unique Invoice Customers.
# Unique Invoice Customers YoY	YoY change of # Unique Invoice Customers (absolute).
# Unique Invoice Customers YoY %	YoY change of # Unique Invoice Customers (percentage).

Orders KPIs (Measures Orders)

Name	Description
Order Amount	Sales amount for orders (excl. discounts filter context).
Order Amount Gross	Quantity × Unit Price from orders (gross).
Order Cost Amount	Cost amount for orders.
Order Gross Weight	Gross weight from orders.
Order Line Discount	Line discount amount from orders.
Order Profit Margin	Order Amount minus Order Cost Amount.
Order Quantity	Sales quantity from orders.
Order Header End Discount	Header end discount from orders.
Order Amount Open	Order Amount for open orders (status = Open).
Order Amount Open PY/YoY/YoY %	TI variants of Order Amount Open.
Order Amount Plan	Plan value placeholder (blank).

Discounts

Name	Description
Order Discount	Order Line Discount + Order Header End Discount.
Order Discount %	Order Discount divided by Order Amount.

Counts

Name	Description
# Unique Orders	Distinct count of orders.
# Unique Orders PY/YoY/YoY %	TI variants of # Unique Orders.
# Unique Order Customers	Distinct count of order customers.
# Unique Order Customers PY/YoY/YoY %	TI variants of # Unique Order Customers.

Average Amounts

Name	Description
Ø Order Amount	Order Amount divided by # Unique Orders.
Ø Order Amount PY/YoY/YoY %	TI variants of Ø Order Amount.
Ø Sales Price per Unit	Order Amount divided by Order Quantity.
Ø Sales Price per Unit PY/YoY/YoY %	TI variants of Ø Sales Price per Unit.

Customer Analytics

Name	Description
Ø Order Frequency (Days)	Average days between first and last order in period divided by number of orders (per customer).
# New Customers	Count of customers with first order date in current period, with TI variants.
# New Customers PY/YoY/YoY %	TI variants of # New Customers.

Formatting (IBCS and YoY)

Name	Description
Ø Order Amount YoY CF/Icon	Conditional formatting and icon helpers for YoY.
# Unique Order Customers YoY CF/Icon	Conditional formatting and icon helpers for YoY.
Order Amount Open YoY CF/Icon	Conditional formatting and icon helpers for YoY.
Order Amount Delta	Difference vs PY or Plan (if available).
Order Amount Delta %	Percentage difference vs PY.
Order Amount MaxValue/RedMax/GreenMax	Dynamic axis helpers for IBCS visuals.
Order Amount DeltaColor	Color helper based on delta sign.

Invoices KPIs (Measures Invoice)

Name	Description
Invoice Amount	Sales amount for invoices (excl. discounts filter context).
Invoice Amount Gross	Quantity × Unit Price from invoices (gross).
Invoice Cost Amount	Cost amount for invoices.
Invoice Gross Weight	Gross weight from invoices.
Invoice Line Discount	Line discount amount from invoices.
Invoice Profit Margin	Invoice Amount minus Invoice Cost Amount.
Invoice Profit Margin %	Profit margin percentage on invoices.
Invoice Unit Price	Invoice Amount divided by Invoice Quantity.
Invoice Amount PY/YoY/YoY %	TI variants of Invoice Amount.
Invoice Profit Margin PY/YoY/YoY %	TI variants of Invoice Profit Margin.
Invoice Amount Plan	Plan value placeholder (blank).

Discounts

Name	Description
Invoice Header End Discount	Header end discount from invoices.
Invoice Discount	Invoice Line Discount + Invoice Header End Discount.
Invoice Discount %	Invoice Discount divided by Invoice Amount.

Counts

Name	Description
# Unique Invoices	Distinct count of invoices, with TI variants.
# Unique Invoices PY/YoY/YoY %	TI variants of # Unique Invoices.
# Invoice Lines	Count of invoice lines.
# Unique Items Invoiced	Distinct count of items on invoices, with TI variants.
# Unique Items Invoiced PY/YoY/YoY %	TI variants of # Unique Items Invoiced.

Daily Sales

Name	Description
Daily Sales Moving Ø 7D	7-day moving average of Invoice Amount.
Daily Sales Moving Ø 7D ∆/∆%	Change vs prior 7–14 day window (absolute and %).
Daily Sales Moving Ø 7D PY	Prior year 7-day moving average.
Daily Sales Today/Today-1/Today-2	Daily values for the latest three days.

Credit Memos

Name	Description
CrMemo Amount	Credit memo amount, with TI variants.
# Unique CrMemos	Distinct count of credit memos.
# CrMemo Lines	Count of credit memo lines.

Shipments KPIs (Measures Shipment)

Name	Description
Shipment Amount	Sales amount for shipments (excl. discounts filter context).
Shipment Amount Gross	Quantity × Unit Price from shipments (gross).
Shipment Cost Amount	Cost amount for shipments.
Shipment Gross Weight	Gross weight from shipments.
Shipment Line Discount	Line discount amount from shipments.
Shipment Profit Margin	Shipment Amount minus Shipment Cost Amount.
Shipment Quantity	Sales quantity from shipments.
Shipment Amount/Cost/Gross/Line/Profit/Quantity PY/YoY/YoY %	TI variants for shipment measures.
OTD Rate	On-time delivery rate based on promised vs shipment date, with TI variants.

Time Intelligence Variants

Most base measures provide TI variants using the TimeIntelligence calculation group:

Variant	Description
PY	Prior year comparison (same period last year).
YoY	Year-over-year change (absolute difference).
YoY %	Year-over-year change (percentage).

Notes

• Currency conversion is applied in base measures via CurrencyTarget and CUB_ExchangeRate.
• Technical and formatting measures support data visualizations (color, icons, and IBCS helpers) and are not listed.