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 element Unassigned. 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