Profit and Loss Measure Dimension

Return to Financial Consolidation model Overview

The measures in the Profit and Loss Measure Dimension contains all the information on Calculations and Data Validation of the Profit and Loss Cube.

The base elements and their direct parents in the Data Validations, Data Validation Errors, and Data Validation Warnings hierarchies are configurable. Each data validation is represented by a base element with a name DVnnn under Data Validations where nnn is a three-digit number. For these elements, the Calculation, CalculationDependencies, and TargetRestriction attribute values define the data validation by returning a non-zero value for any failed validation (see CF Account Dimension ). Passed data validation should return preferably NULL or 0.

For each data validation there must be one base element with a name DVnnn_E under Data Validations Errors and another base element with a name DVnnn_W under Data Validations Warnings. These should not have any attribute values.

- Data validations and their corresponding elements in the Data Validation Errors and Data Validation Warnings hierarchies should be grouped by consolidated elements with names DVnxx" "DVxnnx" to address groups of data validations in reports and the workflow.

The Profit and Loss Measure Dimension can be configured through their attributes:

Attribute Description
Name

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

Description

Long text description of the account. This attribute can contain a definition of the amounts booked to the account or instructions for the planners. Localized translations can be provided (string).

Calculation Defines the calculation for the element.

CalculationDependencies

Indicates which cube is the source of transferred data.
TargetRestriction Slice within one or more of the business dimensions receiving transferred data.
Data Validation Threshold An optional positive numeric value to suppress any failed Data Validation below the threshold value.
Data Validation Severity Must be either Error or Warning. Errors will stop the workflow whilst Warnings will be shown but would not block the workflow.
:nodetype

Make sure you do not delete the following elements:

  • Value

  • Comment

  • Data Validations

  • Data Validation Errors

  • Data Validation Warnings

Updated July 8, 2024