Custom Dimension 2

Return to Financial Consolidation model Overview

Elements in the Custom Dimension 2 dimension represent the companies within a group, i.e those companies for which you need a separate financial statement. All Custom Dimension 2 should aggregate to the grand total element Total Group. The elements may be structured by a hierarchy of intermediate levels or be directly assigned to Total Group. The number of elements in the Custom Dimension 2 dimension determine the number of items subject to consolidation. You may subdivide the total group into subgroups. The sample data includes subgroups EU and AMER.

In addition to the company elements, there are two elements with a special meaning:

  • ~ (Not Applicable): data that is not broken down by a Custom Dimension 2 is stored in this element. This type of element is sometimes also referred to as a “dummy element”.
  • Unassigned: this element should be empty most of the time. It may refer to legal entities that are missing when data is imported from a source system. During the data load, the missing elements are created on the fly under the parent Unassigned. When the dimension is maintained at a later point, the new elements will be relocated to their correct parent.
Make sure you do not delete the following elements:
  • All Custom Dimension 2 (Can be renamed)
  • ~
  • Unassigned

If you delete these elements, the reports using them may not work fully.

The Custom Dimension 2 elements can be configured through their attributes:

Attribute Description
Name

Readable name of the Custom Dimension 2, visible in the report. Localized translations can be provided. There is no hard-coded behavior implemented upon this name. (string)

ID_Name

Combination of element name, a dash (“ - "), and the localized name attribute. (calculated, string)

Updated August 25, 2023