Region

Return to Financial Consolidation model Overview

Elements in the Regionrepresent the companies within a group, i.e those companies for which you need a separate financial statement. All Regions 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 legal entity 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 legal entity 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 Regions
  • ~
  • Unassigned

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

The legal entity elements can be configured through their attributes:

Attribute Description
Name

Readable name of the Segment, 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)

Latitude Optional. Geographic WGS 84 coordinate between -90 (south pole) and 90 (north pole) with a dot (.) as decimal separator. (string)
Longitude Optional. Geographic WGS 84 coordinate between -180 (west of Greenwich) and +180 (east of Greenwich) with a dot (.) as decimal separator. (string)

Elimination Element

The Financial Consolidation model supports intra-region and inter-region elimination in the Region hierarchy. The intra-region elimination applies for intercompany relations having the same element in the Region and the Partner Region dimension. The eliminated amounts will be stored on this element. The inter-region elimination applies to intercompany relations having different elements in the Region and the Partner Region dimensions. The eliminated amounts will be stored on special region elimination elements. These are base elements which are children of a consolidated Region element and which are referred to by the Elimination Element attribute of that consolidated Region element. It's good practice, to use the name of the consolidated Region element with hte "_Elimination" postfix.

The "All Regions" region must have such an elimination element. For any other consolidated Region, element elimination elements are optional. The eliminated amounts will be stored on the lowest possible elimination element which parent is ancestor to both parties of the inter-region relation.

Parallel hierarchies are not allowed in this dimension.

Updated August 28, 2023