Tabular Model - Group Consolidation

Contents

Usage/Purpose

Main analysis scenarios are:

Fact Tables

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
CONSOLIDATED BALANCESFACT_CONSOL_BALANCE_TMFACT_CONSOL_BALANCE_BIFACT_CONSOL_BALANCEData Mart
CURRENCY RATESFACT_CURRENCY_RATES_TMFACT_CURRENCY_RATES_BIFACT_CURRENCY_RATESOn Line
CONSOLIDATION REPORTED BALANCESFACT_CONSOL_REP_BALANCE_TMFACT_CONSOL_REP_BALANCE_BIFACT_CONSOL_REP_BALANCEData Mart
CONSOLIDATION ANALYSISFACT_CONSOL_BAL_SET_ANALYS_TMFACT_CONSOL_BAL_SET_ANALYS_BIFACT_CONSOL_BAL_SET_ANALYSData Mart
CONSOLIDATION BALANCE SETFACT_CONSOL_BAL_SET_CONF_ANALYS_TMFACT_CONSOL_BAL_SET_ANALYS_BIFACT_CONSOL_BAL_SET_ANALYSData Mart
CONSOLIDATED BALANCES DETAILSFACT_CONSOL_BALANCE_DETAIL_TMFACT_CONSOL_BALANCE_BIFACT_CONSOL_BALANCEData Mart

 Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources

CONSOLIDATED BALANCES
Consolidated Balances is an Information Source that relates to IFS/Group Consolidation. This Information Source can be used to design reports/analysis based on consolidated balances which are the result of the Group Consolidation process.The information about consolidated balances can be analyzed based on consolidation structure, period, balance version, structure node, sublevel node and reporting entity etc. The analysis can be performed for the balances which resulted in different steps of the consolidation process. There are several consolidation transaction types generated during the consolidation process such as Consolidated Balances, Translated Balances, Profit Elimination, Ownership Elimination, Intercomany Elimination. Therefore, the reports should be based on the appropriate selection of consolidation transaction types. Eg: Consolidated Balance Sheet should be based on consolidation transaction type Consolidated Balances. If not, the balances could be duplicated.

CONSOLIDATED BALANCE SET ANALYSIS
Consolidated Balance Set Analysis is as Information Source that relates to IFS/Group Consolidation. This Information Source can be used to design reports/analysis based on consolidated balances which are the result of the Group Consolidation process. The consolidated balances generated as a result of the Group Consolidation process are generated as accumulated balances for a given period. Therefore, these accumulated balances should be segregated to each period by using Calculate Period Balances process before used to design reports/analysis. The information about period consolidated balances can be analyzed based on consolidation structure, period, balance version, structure node, sublevel node and reporting entity etc. The analysis can be performed only for the period balances with the transaction type Consolidated Balances.The report/analysis will retrieve data according to the configuration set by the BI Consolidation Balance Set Period Analysis Configuration in IFS Cloud. User can predefine which information should be retrieved to each accounting period using the BI Consolidation Balance Set Period Configuration, using the different balance versions based on budget or actual.

CONSOLIDATION REPORTED BALANCES
Consolidation Reported Balances is an Information Source that relates to IFS/Group Consolidation. This Information Source can be used to design reports/analysis based on reporting and adjustment journals that are to be used in the Group Consolidation process.

FACT_CURRENCY_RATES
Currency Rate information source is based on IFS\Accounting Rules\Currency. This information source can be used to design reports using Currency Rate information..

