Sales Order Backlog_measure Dimension

Return to Sales Model Overview.

This dimension contains stored and calculated measures for the sales order backlog. The sales order backlog measures are defined through their attributes:

Attribute

Definition

Name

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

Format

Number format for this account to be driven by the database. (string)

Conversion Type

Defines which exchange rate is used during currency conversion. Valid values are base elements of the Conversion Type dimension, e.g. Average, Month End, Month Start, and ~. Use ~ to suppress the currency conversion, e.g. for statistical figures like number of heads. (string)

See Fact Cube Using Currency Conversion and Configuration of Conversion Types

Calculation

Calculation rule. (string)

See also KPI Calculations for Sales Order Backlog Cube.

CalculationDependencies

Dependency for the calculation (string)

See also KPI Calculations for Sales Order Backlog Cube.

The dimension contains the following measures:

Element Definition
Order Amount Amount of the sales orders (numeric)
Order Count Number of sales orders – each order having a non-zero Order Amount or Order Quantity is counted as one. (calculated, numeric)
Order Quantity Quantity of the ordered items covered by the sales orders (numeric)
Average Order Amount Average order amount per order: Order Amount / Order Count (calculated, numeric)
Average Order Quantity Average order quantity per order: Order Quantity / Order Count (calculated, numeric)

The automatic calculation of Order Count works only if changes always affect the entire sales order. To support partial changes on the sales orders, the rule in the Calculation attribute of the Order Count element must be removed, and the initial value and changes of Order Count must be provided as physical values. Only the final part of a partial change must have an Order Count of one, while non-final changes must have an Order Count of zero.

This dimension is not subject to being configured.

Updated August 25, 2023