Legal Entity Dimension (Financial Consolidation)

Return to Financial Consolidation Model Overview.

Elements in the Legal Entity dimension represent the companies within a group, i.e those companies for which you need a separate financial statement. All legal entities 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:
  • Total Group
  • ~
  • 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 legal entity, 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)

Country

Country of the legal entity. Valid values are two-letter codes defined by ISO 3166, e.g. US for United States of America. (string)

On aggregated levels where all descendants have one common country, this country code should also be assigned to the aggregated element. For aggregations of legal entities in mixed countries, this attribute must be empty.

Currency

Currency of the legal entity. Valid elements are three-letter codes defined by ISO 4217, e.g. USD for US dollar. (string)

On aggregated levels where all descendants have one common currency, this currency code should also be assigned to the aggregated element. For aggregations of legal entities using mixed currencies, this attribute must be empty.

For more information, see the articles Currency Conversion Logic and Conversion from Implicit Local Currency.

Sign Standard

Sign representation of financial figures in the local accounting systems. This attribute can be used by interfaces importing figures from databases or files into the Jedox model. By comparing this value with the model setting configuration.signstandard, sign reversal can be automatically handled.

Valid values are a four-character sequence with either + or -. The characters represent the sign of stored amounts for

  1. Assets
  2. Equity and Liabilities
  3. Income
  4. Expenses

Example: in SAP ERP, assets and expenses are internally stored as positive figures, while equity, liabilities, and income are stored as negative figures. The sequence for a SAP ERP-based source would thus be +--+.

Holding Entity

Value for groups or subgroups (string). The values consist of a base element along with its children elements. The parent entity is the holding company and its children the subsidiaries. If there is any change in the holding entity attribute of the Legal Entity Dimension, the rule template needs to be updated.

Chart of Accounts

Reserved for future use (string).

Consolidation Entity

If you have created artificial entities within a group or subgroup that you wish to undergo consolidation, the Consolidation Entity attribute denotes which of these children are artificial.

Note: This process is not required, nor does Jedox recommend its implementation. It is not part of the sample data package.

Updated August 28, 2023