Dimension Tables

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
REPORTING DATEDIM_BI_TIME_TMDIM_BI_TIME_BIDIM_BI_TIMEOn Line
ACCOUNTDIM_ACCOUNT_GC_TMDIM_ACCOUNT_BIDIM_ACCOUNTOn Line
REPORTING CURRENCYDIM_CURRENCY_CODE_GC_TMDIM_CURRENCY_CODE_BIDIM_CURRENCY_CODEOn Line
COMPANYDIM_COMPANY_GC_TMDIM_COMPANY_BIDIM_COMPANYOn Line
STRUCTURE NODEDIM_CONSOL_STRUCTURE_NODE_GC_TMCONSOL_STRUCT_NODE_SORT_ID_BIACONSOL_STRUCT_NODE_SORT_ID_BIAOn Line
STRUCTURE NODE SUB LEVELDIM_CONSOL_SUB_STRUCT_LEVEL_GC_TMCONSOL_STRUCT_SORT_ID_BIACONSOL_STRUCT_SORT_ID_BIAOn Line
ACCOUNTING PERIODDIM_ACCOUNTING_PERIOD_BIDIM_ACCOUNTING_PERIOD_BIDIM_ACCOUNTING_PERIODOn Line
BALANCE SETDIM_CONSOL_BALANCE_SET_GC_TMDIM_CONSOL_BALANCE_SET_BIDIM_CONSOL_BALANCE_SETOn Line
STRUCTUREDIM_CONSOL_STRUCTURE_GC_TMDIM_CONSOL_STRUCTURE_BIDIM_CONSOL_STRUCTUREOn Line
CONSOLIDATION TRANS TYPEDIM_CONSOL_TRANS_CODE_TYPE_GC_TMDIM_CONSOL_TRANS_CODE_TYPE_BIDIM_CONSOL_TRANS_CODE_TYPEOn Line
COUNTER PART ONEDIM_COUNTER_PART_ONE_GC_TMDIM_COUNTER_PART_ONE_BIDIM_COUNTER_PART_ONEOn Line
COUNTER PART TWODIM_COUNTER_PART_TWO_GC_TMDIM_COUNTER_PART_TWO_BIDIM_COUNTER_PART_TWOOn Line
POSTING TYPEDIM_GROCON_POSTING_TYPE_GC_TMDIM_GROCON_POSTING_TYPE_BIDIM_GROCON_POSTING_TYPEOn Line
INTERCOMPANY ELIM RULEDIM_INTERCOMPANY_ELIM_RULE_TMDIM_INTERCOMPANY_ELIM_RULE_BIDIM_INTERCOMPANY_ELIM_RULEOn Line
PARALLEL STRUCTUREDIM_PAR_CONSOL_STRUCTURE_GC_TMDIM_PAR_CONSOL_STRUCTURE_BIDIM_PAR_CONSOL_STRUCTUREOn Line
REPORTING COMPANYDIM_COMPANY_GC_TMDIM_COMPANY_BIDIM_COMPANYOn Line
REPORTING PERIODDIM_REPORTING_PERIOD_GC_TM, alt DIM_BI_TIME_BI combined with DIM_RDP_COMPANY_PERIOD_BI to DIM_BI_TIME_TMDIM_RDP_COMPANY_PERIOD_BIDIM_RPD_COMPANY_PERIODOn Line
REPORTING ENTITYDIM_REPORTING_ENTITY_GC_TMDIM_REPORTING_ENTITY_BIDIM_REPORTING_ENTITYOn Line
REPORT TRANS TYPEDIM_REPORT_TRANS_TYPE_GC_TMDIM_REPORT_TRANS_TYPE_BIDIM_REPORT_TRANS_TYPEOn Line
BALANCE VERSIONDIM_REP_BALANCE_VERSION_GC_TMDIM_REP_BALANCE_VERSION_BIDIM_REP_BALANCE_VERSIONOn Line
ACCOUNT ATTRIBUTEDIM_ACC_ATTR_1_ACCOUNT_GC_TMOn Line
CODE D ATTRIBUTEDIM_ACC_ATTR_1_CODE_D_GC_TMOn Line
CODE E ATTRIBUTEDIM_ACC_ATTR_1_CODE_E_GC_TMOn Line
CODE F ATTRIBUTEDIM_ACC_ATTR_1_CODE_F_GC_TMOn Line
CODE G ATTRIBUTEDIM_ACC_ATTR_1_CODE_G_GC_TMOn Line
CODE H ATTRIBUTEDIM_ACC_ATTR_1_CODE_H_GC_TMOn Line
CODE I ATTRIBUTEDIM_ACC_ATTR_1_CODE_I_GC_TMOn Line
CODE J ATTRIBUTEDIM_ACC_ATTR_1_CODE_J_GC_TMOn Line
CODE B ATTRIBUTEDIM_ACC_ATTR_1_CODE_B_GC_TMOn Line
CODE C ATTRIBUTEDIM_ACC_ATTR_1_CODE_C_GC_TMOn Line
CODE BDIM_CODE_B_GC_TMDIM_CODE_B_BIDIM_CODE_BOn Line
CODE CDIM_CODE_C_GC_TMDIM_CODE_C_BIDIM_CODE_COn Line
CODE DDIM_CODE_D_GC_TMDIM_CODE_D_BIDIM_CODE_DOn Line
CODE EDIM_CODE_E_GC_TMDIM_CODE_E_BIDIM_CODE_EOn Line
CODE FDIM_CODE_F_GC_TMDIM_CODE_F_BIDIM_CODE_FOn Line
CODE GDIM_CODE_G_GC_TMDIM_CODE_G_BIDIM_CODE_GOn Line
CODE HDIM_CODE_H_GC_TMDIM_CODE_H_BIDIM_CODE_HOn Line
CODE IDIM_CODE_I_GC_TMDIM_CODE_I_BIDIM_CODE_IOn Line
CODE JDIM_CODE_J_GC_TMDIM_CODE_J_BIDIM_CODE_JOn Line
CONSOLIDATED BALANCES DETAILS SHYDIM_CONSOL_BALANCE_DETAIL_SHYData Mart

