This Tabular Model is used for: Group Consolidation. There is a list of Tabular Models pre-packaged and delivered as a part of IFS Analysis Models, and you can refer to them here.
Main analysis scenarios are:
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| CONSOLIDATED BALANCES | FACT_CONSOL_BALANCE_TM | FACT_CONSOL_BALANCE_BI | FACT_CONSOL_BALANCE | Data Mart |
| CONSOLIDATED BALANCES DETAILS MEASURES | ||||
| CONSOLIDATION ANALYSIS | FACT_CONSOL_BAL_SET_ANALYS_TM | FACT_CONSOL_BAL_SET_ANALYS_BI | FACT_CONSOL_BAL_SET_ANALYS | Data Mart |
| CONSOLIDATION BALANCE SET | FACT_CONSOL_BAL_SET_CONF_ANALYS_TM | FACT_CONSOL_BAL_SET_ANALYS_BI | FACT_CONSOL_BAL_SET_ANALYS | Data Mart |
| CONSOLIDATION REPORTED BALANCES MEASURES | ||||
| CURRENCY RATES | FACT_CURRENCY_RATES_TM | FACT_CURRENCY_RATES_BI | FACT_CURRENCY_RATES | On Line |
Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources
CONSOLIDATED BALANCES
Consolidated Balances information source is based on 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 information source is based on 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 the IFS Applications. 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 information source is based on 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..
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| ACCOUNT | DIM_ACCOUNT_GC_TM | DIM_ACCOUNT_BI | DIM_ACCOUNT | On Line |
| ACCOUNT ATTRIBUTE | DIM_ACC_ATTR_1_ACCOUNT_GC_TM | On Line | ||
| ACCOUNTING PERIOD | DIM_ACCOUNTING_PERIOD_BI | DIM_ACCOUNTING_PERIOD_BI | DIM_ACCOUNTING_PERIOD | On Line |
| BALANCE SET | DIM_CONSOL_BALANCE_SET_GC_TM | DIM_CONSOL_BALANCE_SET_BI | DIM_CONSOL_BALANCE_SET | On Line |
| BALANCE VERSION | DIM_REP_BALANCE_VERSION_GC_TM | DIM_REP_BALANCE_VERSION_BI | DIM_REP_BALANCE_VERSION | On Line |
| CODE B | DIM_CODE_B_GC_TM | DIM_CODE_B_BI | DIM_CODE_B | On Line |
| CODE B ATTRIBUTE | DIM_ACC_ATTR_1_CODE_B_GC_TM | On Line | ||
| CODE C | DIM_CODE_C_GC_TM | DIM_CODE_C_BI | DIM_CODE_C | On Line |
| CODE C ATTRIBUTE | DIM_ACC_ATTR_1_CODE_C_GC_TM | On Line | ||
| CODE D | DIM_CODE_D_GC_TM | DIM_CODE_D_BI | DIM_CODE_D | On Line |
| CODE D ATTRIBUTE | DIM_ACC_ATTR_1_CODE_D_GC_TM | On Line | ||
| CODE E | DIM_CODE_E_GC_TM | DIM_CODE_E_BI | DIM_CODE_E | On Line |
| CODE E ATTRIBUTE | DIM_ACC_ATTR_1_CODE_E_GC_TM | On Line | ||
| CODE F | DIM_CODE_F_GC_TM | DIM_CODE_F_BI | DIM_CODE_F | On Line |
| CODE F ATTRIBUTE | DIM_ACC_ATTR_1_CODE_F_GC_TM | On Line | ||
| CODE G | DIM_CODE_G_GC_TM | DIM_CODE_G_BI | DIM_CODE_G | On Line |
| CODE G ATTRIBUTE | DIM_ACC_ATTR_1_CODE_G_GC_TM | On Line | ||
| CODE H | DIM_CODE_H_GC_TM | DIM_CODE_H_BI | DIM_CODE_H | On Line |
| CODE H ATTRIBUTE | DIM_ACC_ATTR_1_CODE_H_GC_TM | On Line | ||
| CODE I | DIM_CODE_I_GC_TM | DIM_CODE_I_BI | DIM_CODE_I | On Line |
| CODE I ATTRIBUTE | DIM_ACC_ATTR_1_CODE_I_GC_TM | On Line | ||
| CODE J | DIM_CODE_J_GC_TM | DIM_CODE_J_BI | DIM_CODE_J | On Line |
| CODE J ATTRIBUTE | DIM_ACC_ATTR_1_CODE_J_GC_TM | On Line | ||
| CODE N | ||||
| CODE O | ||||
| CODE P | ||||
| CODE Q | ||||
| CODE R | ||||
| CODE S | ||||
| CODE T | ||||
| COMPANY | DIM_COMPANY_GC_TM | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| CONSOLIDATED BALANCES DETAILS | FACT_CONSOL_BALANCE_DETAIL_TM | FACT_CONSOL_BALANCE_BI | FACT_CONSOL_BALANCE | Data Mart |
| CONSOLIDATED BALANCES DETAILS SHY | DIM_CONSOL_BALANCE_DETAIL_SHY | Data Mart | ||
| CONSOLIDATION REPORTED BALANCES | FACT_CONSOL_REP_BALANCE_TM | FACT_CONSOL_REP_BALANCE_BI | FACT_CONSOL_REP_BALANCE | Data Mart |
| CONSOLIDATION TRANS TYPE | DIM_CONSOL_TRANS_CODE_TYPE_GC_TM | DIM_CONSOL_TRANS_CODE_TYPE_BI | DIM_CONSOL_TRANS_CODE_TYPE | On Line |
| COUNTER PART ONE | DIM_COUNTER_PART_ONE_GC_TM | DIM_COUNTER_PART_ONE_BI | DIM_COUNTER_PART_ONE | On Line |
| COUNTER PART TWO | DIM_COUNTER_PART_TWO_GC_TM | DIM_COUNTER_PART_TWO_BI | DIM_COUNTER_PART_TWO | On Line |
| INTERCOMPANY ELIM RULE | DIM_INTERCOMPANY_ELIM_RULE_TM | DIM_INTERCOMPANY_ELIM_RULE_BI | DIM_INTERCOMPANY_ELIM_RULE | On Line |
| PARALLEL STRUCTURE | DIM_PAR_CONSOL_STRUCTURE_GC_TM | DIM_PAR_CONSOL_STRUCTURE_BI | DIM_PAR_CONSOL_STRUCTURE | On Line |
| POSTING TYPE | DIM_GROCON_POSTING_TYPE_GC_TM | DIM_GROCON_POSTING_TYPE_BI | DIM_GROCON_POSTING_TYPE | On Line |
| REPORT TRANS TYPE | DIM_REPORT_TRANS_TYPE_GC_TM | DIM_REPORT_TRANS_TYPE_BI | DIM_REPORT_TRANS_TYPE | On Line |
| REPORTING COMPANY | DIM_COMPANY_GC_TM | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| REPORTING CURRENCY | DIM_CURRENCY_CODE_GC_TM | DIM_CURRENCY_CODE_BI | DIM_CURRENCY_CODE | On Line |
| REPORTING DATE | DIM_BI_TIME_TM | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| REPORTING ENTITY | DIM_REPORTING_ENTITY_GC_TM | DIM_REPORTING_ENTITY_BI | DIM_REPORTING_ENTITY | On Line |
| REPORTING PERIOD | DIM_REPORTING_PERIOD_GC_TM, alt DIM_BI_TIME_BI combined with DIM_RDP_COMPANY_PERIOD_BI to DIM_BI_TIME_TM | DIM_RDP_COMPANY_PERIOD_BI | DIM_RPD_COMPANY_PERIOD | On Line |
| STRUCTURE | DIM_CONSOL_STRUCTURE_GC_TM | DIM_CONSOL_STRUCTURE_BI | DIM_CONSOL_STRUCTURE | On Line |
| STRUCTURE NODE | DIM_CONSOL_STRUCTURE_NODE_GC_TM | CONSOL_STRUCT_NODE_SORT_ID_BIA | CONSOL_STRUCT_NODE_SORT_ID_BIA | On Line |
| STRUCTURE NODE SUB LEVEL | DIM_CONSOL_SUB_STRUCT_LEVEL_GC_TM | CONSOL_STRUCT_SORT_ID_BIA | CONSOL_STRUCT_SORT_ID_BIA | On Line |
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| CONSOLIDATED BALANCES (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID) |
| CONSOLIDATED BALANCES (Dim Account ID) - ACCOUNT (ID) |
| CONSOLIDATED BALANCES (Dim Account ID) - ACCOUNT ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES (Dim Code B ID) - CODE B (ID) |
| CONSOLIDATED BALANCES (Dim Code B ID) - CODE B ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES (Dim Code C ID) - CODE C (ID) |
| CONSOLIDATED BALANCES (Dim Code C ID) - CODE C ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES (Dim Code D ID) - CODE D (ID) |
| CONSOLIDATED BALANCES (Dim Code D ID) - CODE D ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES (Dim Code E ID) - CODE E (ID) |
| CONSOLIDATED BALANCES (Dim Code E ID) - CODE E ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES (Dim Code F ID) - CODE F (ID) |
| CONSOLIDATED BALANCES (Dim Code F ID) - CODE F ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES (Dim Code G ID) - CODE G (ID) |
| CONSOLIDATED BALANCES (Dim Code G ID) - CODE G ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES (Dim Code H ID) - CODE H (ID) |
| CONSOLIDATED BALANCES (Dim Code H ID) - CODE H ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES (Dim Code I ID) - CODE I (ID) |
| CONSOLIDATED BALANCES (Dim Code I ID) - CODE I ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES (Dim Code J ID) - CODE J (ID) |
| CONSOLIDATED BALANCES (Dim Code J ID) - CODE J ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES (Dim Code N ID) - CODE N (ID) |
| CONSOLIDATED BALANCES (Dim Code O ID) - CODE O (ID) |
| CONSOLIDATED BALANCES (Dim Code P ID) - CODE P (ID) |
| CONSOLIDATED BALANCES (Dim Code Q ID) - CODE Q (ID) |
| CONSOLIDATED BALANCES (Dim Code R ID) - CODE R (ID) |
| CONSOLIDATED BALANCES (Dim Code S ID) - CODE S (ID) |
| CONSOLIDATED BALANCES (Dim Code T ID) - CODE T (ID) |
| CONSOLIDATED BALANCES (Dim Company ID) - COMPANY (ID) |
| CONSOLIDATED BALANCES (Dim Consol Structure ID) - STRUCTURE (ID) |
| CONSOLIDATED BALANCES (Dim Consol Structure Node ID) - STRUCTURE NODE (ID) |
| CONSOLIDATED BALANCES (Dim Consol Struct Sub Level ID) - STRUCTURE NODE SUB LEVEL (ID) |
| CONSOLIDATED BALANCES (Dim Consol Trans Code Type ID) - CONSOLIDATION TRANS TYPE (ID) |
| CONSOLIDATED BALANCES (Dim Counter Part One ID) - COUNTER PART ONE (ID) |
| CONSOLIDATED BALANCES (Dim Counter Part Two ID) - COUNTER PART TWO (ID) |
| CONSOLIDATED BALANCES (Dim Currency Code ID) - REPORTING CURRENCY (ID) |
| CONSOLIDATED BALANCES (Dim Grocon Posting Type ID) - POSTING TYPE (ID) |
| CONSOLIDATED BALANCES (Dim Inter Company Elim Rule ID) - INTERCOMPANY ELIM RULE (ID) |
| CONSOLIDATED BALANCES (Dim Par Consol Structure ID) - PARALLEL STRUCTURE (ID) |
| CONSOLIDATED BALANCES (Dim Reporting Date ID) - REPORTING DATE (ID) |
| CONSOLIDATED BALANCES (Dim Reporting Entity ID) - REPORTING ENTITY (ID) |
| CONSOLIDATED BALANCES (Dim Reporting Period ID) - REPORTING PERIOD (Company-Date) |
| CONSOLIDATED BALANCES (Dim Rep Balance Version ID) - BALANCE VERSION (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Account ID) - ACCOUNT (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Account ID) - ACCOUNT ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code B ID) - CODE B (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code B ID) - CODE B ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code C ID) - CODE C (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code C ID) - CODE C ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code D ID) - CODE D (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code D ID) - CODE D ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code E ID) - CODE E (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code E ID) - CODE E ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code F ID) - CODE F (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code F ID) - CODE F ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code G ID) - CODE G (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code G ID) - CODE G ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code H ID) - CODE H (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code H ID) - CODE H ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code I ID) - CODE I (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code I ID) - CODE I ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code J ID) - CODE J (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code J ID) - CODE J ATTRIBUTE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code N ID) - CODE N (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code O ID) - CODE O (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code P ID) - CODE P (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code Q ID) - CODE Q (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code R ID) - CODE R (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code S ID) - CODE S (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Code T ID) - CODE T (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Company ID) - COMPANY (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Consol Structure ID) - STRUCTURE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Consol Structure Node ID) - STRUCTURE NODE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Consol Struct Sub Level ID) - STRUCTURE NODE SUB LEVEL (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Consol Trans Code Type ID) - CONSOLIDATION TRANS TYPE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Counter Part One ID) - COUNTER PART ONE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Counter Part Two ID) - COUNTER PART TWO (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Currency Code ID) - REPORTING CURRENCY (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Grocon Posting Type ID) - POSTING TYPE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Inter Company Elim Rule ID) - INTERCOMPANY ELIM RULE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Par Consol Structure ID) - PARALLEL STRUCTURE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Reporting Date ID) - REPORTING DATE (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Reporting Entity ID) - REPORTING ENTITY (ID) |
| CONSOLIDATED BALANCES DETAILS (Dim Reporting Period ID) - REPORTING PERIOD (Company-Date) |
| CONSOLIDATED BALANCES DETAILS (Dim Rep Balance Version ID) - BALANCE VERSION (ID) |
| CONSOLIDATED BALANCES DETAILS (ID) - CONSOLIDATED BALANCES DETAILS SHY (ID) |
| CONSOLIDATION ANALYSIS (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID) |
| CONSOLIDATION ANALYSIS (Dim Account ID) - ACCOUNT (ID) |
| CONSOLIDATION ANALYSIS (Dim Account ID) - ACCOUNT ATTRIBUTE (ID) |
| CONSOLIDATION ANALYSIS (Dim Code B ID) - CODE B (ID) |
| CONSOLIDATION ANALYSIS (Dim Code B ID) - CODE B ATTRIBUTE (ID) |
| CONSOLIDATION ANALYSIS (Dim Code C ID) - CODE C (ID) |
| CONSOLIDATION ANALYSIS (Dim Code C ID) - CODE C ATTRIBUTE (ID) |
| CONSOLIDATION ANALYSIS (Dim Code D ID) - CODE D (ID) |
| CONSOLIDATION ANALYSIS (Dim Code D ID) - CODE D ATTRIBUTE (ID) |
| CONSOLIDATION ANALYSIS (Dim Code E ID) - CODE E (ID) |
| CONSOLIDATION ANALYSIS (Dim Code E ID) - CODE E ATTRIBUTE (ID) |
| CONSOLIDATION ANALYSIS (Dim Code F ID) - CODE F (ID) |
| CONSOLIDATION ANALYSIS (Dim Code F ID) - CODE F ATTRIBUTE (ID) |
| CONSOLIDATION ANALYSIS (Dim Code G ID) - CODE G (ID) |
| CONSOLIDATION ANALYSIS (Dim Code G ID) - CODE G ATTRIBUTE (ID) |
| CONSOLIDATION ANALYSIS (Dim Code H ID) - CODE H (ID) |
| CONSOLIDATION ANALYSIS (Dim Code H ID) - CODE H ATTRIBUTE (ID) |
| CONSOLIDATION ANALYSIS (Dim Code I ID) - CODE I (ID) |
| CONSOLIDATION ANALYSIS (Dim Code I ID) - CODE I ATTRIBUTE (ID) |
| CONSOLIDATION ANALYSIS (Dim Code J ID) - CODE J (ID) |
| CONSOLIDATION ANALYSIS (Dim Code J ID) - CODE J ATTRIBUTE (ID) |
| CONSOLIDATION ANALYSIS (Dim Code N ID) - CODE N (ID) |
| CONSOLIDATION ANALYSIS (Dim Code O ID) - CODE O (ID) |
| CONSOLIDATION ANALYSIS (Dim Code P ID) - CODE P (ID) |
| CONSOLIDATION ANALYSIS (Dim Code Q ID) - CODE Q (ID) |
| CONSOLIDATION ANALYSIS (Dim Code R ID) - CODE R (ID) |
| CONSOLIDATION ANALYSIS (Dim Code S ID) - CODE S (ID) |
| CONSOLIDATION ANALYSIS (Dim Code T ID) - CODE T (ID) |
| CONSOLIDATION ANALYSIS (Dim Company ID) - COMPANY (ID) |
| CONSOLIDATION ANALYSIS (Dim Consol Structure ID) - STRUCTURE (ID) |
| CONSOLIDATION ANALYSIS (Dim Consol Structure Node ID) - STRUCTURE NODE (ID) |
| CONSOLIDATION ANALYSIS (Dim Counter Part One ID) - COUNTER PART ONE (ID) |
| CONSOLIDATION ANALYSIS (Dim Counter Part Two ID) - COUNTER PART TWO (ID) |
| CONSOLIDATION ANALYSIS (Dim Currency Code ID) - REPORTING CURRENCY (ID) |
| CONSOLIDATION ANALYSIS (Dim Grocon Balance Set ID) - BALANCE SET (ID) |
| CONSOLIDATION ANALYSIS (Dim Grocon Posting Type ID) - POSTING TYPE (ID) |
| CONSOLIDATION ANALYSIS (Dim Par Consol Structure ID) - PARALLEL STRUCTURE (ID) |
| CONSOLIDATION ANALYSIS (Dim Reporting Date ID) - REPORTING DATE (ID) |
| CONSOLIDATION ANALYSIS (Dim_Reporting_Entity_ID) - REPORTING ENTITY (ID) |
| CONSOLIDATION ANALYSIS (Dim Rep Balance Version ID) - BALANCE VERSION (ID) |
| CONSOLIDATION BALANCE SET (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID) |
| CONSOLIDATION BALANCE SET (Dim Account ID) - ACCOUNT (ID) |
| CONSOLIDATION BALANCE SET (Dim Account ID) - ACCOUNT ATTRIBUTE (ID) |
| CONSOLIDATION BALANCE SET (Dim Code B ID) - CODE B (ID) |
| CONSOLIDATION BALANCE SET (Dim Code B ID) - CODE B ATTRIBUTE (ID) |
| CONSOLIDATION BALANCE SET (Dim Code C ID) - CODE C (ID) |
| CONSOLIDATION BALANCE SET (Dim Code C ID) - CODE C ATTRIBUTE (ID) |
| CONSOLIDATION BALANCE SET (Dim Code D ID) - CODE D (ID) |
| CONSOLIDATION BALANCE SET (Dim Code D ID) - CODE D ATTRIBUTE (ID) |
| CONSOLIDATION BALANCE SET (Dim Code E ID) - CODE E (ID) |
| CONSOLIDATION BALANCE SET (Dim Code E ID) - CODE E ATTRIBUTE (ID) |
| CONSOLIDATION BALANCE SET (Dim Code F ID) - CODE F (ID) |
| CONSOLIDATION BALANCE SET (Dim Code F ID) - CODE F ATTRIBUTE (ID) |
| CONSOLIDATION BALANCE SET (Dim Code G ID) - CODE G (ID) |
| CONSOLIDATION BALANCE SET (Dim Code G ID) - CODE G ATTRIBUTE (ID) |
| CONSOLIDATION BALANCE SET (Dim Code H ID) - CODE H (ID) |
| CONSOLIDATION BALANCE SET (Dim Code H ID) - CODE H ATTRIBUTE (ID) |
| CONSOLIDATION BALANCE SET (Dim Code I ID) - CODE I (ID) |
| CONSOLIDATION BALANCE SET (Dim Code I ID) - CODE I ATTRIBUTE (ID) |
| CONSOLIDATION BALANCE SET (Dim Code J ID) - CODE J (ID) |
| CONSOLIDATION BALANCE SET (Dim Code J ID) - CODE J ATTRIBUTE (ID) |
| CONSOLIDATION BALANCE SET (Dim Code N ID) - CODE N (ID) |
| CONSOLIDATION BALANCE SET (Dim Code O ID) - CODE O (ID) |
| CONSOLIDATION BALANCE SET (Dim Code P ID) - CODE P (ID) |
| CONSOLIDATION BALANCE SET (Dim Code Q ID) - CODE Q (ID) |
| CONSOLIDATION BALANCE SET (Dim Code R ID) - CODE R (ID) |
| CONSOLIDATION BALANCE SET (Dim Code S ID) - CODE S (ID) |
| CONSOLIDATION BALANCE SET (Dim Code T ID) - CODE T (ID) |
| CONSOLIDATION BALANCE SET (Dim Company ID) - COMPANY (ID) |
| CONSOLIDATION BALANCE SET (Dim Consol Structure ID) - STRUCTURE (ID) |
| CONSOLIDATION BALANCE SET (Dim Consol Structure Node ID) - STRUCTURE NODE (ID) |
| CONSOLIDATION BALANCE SET (Dim Counter Part One ID) - COUNTER PART ONE (ID) |
| CONSOLIDATION BALANCE SET (Dim Counter Part Two ID) - COUNTER PART TWO (ID) |
| CONSOLIDATION BALANCE SET (Dim Currency Code ID) - REPORTING CURRENCY (ID) |
| CONSOLIDATION BALANCE SET (Dim Grocon Balance Set ID) - BALANCE SET (ID) |
| CONSOLIDATION BALANCE SET (Dim Grocon Posting Type ID) - POSTING TYPE (ID) |
| CONSOLIDATION BALANCE SET (Dim Par Consol Structure ID) - PARALLEL STRUCTURE (ID) |
| CONSOLIDATION BALANCE SET (Dim Reporting Date ID) - REPORTING DATE (ID) |
| CONSOLIDATION BALANCE SET (Dim_Reporting_Entity_ID) - REPORTING ENTITY (ID) |
| CONSOLIDATION BALANCE SET (Dim Reporting Period ID) - REPORTING PERIOD (Company-Date) |
| CONSOLIDATION BALANCE SET (Dim Rep Balance Version ID) - BALANCE VERSION (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Account ID) - ACCOUNT (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Account ID) - ACCOUNT ATTRIBUTE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code B ID) - CODE B (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code B ID) - CODE B ATTRIBUTE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code C ID) - CODE C (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code C ID) - CODE C ATTRIBUTE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code D ID) - CODE D (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code D ID) - CODE D ATTRIBUTE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code E ID) - CODE E (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code E ID) - CODE E ATTRIBUTE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code F ID) - CODE F (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code F ID) - CODE F ATTRIBUTE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code G ID) - CODE G (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code G ID) - CODE G ATTRIBUTE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code H ID) - CODE H (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code H ID) - CODE H ATTRIBUTE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code I ID) - CODE I (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code I ID) - CODE I ATTRIBUTE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code J ID) - CODE J (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code J ID) - CODE J ATTRIBUTE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code N ID) - CODE N (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code O ID) - CODE O (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code P ID) - CODE P (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code Q ID) - CODE Q (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code R ID) - CODE R (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code S ID) - CODE S (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Code T ID) - CODE T (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Company ID) - COMPANY (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Counter Part One ID) - COUNTER PART ONE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Counter Part Two ID) - COUNTER PART TWO (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Currency Code ID) - REPORTING CURRENCY (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Grocon Posting Type ID) - POSTING TYPE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Reporting Company ID) - REPORTING COMPANY (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Reporting Date ID) - REPORTING DATE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Reporting Entity ID) - REPORTING ENTITY (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Reporting Period ID) - REPORTING PERIOD (Company-Date) |
| CONSOLIDATION REPORTED BALANCES (Dim Report Trans Type ID) - REPORT TRANS TYPE (ID) |
| CONSOLIDATION REPORTED BALANCES (Dim Rep Balance Version ID) - BALANCE VERSION (ID) |
| CURRENCY RATES (DIM_REPORTING_CURRENCY_ID) - REPORTING CURRENCY (ID) |
| CURRENCY RATES (DIM_TIME_ID) - REPORTING DATE (ID) |