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 parentUnassigned
. When the dimension is maintained at a later point, the new elements will be relocated to their correct parent.
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. 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. 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 Valid values are a four-character sequence with either
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