Configurations

Limitations

Relationships

The following table lists the relationships between tables and columns in the model.

Relationship: Table (column) - Table (column)
CURRENCY RATES (DIM_TIME_ID) - REPORTING DATE (ID)
CURRENCY RATES (DIM_REPORTING_CURRENCY_ID) - REPORTING CURRENCY (ID)
CONSOLIDATED BALANCES (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID)
CONSOLIDATED BALANCES DETAILS (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID)
CONSOLIDATION ANALYSIS (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID)
CONSOLIDATION BALANCE SET (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID)
CONSOLIDATED BALANCES (Dim Company ID) - COMPANY (ID)
CONSOLIDATED BALANCES DETAILS (Dim Company ID) - COMPANY (ID)
CONSOLIDATION ANALYSIS (Dim Company ID) - COMPANY (ID)
CONSOLIDATION BALANCE SET (Dim Company ID) - COMPANY (ID)
CONSOLIDATION REPORTED BALANCES (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID)
CONSOLIDATION REPORTED BALANCES (Dim Company ID) - COMPANY (ID)
CONSOLIDATED BALANCES (Dim Consol Struct Sub Level ID) - STRUCTURE NODE SUB LEVEL (ID)
CONSOLIDATED BALANCES DETAILS (Dim Consol Struct Sub Level ID) - STRUCTURE NODE SUB LEVEL (ID)
CONSOLIDATION ANALYSIS (Dim Grocon Balance Set ID) - BALANCE SET (ID)
CONSOLIDATION BALANCE SET (Dim Grocon Balance Set ID) - BALANCE SET (ID)
CONSOLIDATED BALANCES (Dim Consol Structure ID) - STRUCTURE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Consol Structure ID) - STRUCTURE (ID)
CONSOLIDATION ANALYSIS (Dim Consol Structure ID) - STRUCTURE (ID)
CONSOLIDATION BALANCE SET (Dim Consol Structure ID) - STRUCTURE (ID)
CONSOLIDATED BALANCES (Dim Consol Structure Node ID) - STRUCTURE NODE (ID)
CONSOLIDATION ANALYSIS (Dim Consol Structure Node ID) - STRUCTURE NODE (ID)
CONSOLIDATION BALANCE SET (Dim Consol Structure Node ID) - STRUCTURE NODE (ID)
CONSOLIDATED BALANCES (Dim Consol Trans Code Type ID) - CONSOLIDATION TRANS TYPE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Consol Trans Code Type ID) - CONSOLIDATION TRANS TYPE (ID)
CONSOLIDATED BALANCES (Dim Counter Part One ID) - COUNTER PART ONE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Counter Part One ID) - COUNTER PART ONE (ID)
CONSOLIDATION ANALYSIS (Dim Counter Part One ID) - COUNTER PART ONE (ID)
CONSOLIDATION BALANCE SET (Dim Counter Part One ID) - COUNTER PART ONE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Counter Part One ID) - COUNTER PART ONE (ID)
CONSOLIDATED BALANCES (Dim Counter Part Two ID) - COUNTER PART TWO (ID)
CONSOLIDATED BALANCES DETAILS (Dim Counter Part Two ID) - COUNTER PART TWO (ID)
CONSOLIDATION ANALYSIS (Dim Counter Part Two ID) - COUNTER PART TWO (ID)
CONSOLIDATION BALANCE SET (Dim Counter Part Two ID) - COUNTER PART TWO (ID)
CONSOLIDATION REPORTED BALANCES (Dim Counter Part Two ID) - COUNTER PART TWO (ID)
CONSOLIDATED BALANCES (Dim Currency Code ID) - REPORTING CURRENCY (ID)
CONSOLIDATED BALANCES DETAILS (Dim Currency Code ID) - REPORTING CURRENCY (ID)
CONSOLIDATION ANALYSIS (Dim Currency Code ID) - REPORTING CURRENCY (ID)
CONSOLIDATION BALANCE SET (Dim Currency Code ID) - REPORTING CURRENCY (ID)
CONSOLIDATION REPORTED BALANCES (Dim Currency Code ID) - REPORTING CURRENCY (ID)
CONSOLIDATED BALANCES (Dim Grocon Posting Type ID) - POSTING TYPE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Grocon Posting Type ID) - POSTING TYPE (ID)
CONSOLIDATION ANALYSIS (Dim Grocon Posting Type ID) - POSTING TYPE (ID)
CONSOLIDATION BALANCE SET (Dim Grocon Posting Type ID) - POSTING TYPE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Grocon Posting Type ID) - POSTING TYPE (ID)
CONSOLIDATED BALANCES (Dim Inter Company Elim Rule ID) - INTERCOMPANY ELIM RULE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Inter Company Elim Rule ID) - INTERCOMPANY ELIM RULE (ID)
CONSOLIDATED BALANCES (Dim Par Consol Structure ID) - PARALLEL STRUCTURE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Par Consol Structure ID) - PARALLEL STRUCTURE (ID)
CONSOLIDATION ANALYSIS (Dim Par Consol Structure ID) - PARALLEL STRUCTURE (ID)
CONSOLIDATION BALANCE SET (Dim Par Consol Structure ID) - PARALLEL STRUCTURE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Reporting Company ID) - REPORTING COMPANY (ID)
CONSOLIDATED BALANCES (Dim Reporting Entity ID) - REPORTING ENTITY (ID)
CONSOLIDATED BALANCES DETAILS (Dim Reporting Entity ID) - REPORTING ENTITY (ID)
CONSOLIDATION REPORTED BALANCES (Dim Reporting Entity ID) - REPORTING ENTITY (ID)
CONSOLIDATION REPORTED BALANCES (Dim Report Trans Type ID) - REPORT TRANS TYPE (ID)
CONSOLIDATED BALANCES (Dim Rep Balance Version ID) - BALANCE VERSION (ID)
CONSOLIDATED BALANCES DETAILS (Dim Rep Balance Version ID) - BALANCE VERSION (ID)
CONSOLIDATION ANALYSIS (Dim Rep Balance Version ID) - BALANCE VERSION (ID)
CONSOLIDATION BALANCE SET (Dim Rep Balance Version ID) - BALANCE VERSION (ID)
CONSOLIDATION REPORTED BALANCES (Dim Rep Balance Version ID) - BALANCE VERSION (ID)
CONSOLIDATED BALANCES (Dim Reporting Date ID) - REPORTING DATE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Reporting Date ID) - REPORTING DATE (ID)
CONSOLIDATION ANALYSIS (Dim Reporting Date ID) - REPORTING DATE (ID)
CONSOLIDATION BALANCE SET (Dim Reporting Date ID) - REPORTING DATE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Reporting Date ID) - REPORTING DATE (ID)
CONSOLIDATED BALANCES (Dim Code B ID) - CODE B ATTRIBUTE (ID)
CONSOLIDATED BALANCES (Dim Code C ID) - CODE C ATTRIBUTE (ID)
CONSOLIDATED BALANCES (Dim Code D ID) - CODE D ATTRIBUTE (ID)
CONSOLIDATED BALANCES (Dim Code E ID) - CODE E ATTRIBUTE (ID)
CONSOLIDATED BALANCES (Dim Code F ID) - CODE F ATTRIBUTE (ID)
CONSOLIDATED BALANCES (Dim Code G ID) - CODE G ATTRIBUTE (ID)
CONSOLIDATED BALANCES (Dim Code H ID) - CODE H ATTRIBUTE (ID)
CONSOLIDATED BALANCES (Dim Code I ID) - CODE I ATTRIBUTE (ID)
CONSOLIDATED BALANCES (Dim Code J ID) - CODE J ATTRIBUTE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code B ID) - CODE B ATTRIBUTE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code D ID) - CODE D ATTRIBUTE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code E ID) - CODE E ATTRIBUTE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code F ID) - CODE F ATTRIBUTE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code G ID) - CODE G ATTRIBUTE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code H ID) - CODE H ATTRIBUTE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code I ID) - CODE I ATTRIBUTE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code J ID) - CODE J ATTRIBUTE (ID)
CONSOLIDATION ANALYSIS (Dim Code B ID) - CODE B ATTRIBUTE (ID)
CONSOLIDATION ANALYSIS (Dim Code C ID) - CODE C ATTRIBUTE (ID)
CONSOLIDATION ANALYSIS (Dim Code D ID) - CODE D ATTRIBUTE (ID)
CONSOLIDATION ANALYSIS (Dim Code E ID) - CODE E ATTRIBUTE (ID)
CONSOLIDATION ANALYSIS (Dim Code F ID) - CODE F ATTRIBUTE (ID)
CONSOLIDATION ANALYSIS (Dim Code G ID) - CODE G ATTRIBUTE (ID)
CONSOLIDATION ANALYSIS (Dim Code H ID) - CODE H ATTRIBUTE (ID)
CONSOLIDATION ANALYSIS (Dim Code I ID) - CODE I ATTRIBUTE (ID)
CONSOLIDATION ANALYSIS (Dim Code J ID) - CODE J ATTRIBUTE (ID)
CONSOLIDATION BALANCE SET (Dim Code B ID) - CODE B ATTRIBUTE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code C ID) - CODE C ATTRIBUTE (ID)
CONSOLIDATION BALANCE SET (Dim Code C ID) - CODE C ATTRIBUTE (ID)
CONSOLIDATION BALANCE SET (Dim Code D ID) - CODE D ATTRIBUTE (ID)
CONSOLIDATION BALANCE SET (Dim Code E ID) - CODE E ATTRIBUTE (ID)
CONSOLIDATION BALANCE SET (Dim Code F ID) - CODE F ATTRIBUTE (ID)
CONSOLIDATION BALANCE SET (Dim Code G ID) - CODE G ATTRIBUTE (ID)
CONSOLIDATION BALANCE SET (Dim Code H ID) - CODE H ATTRIBUTE (ID)
CONSOLIDATION BALANCE SET (Dim Code I ID) - CODE I ATTRIBUTE (ID)
CONSOLIDATION BALANCE SET (Dim Code J ID) - CODE J ATTRIBUTE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code B ID) - CODE B ATTRIBUTE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code D ID) - CODE D ATTRIBUTE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code E ID) - CODE E ATTRIBUTE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code F ID) - CODE F ATTRIBUTE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code G ID) - CODE G ATTRIBUTE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code H ID) - CODE H ATTRIBUTE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code I ID) - CODE I ATTRIBUTE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code J ID) - CODE J ATTRIBUTE (ID)
CONSOLIDATED BALANCES (Dim Account ID) - ACCOUNT ATTRIBUTE (ID)
CONSOLIDATED BALANCES DETAILS (Dim Account ID) - ACCOUNT ATTRIBUTE (ID)
CONSOLIDATION ANALYSIS (Dim Account ID) - ACCOUNT ATTRIBUTE (ID)
CONSOLIDATION BALANCE SET (Dim Account ID) - ACCOUNT ATTRIBUTE (ID)
CONSOLIDATION REPORTED BALANCES (Dim Account ID) - ACCOUNT ATTRIBUTE (ID)
CONSOLIDATED BALANCES (Dim Account ID) - ACCOUNT (ID)
CONSOLIDATED BALANCES DETAILS (Dim Account ID) - ACCOUNT (ID)
CONSOLIDATION ANALYSIS (Dim Account ID) - ACCOUNT (ID)
CONSOLIDATION BALANCE SET (Dim Account ID) - ACCOUNT (ID)
CONSOLIDATION REPORTED BALANCES (Dim Account ID) - ACCOUNT (ID)
CONSOLIDATED BALANCES (Dim Code B ID) - CODE B (ID)
CONSOLIDATED BALANCES (Dim Code C ID) - CODE C (ID)
CONSOLIDATED BALANCES (Dim Code D ID) - CODE D (ID)
CONSOLIDATED BALANCES (Dim Code E ID) - CODE E (ID)
CONSOLIDATED BALANCES (Dim Code F ID) - CODE F (ID)
CONSOLIDATED BALANCES (Dim Code G ID) - CODE G (ID)
CONSOLIDATED BALANCES (Dim Code H ID) - CODE H (ID)
CONSOLIDATED BALANCES (Dim Code I ID) - CODE I (ID)
CONSOLIDATED BALANCES (Dim Code J ID) - CODE J (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code B ID) - CODE B (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code C ID) - CODE C (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code D ID) - CODE D (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code E ID) - CODE E (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code F ID) - CODE F (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code G ID) - CODE G (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code H ID) - CODE H (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code I ID) - CODE I (ID)
CONSOLIDATED BALANCES DETAILS (Dim Code J ID) - CODE J (ID)
CONSOLIDATION ANALYSIS (Dim Code B ID) - CODE B (ID)
CONSOLIDATION ANALYSIS (Dim Code C ID) - CODE C (ID)
CONSOLIDATION ANALYSIS (Dim Code D ID) - CODE D (ID)
CONSOLIDATION ANALYSIS (Dim Code E ID) - CODE E (ID)
CONSOLIDATION ANALYSIS (Dim Code F ID) - CODE F (ID)
CONSOLIDATION ANALYSIS (Dim Code G ID) - CODE G (ID)
CONSOLIDATION ANALYSIS (Dim Code H ID) - CODE H (ID)
CONSOLIDATION ANALYSIS (Dim Code I ID) - CODE I (ID)
CONSOLIDATION ANALYSIS (Dim Code J ID) - CODE J (ID)
CONSOLIDATION BALANCE SET (Dim Code B ID) - CODE B (ID)
CONSOLIDATION BALANCE SET (Dim Code C ID) - CODE C (ID)
CONSOLIDATION BALANCE SET (Dim Code D ID) - CODE D (ID)
CONSOLIDATION BALANCE SET (Dim Code E ID) - CODE E (ID)
CONSOLIDATION BALANCE SET (Dim Code F ID) - CODE F (ID)
CONSOLIDATION BALANCE SET (Dim Code G ID) - CODE G (ID)
CONSOLIDATION BALANCE SET (Dim Code H ID) - CODE H (ID)
CONSOLIDATION BALANCE SET (Dim Code I ID) - CODE I (ID)
CONSOLIDATION BALANCE SET (Dim Code J ID) - CODE J (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code B ID) - CODE B (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code C ID) - CODE C (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code D ID) - CODE D (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code E ID) - CODE E (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code F ID) - CODE F (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code G ID) - CODE G (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code H ID) - CODE H (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code I ID) - CODE I (ID)
CONSOLIDATION REPORTED BALANCES (Dim Code J ID) - CODE J (ID)
CONSOLIDATED BALANCES (Dim Reporting Period ID) - REPORTING PERIOD (Company-Date)
CONSOLIDATION ANALYSIS (Dim Reporting Period ID) - REPORTING PERIOD (Company-Date)
CONSOLIDATION REPORTED BALANCES (Dim Reporting Period ID) - REPORTING PERIOD (Company-Date)
CONSOLIDATED BALANCES DETAILS (ID) - CONSOLIDATED BALANCES DETAILS SHY (ID)