Sales Order Status Dimension

Return to Sales Model Overview.

The Sales Order Status dimension shows the opening backlog, changes, and final backlog for the three stages of sales orders.

The sales order status elements are defined through their attributes:

Element Attribute
Name Readable name of the cost center. Localized translations can be provided. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string)
AggregationType

Semi-additive measure behavior. (string)

Valid values are:

  • (empty): Regular additive behavior
  • First: First child
  • Last: Last child
  • Avg: Average of children

Opening Backlog

In yyyy-01-01 in Day dimension: initial backlog of sales orders at the beginning of a year; must be empty in other base elements of Day dimension.

If fiscal year doesn’t start in January, and if the sales order backlog is to be monitored from a fiscal year perspective, the initial value is stored in FYyyyy-00 instead. (numeric)

Order Intake

Incoming sales orders

Order Cancellation

Cancellation or reduction of sales orders.

Shipments

Full or partial delivery of sales orders

Returns

Returns of shipments

Backlog

Backlog for a given day. Must be read on the YTD element for the day. Consolidated from the initial value plus all increases (Order Intake and Returns) minus all decreases (Order Cancellation and Shipments) since the beginning of the year.

If fiscal year doesn’t start in January, and if the sales order backlog is to be monitored from a fiscal year perspective, the final value must be read in FYyyyy-00_YTD instead. (consolidated, numeric)

Opening Backlog Non-Invoiced

In yyyy-01-01 in Day dimension: initial backlog of non-invoiced sales orders at the beginning of a year; must be empty for other base elements in Day dimension.

If fiscal year doesn’t start in January, and if the sales order backlog is to be monitored from a fiscal year, perspective, the initial value is stored in FYyyyy-00 instead. (numeric)

Invoices

Invoices on sales orders

Credit Notes

Credit notes on invoices on sales orders

Backlog Non-Invoiced

Backlog of non-invoiced sales orders for a given day. Must be read in the YTD element for the day. Consolidated from the initial value plus all increases (Shipments and Credit Notes) minus all decreases (Returns and Invoices) since the beginning of the year.

If fiscal year doesn’t start in January, and if the sales order backlog is to be monitored from a fiscal year perspective, the final value must be read in FYyyyy-00_YTD instead. (consolidated, numeric)

Opening Backlog Open Payments

In yyyy-01-01 in Day dimension: initial backlog of open payments at the beginning of a year; must be empty in other base elements in Day dimension.

If fiscal year doesn’t start in January, and if the sales order backlog is to be monitored from a fiscal year perspective, the initial value is stored in FYyyyy-00 instead. (numeric)

Payments

Received customer payments for sales orders

Backlog Open Payments

Backlog of open payments for a given day. Must be read in the YTD element for the day. Consolidated from the initial value plus all increases (Invoices) and minus all decreases (Credit Notes and Payments) since the beginning of the year.

If fiscal year doesn’t start in January, and if the sales order backlog is to be monitored from a fiscal year perspective, the final value must be read in FYyyyy-00_YTD instead. (consolidated, numeric)

This dimension is not subject to configuration.

Updated July 8, 2024