Partner Region
Return to Financial Consolidation model Overview
Elements in the Partner Region
dimension represent business relationships with other companies in a group. All internal Partner Regions
should aggregate to the consolidated element Total Group
. You may subdivide the total group into subgroups. The sample data includes subgroups EU
and AMER
. The root element of this dimension is All Partner Regions
.
In addition to the company elements, there are two elements with a special meaning:
~
(Not Applicable): data that is not broken down by a partner region is stored in this element. This type of element is sometimes referred to as a “dummy element”. It is also used for business relationships with external partners.Unassigned
: this element should be empty most of the time. It may refer to partner entities that are missing when data is imported from a source system. During the data load, these missing elements are created on the fly under the parent elementUnassigned
. The new elements will be relocated to their correct parent when the dimension is updated.
Make sure you do not delete the following elements:
- All Partner Regions
- ~
- Unassigned
Additionally the subgroup elements should have a weight of zero. Elements should be similar to Region, and you have to include ~
, All Segments_Elimination
, and All Segments (Elimination)
in the Region
dimension.
If you do not meet the above constraints, the implementation relying on them may be compromised. The reports and application using them may not fully work.
The partner Region elements can be configured through their attributes:
Attribute |
Description |
Name |
Readable name of the partner region, visible in the report. Localized translations can be provided. There is no hard-coded behavior implemented upon this name. (string) |
ID_Name |
Combination of the 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) |
Updated November 4, 2024