Region
Return to Financial Consolidation model Overview
Elements in the Region
represent 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 parentUnassigned
. When the dimension is maintained at a later point, the new elements will be relocated to their correct parent.
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 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