Unit of Measure

Unit of Measure elements represent the measurement types that are used in Financial Reporting. You can import those elements, upload them from a file, or add them manually.

The Unit of Measure business object is displayed as a flat list in Business Modeling and is published with a derived hierarchy in OLAP.

Select Business Modeling > Business Objects > Organizational > Unit of Measure.

Properties of the Unit Of Measure element

This table shows the properties of the Unit of Measure element:

Property Type Default Description
Name nvarchar - Name of the Unit of Measure element.
IsFinancialAmountType boolean TRUE Determines the grouping in the OLAP-published hierarchy.

If the property value is TRUE, the element is assigned to the FinancialAmount branch.

If the property value is FALSE, the element is assigned to the Other branch.
HasUniqueCurrency boolean TRUE Controls the OLAP aggregation weight.

If the property value is TRUE, the element receives weight 1 (values are aggregated).

If the property value is FALSE, the element receives weight 0 (values are not aggregated to the parent).
Order Position integer - Defines the display order in Business Modeling and in the published OLAP dimension.
Translations nvarchar - Localized names for supported languages.

Custom properties are supported and can be added as required.

Built-in records

This table shows protected built-in records:

Record name Description
TOTAL Root element of the published hierarchy.

Aggregates all child branches.
N.A. Placeholder to use when the Unit of Measure is not applicable.

Receives weight 1.
Other Groups non-currency Unit of Measure elements for which IsFinancialAmountType = FALSE.

Receives weight 0.
Ratio Used by calculated metrics for ratio-type measures.

Assigned to the Other branch.
Percentage Used by calculated metrics for percentage-type measures.

Assigned to the Other branch.

You can't delete or add the protected built-in records in the user interface.

Published OLAP hierarchy

When you publish the model, the XPADUNITOFMEASURE dimension is created with this derived hierarchy structure:

TOTAL
├── FinancialAmount            (weight 1; suppressed if no UoM has IsFinancialAmountType = TRUE)
│   └── <UoMs with IsFinancialAmountType = TRUE>    weight = 1 if HasUniqueCurrency = TRUE, else 0
├── Other                      (weight 0)
│   ├── Percentage             (weight 0)
│   ├── Ratio                  (weight 0)
│   └── <UoMs with IsFinancialAmountType = FALSE>   weight = 0
└── N.A.                       (weight 1)

The weight determines whether values are aggregated to the parent level.

Elements with weight 0 are displayed in reports but don't contribute to the parent totals.

Backward compatibility

The backward compatibility behavior depends on whether the dEPM_BusinessObjectConfiguration table contains a row with FinancialDimensionID = 13.

If a row with FinancialDimensionID = 13 exists, the legacy behavior is preserved for publishing, fact import, Calculated Metric reference checks, and BudgetingMain handling.

If no row with FinancialDimensionID = 13 exists:

  • Publishing is driven by the Unit of Measure business object.
  • The reference is stored in the UnitOfMeasure column in the BudgetingMain table.
  • The BusinessObjectConfiguration table contains a row with DefaultNameUsage = UnitOfMeasure and FinancialDimensionID = NULL