Consolidation Rules Cube

Return to Financial Consolidation Model Overview.

The Consolidation Rules Cube contains all the details on available consolidation rules. The details from the cube are shown on web reports and are used to run the consolidation process.

  • Consolidation Rule: See article Consolidation Rule Dimension.

  • Consolidation Rule Line: lists consolidation rule lines

  • Consolidation Rule Line Detail: lists details on consolidation rule lines

  • Consolidation Rules_measure: lists consolidation rules measures.

Element Description
Name Readable name of the version. Localized translations can be provided. This attribute is visible in the report. There is no hard-coded behavior implemented in this name. (string)
Description Long text description of the account. This attribute can contain a definition of the amounts booked to the account or instructions for the planners. Localized translations can be provided. (string)
Consolidation Function Consolidation function: is defined based on available consolidation functions from the Consolidation Function dimension. Depending on the selected consolidation function, the following attributes need to be set: Factor, Rate1, Rate2, Business Transaction Type, Account.Operator, Account, Account.Mode, Transaction Type.Operator, Transaction Type, Transaction Type.Mode, Consolidation. These attributes including possible values are displayed on the Consolidation Rules report. Consolidation Rules should be set up only via the "Consolidation Rules" report to ensure that all necessary attributes are set correctly.
Calculation Formula to compute this consolidation rule line from other lines. You can use the basic mathematical operators (e.g. +, -, *, /), numbers, parentheses and single capital letters to refer to other consolidation rule lines. You can also use any function supported for Jedox rules.
PJ.Group Grouping of journal entry lines. Valid values are ordinals greater than zero. Entry lines of the same group are kept together and sorted by debit or credit and by amount.
PJLine1.Description Text for the line of the journal entry. This can be any plain text, which optionally contain the following keywords (in all caps): LEGAL_ENTITY_ID_NAME: ID_Name attribute of the legal entity PARTNER_ENTITY_ID_NAME: ID_Name attribute of the partner entity LEGAL_ENTITY: Element name of the legal entity PARTNER_ENTITY: Element name of the partner entity NAME: Name of the consolidation rule SCOPE: Element name of the current scope HOLDING: Element name for the current scope’s holding entity
PJLine1.Legal Entity Element of the Legal Entity dimension that figures are posted to. This can be manually typed in or one of the following keywords can be entered (in all caps): LEGAL_ENTITY: Element name of the legal entity PARTNER_ENTITY: Element name of the partner entity HOLDING: Element name for the current scope’s holding entity
PJLine1.Partner Entity Element of the Partner Entity dimension that figures are posted to. This can be typed in or one of the following keywords (in all caps): LEGAL_ENTITY: Element name of the legal entity PARTNER_ENTITY: Element name of the partner entity HOLDING: Element name for the current scope’s holding entity
PJLine1.Cube The cube to post the amount to, e.g. "Profit and Loss", "Balance Sheet", etc.
PJLine1.Account Element of the BS Account, PnL Account or CF Account dimension to which figures are posted. This can be typed in manually or entered as one of the following keywords (in all caps): BS_ACCOUNT: Element name of the BS Account dimension as defined by the consolidation rule line detail. PNL_ACCOUNT: Element name of the PnL Account dimension as defined by the consolidation rule line detail. ACCOUNT: Element name of the account dimension as defined by the consolidation rule line detail. CLEARING_ACCOUNT: Element name of the account dimension as defined by the Clearing Account attribute of the eliminated account.
PJLine1.Transaction Type Element of the Transaction Type dimension which figures are posted to (only valid for the Balance Sheet cube(s)). This can be typed in manually or the following keyword (in all caps): TRANSACTION_TYPE: Element name of the transaction type dimension.
PJLine2.Description Text for the line of the journal entry. This can be any plain text, which optionally contain the following keywords (in all caps): LEGAL_ENTITY_ID_NAME: ID_Name attribute of the legal entity PARTNER_ENTITY_ID_NAME: ID_Name attribute of the partner entity LEGAL_ENTITY: Element name of the legal entity PARTNER_ENTITY: Element name of the partner entity NAME: Name of the consolidation rule SCOPE: Element name of the current scope HOLDING: Element name for the current scope’s holding entity
PJLine2.Legal Entity Element of the Legal Entity dimension that figures are posted to. This can be manually typed in or one of the following keywords can be entered (in all caps): LEGAL_ENTITY: Element name of the legal entity PARTNER_ENTITY: Element name of the partner entity HOLDING: Element name for the current scope’s holding entity
PJLine2.Partner Entity Element of the Partner Entity dimension that figures are posted to. This can be typed in or one of the following keywords (in all caps): LEGAL_ENTITY: Element name of the legal entity PARTNER_ENTITY: Element name of the partner entity HOLDING: Element name for the current scope’s holding entity
PJLine2.Cube The cube to post the amount to, e.g. "Profit and Loss", "Balance Sheet", etc.
PJLine2.Account Element of the BS Account, PnL Account or CF Account dimension to which figures are posted. This can be typed in manually or entered as one of the following keywords (in all caps): BS_ACCOUNT: Element name of the BS Account dimension as defined by the consolidation rule line detail. PNL_ACCOUNT: Element name of the PnL Account dimension as defined by the consolidation rule line detail. ACCOUNT: Element name of the account dimension as defined by the consolidation rule line detail. CLEARING_ACCOUNT: Element name of the account dimension as defined by the Clearing Account attribute of the eliminated account.
PJLine2.Transaction Type Element of the Transaction Type dimension which figures are posted to (only valid for the Balance Sheet cube(s)). This can be typed in manually or the following keyword (in all caps): TRANSACTION_TYPE: Element name of the transaction type dimension.

Updated August 28, 2023