This Tabular Model is used for: Group Reporting. 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.
The main purpose of the Group Reporting tabular model is to produce financial statements and visualizations based on IFS Group Consolidation. Main reporting tools are Power BI and Excel Pivot Analysis.
To take full advantage of the Group Reporting model it is recommended to set up Accounting Structures for Income Statement and Balance Sheet. By doing so the model will provide dynamic out of the box analysis capabilities.
The model is based on one selected Master Company for group consolidation and all measures are built on the accounting calendar of that company.
This measure group is based on information source Consolidation Reported Balances and can be used to design reports/analysis based on reporting and adjustment journals that are to be used in the consolidation process.
The analysis can be conducted in Currency (transaction currency from reporting entity) or Reporting currency (accounting or parallel currency from the reporting entity)
This measure group is based on information source Consolidated Balances and can be used to design reports/analysis based on consolidated balances which are a result of the Group Consolidation process. The information can be analyzed based on consolidation structure, period, balance version, structure node, sublevel node and reporting entity etc.
The node based analysis should always be performed in the context of a specific structure node. All consolidation transaction types such as translated balances, different elimination types and consolidated balances are available for analysis. Both balance sheet analysis including opening balances and income statement analysis can be performed.
The analysis can be conducted in Currency (Transaction currency or reporting currency of reporting entity depending on set up), Node Currency or in Group currency (Common currency for all structure nodes calculated in the consolidation process).
This measure group is based on information source Consolidated Source Level Period Details. To use this measure group, period balances must have been calculated according to Consolidation Source Level Details method. (Option on Balance Version). This method stores the consolidated balances only on the structure node they first occurs making it possible to aggregate them according to the consolidation structure.
The structure based analysis measure is for Income Statement accounts only and makes it possible to dynamically drill down in the consolidation structure using the Structure Hierarchy dimension.
To be able to use the structure based analysis measure group the consolidated balance versions must be mapped into Balance Sets. A balance set is a definition of your financial balances either in the past or in the future. It can be actuals or planning or a combination of both. The model has four pre-defined balance sets for ACT (Actuals), BUD (Budget), CFC (Current Forecast) and NFC (Next Forecast).
Each pre-defined Balance set comes with pre-calculated measures such as YTD (Year To Date) and PY (Previous Year)
The analysis can be conducted in Currency (Transaction currency or reporting currency of reporting entity depending on set up), Node Currency or in Group currency (Common currency for all structure nodes calculated in the consolidation process). In addition to that analysis model specific currency called X-rate is available only for the structure based analysis measure group.
X-rate measures translates all balances using the Currency rate types and the connected Currency rates of the master company. Using the X-rate for example makes it possible to compare actuals (translated with actual rates) with actuals translated with other rates (e.g. with budget or previous year rates).
There are two different methods to translate accounting currency to X-rate. Period based method use the last available rate of the period to translate the period amount and then accumulate the period amounts to get to the YTD amount. YTD based method use the last available rate of the period to translate the YTD amount and then subtract the YTD amount of the previous period to get to the period amount.
To produce more dynamic reports and taking advantage of the large number of pre-defined measures it is recommended to use Switch measures in combination with pre-defined slicers. By doing so it possible to switch between period and YTD amounts and to dynamically switch comparison measure (BUD, CFC, NFC, PY).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| NODE BASED ANALYSIS MEASURES | ||||
| REPORTED BALANCES ANALYSIS MEASURES | ||||
| STRUCTURE BASED ANALYSIS MEASURES |
Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources
| 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 | DIM_ACC_ATTR_GC_BI, LUP_CONS_ACC_ATTRIBUTE_TC | DIM_ACC_ATTR_GC_BIA | On Line |
| ACCOUNTING PERIOD | DIM_ACCOUNTING_PERIOD_BI | DIM_ACCOUNTING_PERIOD_BI | DIM_ACCOUNTING_PERIOD | On Line |
| BALANCE SET | BI_GROCON_SET_CUBE_CONFIG_TM | BI_GROCON_SET_CUBE_CONFIG_BIA | BI_GROCON_SET_CUBE_CONFIG_BIA | 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 | DIM_ACC_ATTR_GC_BI, LUP_CONS_ACC_ATTRIBUTE_TC | DIM_ACC_ATTR_GC_BIA | 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 | DIM_ACC_ATTR_GC_BI, LUP_CONS_ACC_ATTRIBUTE_TC | DIM_ACC_ATTR_GC_BIA | 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 | DIM_ACC_ATTR_GC_BI, LUP_CONS_ACC_ATTRIBUTE_TC | DIM_ACC_ATTR_GC_BIA | 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 | DIM_ACC_ATTR_GC_BI, LUP_CONS_ACC_ATTRIBUTE_TC | DIM_ACC_ATTR_GC_BIA | 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 | DIM_ACC_ATTR_GC_BI, LUP_CONS_ACC_ATTRIBUTE_TC | DIM_ACC_ATTR_GC_BIA | 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 | DIM_ACC_ATTR_GC_BI, LUP_CONS_ACC_ATTRIBUTE_TC | DIM_ACC_ATTR_GC_BIA | 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 | DIM_ACC_ATTR_GC_BI, LUP_CONS_ACC_ATTRIBUTE_TC | DIM_ACC_ATTR_GC_BIA | 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 | DIM_ACC_ATTR_GC_BI, LUP_CONS_ACC_ATTRIBUTE_TC | DIM_ACC_ATTR_GC_BIA | 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 | DIM_ACC_ATTR_GC_BI, LUP_CONS_ACC_ATTRIBUTE_TC | DIM_ACC_ATTR_GC_BIA | On Line |
| CODE N | DIM_CODE_N_GC_TM | DIM_CODE_N_BI | DIM_CODE_N | On Line |
| CODE O | DIM_CODE_O_GC_TM | DIM_CODE_O_BI | DIM_CODE_O | On Line |
| CODE P | DIM_CODE_P_GC_TM | DIM_CODE_P_BI | DIM_CODE_P | On Line |
| CODE Q | DIM_CODE_Q_GC_TM | DIM_CODE_Q_BI | DIM_CODE_Q | On Line |
| CODE R | DIM_CODE_R_GC_TM | DIM_CODE_R_BI | DIM_CODE_R | On Line |
| CODE S | DIM_CODE_S_GC_TM | DIM_CODE_S_BI | DIM_CODE_S | On Line |
| CODE T | DIM_CODE_T_GC_TM | DIM_CODE_T_BI | DIM_CODE_T | On Line |
| COMPANY | DIM_COMPANY_GR_TM | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| CONSOL BAL ACCESS RLS | CONSOL_BAL_ACCESS_RLS | CONSOL_BAL_ACCESS_RLS_BI | CONSOL_BAL_ACCESS_RLS | On Line |
| CONSOL COMBINATION | DIM_CONSOL_COMBINATION_TM | DIM_CONSOL_COMBINATION_BI | CONSOL_COMBINATIONS_BIA | On Line |
| CONSOLIDATION TRANS TYPE | DIM_CONSOL_TRANS_CODE_TYPE_GC_TM | DIM_CONSOL_TRANS_CODE_TYPE_BI | DIM_CONSOL_TRANS_CODE_TYPE | On Line |
| COUNTERPART ONE | DIM_COUNTER_PART_ONE_GR_TM | DIM_COUNTER_PART_ONE_BI | DIM_COUNTER_PART_ONE | On Line |
| COUNTERPART TWO | DIM_COUNTER_PART_TWO_GR_TM | DIM_COUNTER_PART_TWO_BI | DIM_COUNTER_PART_TWO | On Line |
| CURRENCY CODE X RATE | DIM_CURRENCY_CODE_XRATE_TM | DIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TC | DIM_CURRENCY_CODE_XRATE | On Line |
| CURRENCY RATES PERIODXRATE | FACT_CURRENCY_RATES_PERIODXRATE | DIM_BI_TIME_BI, DIM_RPD_COMPANY_PERIOD_BI, LUP_REPORTING_PERIOD_TC, DIM_CURRENCY_CODE_BI, DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TC | FACT_CURRENCY_RATES_PERIODXRATE | Data Mart |
| FACT NODE BASED ANALYSIS | FACT_CONSOL_BALANCE_NODEBASED_TM | FACT_CONSOL_BALANCE_NODEBASED_BI | FACT_CONSOL_BALANCE | Data Mart |
| FACT REPORTED BALANCES ANALYSIS | FACT_CONSOL_REP_BALANCE_GR_TM | FACT_CONSOL_REP_BALANCE_BI | FACT_CONSOL_REP_BALANCE | Data Mart |
| FACT STRUCTURE BASED ANALYSIS | FACT_CONSOL_BALANCE_STRUCTBASED_TM | FACT_CONSOL_BALANCE_STRUCTBASED_BI | FACT_CONSOL_PER_ADD_DET_BAL | Data Mart |
| INTERCOMPANY ELIM RULE | DIM_INTERCOMPANY_ELIM_RULE_GC_TM | DIM_INTERCOMPANY_ELIM_RULE_BI | DIM_INTERCOMPANY_ELIM_RULE | On Line |
| MEASURE LIST ACTUAL | GC_MEASURE_LIST_ACTUAL | N/A | N/A | |
| MEASURE LIST COMPARISON | GC_MEASURE_LIST_COMPARISON | N/A | N/A | |
| POSTING TYPE | DIM_GROCON_POSTING_TYPE_GC_TM | DIM_GROCON_POSTING_TYPE_BI | DIM_GROCON_POSTING_TYPE | On Line |
| RATE TYPE X RATE | DIM_CURRENCY_RATE_TYPE_XRATE_TM | DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TC | DIM_CURRENCY_RATE_TYPE_XRATE | On Line |
| REPORT BAL ACCESS RLS | REPORT_BAL_ACCESS_RLS | REPORT_BAL_ACCESS_RLS_BI | REPORT_BAL_ACCESS_RLS | On Line |
| REPORT COMBINATION | DIM_REPORT_COMBINATION_TM | DIM_REPORT_COMBINATION_BI | REPORT_COMBINATIONS_BIA | 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_REPORTING_COMPANY_GR_TM | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| REPORTING CURRENCY | DIM_CURRENCY_CODE_GR_TM | DIM_CURRENCY_CODE_BI | DIM_CURRENCY_CODE | On Line |
| REPORTING ENTITY | DIM_REPORTING_ENTITY_GR_TM | DIM_REPORTING_ENTITY_GR_BI | DIM_REPORTING_ENTITY | On Line |
| STRUCTURE | DIM_CONSOL_STRUCTURE_GC_TM | DIM_CONSOL_STRUCTURE_BI | DIM_CONSOL_STRUCTURE | On Line |
| STRUCTURE HIEARCHY | DIM_CONSOL_STRUCTURE_BY_PER_GC_TM | DIM_CONSOL_STRUCTURE_BY_PER_GC_BI | CONSOL_STRUCT_BIA | 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 |
| SWITCH COMPARISON MEASURE | GL_SWITCH_COMP_MEAS | N/A | N/A | |
| SWITCH CURRENCY TYPE | GC_SWITCH_CURRENCY_TYPE | N/A | N/A | |
| SWITCH DISPLAY UNIT | GL_SWITCH_DISPLAY_UNIT | N/A | N/A | |
| SWITCH TIME PERSPECTIVE | GL_SWITCH_TIME_PERSPECTIVE | N/A | N/A | |
| X-RATE 1 FROM CURRENCY | DIM_CURRENCY_CODE_XRATE_TM | DIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TC | DIM_CURRENCY_CODE_XRATE | On Line |
| X-RATE 1 RATE TYPE | DIM_CURRENCY_RATE_TYPE_XRATE_TM | DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TC | DIM_CURRENCY_RATE_TYPE_XRATE | On Line |
| X-RATE 2 FROM CURRENCY | DIM_CURRENCY_CODE_XRATE_TM | DIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TC | DIM_CURRENCY_CODE_XRATE | On Line |
| X-RATE 2 RATE TYPE | DIM_CURRENCY_RATE_TYPE_XRATE_TM | DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TC | DIM_CURRENCY_RATE_TYPE_XRATE | On Line |
| X-RATE TO CURRENCY | DIM_CURRENCY_CODE_XRATE_TM | DIM_CURRENCY_CODE_BI, LUP_REP_CURR_RATE_TC | DIM_CURRENCY_CODE_XRATE | On Line |
| X-RATES 1 | FACT_CURRENCY_RATES_PERIODXRATE | DIM_BI_TIME_BI, DIM_RPD_COMPANY_PERIOD_BI, LUP_REPORTING_PERIOD_TC, DIM_CURRENCY_CODE_BI, DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TC | FACT_CURRENCY_RATES_PERIODXRATE | Data Mart |
| X-RATES 2 | FACT_CURRENCY_RATES_PERIODXRATE | DIM_BI_TIME_BI, DIM_RPD_COMPANY_PERIOD_BI, LUP_REPORTING_PERIOD_TC, DIM_CURRENCY_CODE_BI, DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TC | FACT_CURRENCY_RATES_PERIODXRATE | Data Mart |
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| CONSOL BAL ACCESS RLS (CONS_BAL_ID) - CONSOL COMBINATION (ID) |
| FACT NODE BASED ANALYSIS (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID) |
| FACT NODE BASED ANALYSIS (Dim Account ID) - ACCOUNT (ID) |
| FACT NODE BASED ANALYSIS (Dim Account ID) - ACCOUNT ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code B ID) - CODE B (ID) |
| FACT NODE BASED ANALYSIS (Dim Code B ID) - CODE B ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code C ID) - CODE C (ID) |
| FACT NODE BASED ANALYSIS (Dim Code C ID) - CODE C ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code D ID) - CODE D (ID) |
| FACT NODE BASED ANALYSIS (Dim Code D ID) - CODE D ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code E ID) - CODE E (ID) |
| FACT NODE BASED ANALYSIS (Dim Code E ID) - CODE E ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code F ID) - CODE F (ID) |
| FACT NODE BASED ANALYSIS (Dim Code F ID) - CODE F ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code G ID) - CODE G (ID) |
| FACT NODE BASED ANALYSIS (Dim Code G ID) - CODE G ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code H ID) - CODE H (ID) |
| FACT NODE BASED ANALYSIS (Dim Code H ID) - CODE H ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code I ID) - CODE I (ID) |
| FACT NODE BASED ANALYSIS (Dim Code I ID) - CODE I ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code J ID) - CODE J (ID) |
| FACT NODE BASED ANALYSIS (Dim Code J ID) - CODE J ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code N ID) - CODE N (ID) |
| FACT NODE BASED ANALYSIS (Dim Code O ID) - CODE O (ID) |
| FACT NODE BASED ANALYSIS (Dim Code P ID) - CODE P (ID) |
| FACT NODE BASED ANALYSIS (Dim Code Q ID) - CODE Q (ID) |
| FACT NODE BASED ANALYSIS (Dim Code R ID) - CODE R (ID) |
| FACT NODE BASED ANALYSIS (Dim Code S ID) - CODE S (ID) |
| FACT NODE BASED ANALYSIS (Dim Code T ID) - CODE T (ID) |
| FACT NODE BASED ANALYSIS (Dim Company ID) - COMPANY (ID) |
| FACT NODE BASED ANALYSIS (Dim Consol Structure ID) - STRUCTURE (ID) |
| FACT NODE BASED ANALYSIS (Dim Consol Structure Node ID) - STRUCTURE NODE (ID) |
| FACT NODE BASED ANALYSIS (Dim Consol Struct Sub Level ID) - STRUCTURE NODE SUB LEVEL (ID) |
| FACT NODE BASED ANALYSIS (Dim Consol Trans Code Type ID) - CONSOLIDATION TRANS TYPE (ID) |
| FACT NODE BASED ANALYSIS (Dim Cons Bal ID) - CONSOL COMBINATION (ID) |
| FACT NODE BASED ANALYSIS (Dim Counter Part One ID) - COUNTERPART ONE (ID) |
| FACT NODE BASED ANALYSIS (Dim Counter Part Two ID) - COUNTERPART TWO (ID) |
| FACT NODE BASED ANALYSIS (Dim Grocon Posting Type ID) - POSTING TYPE (ID) |
| FACT NODE BASED ANALYSIS (Dim Inter Company Elim Rule ID) - INTERCOMPANY ELIM RULE (ID) |
| FACT NODE BASED ANALYSIS (Dim Reporting Entity ID) - REPORTING ENTITY (ID) |
| FACT NODE BASED ANALYSIS (Dim Rep Balance Version ID) - BALANCE VERSION (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Account ID) - ACCOUNT (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Account ID) - ACCOUNT ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code B ID) - CODE B (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code B ID) - CODE B ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code C ID) - CODE C (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code C ID) - CODE C ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code D ID) - CODE D (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code D ID) - CODE D ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code E ID) - CODE E (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code E ID) - CODE E ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code F ID) - CODE F (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code F ID) - CODE F ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code G ID) - CODE G (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code G ID) - CODE G ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code H ID) - CODE H (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code H ID) - CODE H ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code I ID) - CODE I (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code I ID) - CODE I ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code J ID) - CODE J (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code J ID) - CODE J ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code N ID) - CODE N (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code O ID) - CODE O (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code P ID) - CODE P (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code Q ID) - CODE Q (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code R ID) - CODE R (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code S ID) - CODE S (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code T ID) - CODE T (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Company ID) - COMPANY (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Counter Part One ID) - COUNTERPART ONE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Counter Part Two ID) - COUNTERPART TWO (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Currency Code ID) - REPORTING CURRENCY (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Grocon Posting Type ID) - POSTING TYPE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Reporting Company ID) - REPORTING COMPANY (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Reporting Entity ID) - REPORTING ENTITY (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Report Trans Type ID) - REPORT TRANS TYPE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Rep Balance Version ID) - BALANCE VERSION (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Rep Bal ID) - REPORT COMBINATION (ID) |
| FACT STRUCTURE BASED ANALYSIS (Currency Code) - CURRENCY CODE X RATE (Currency Code) |
| FACT STRUCTURE BASED ANALYSIS (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Account ID) - ACCOUNT (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Account ID) - ACCOUNT ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Balance Set ID) - BALANCE SET (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code B ID) - CODE B (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code B ID) - CODE B ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code C ID) - CODE C (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code C ID) - CODE C ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code D ID) - CODE D (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code D ID) - CODE D ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code E ID) - CODE E (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code E ID) - CODE E ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code F ID) - CODE F (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code F ID) - CODE F ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code G ID) - CODE G (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code G ID) - CODE G ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code H ID) - CODE H (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code H ID) - CODE H ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code I ID) - CODE I (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code I ID) - CODE I ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code J ID) - CODE J (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code J ID) - CODE J ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code N ID) - CODE N (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code O ID) - CODE O (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code P ID) - CODE P (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code Q ID) - CODE Q (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code S ID) - CODE S (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code T ID) - CODE T (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Company ID) - COMPANY (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Consol Structure By Period ID) - STRUCTURE HIEARCHY (Child Long ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Consol Structure ID) - STRUCTURE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Consol Trans Code Type ID) - CONSOLIDATION TRANS TYPE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Cons Bal ID) - CONSOL COMBINATION (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Counter Part One ID) - COUNTERPART ONE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Counter Part Two ID) - COUNTERPART TWO (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Currency Code ID) - REPORTING CURRENCY (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Grocon Posting Type ID) - POSTING TYPE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Inter Company Elim Rule ID) - INTERCOMPANY ELIM RULE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Reporting Entity ID) - REPORTING ENTITY (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Rep Balance Version ID) - BALANCE VERSION (ID) |
| FACT STRUCTURE BASED ANALYSIS (Node Currency) - X-RATE 1 FROM CURRENCY (From Currency Code) |
| FACT STRUCTURE BASED ANALYSIS (Node Currency) - X-RATE 2 FROM CURRENCY (From Currency Code) |
| MEASURE LIST ACTUAL (Dim Currency Type Id) - SWITCH CURRENCY TYPE (Row Index) |
| MEASURE LIST ACTUAL (Dim Time Perspective Id) - SWITCH TIME PERSPECTIVE (Row Index) |
| MEASURE LIST COMPARISON (Dim Comparison Id) - SWITCH COMPARISON MEASURE (Row Index) |
| MEASURE LIST COMPARISON (Dim Currency Type Id) - SWITCH CURRENCY TYPE (Row Index) |
| MEASURE LIST COMPARISON (Dim Time Perspective Id) - SWITCH TIME PERSPECTIVE (Row Index) |
| REPORT BAL ACCESS RLS (REP_BAL_ID) - REPORT COMBINATION (ID) |
| X-RATES 1 (CURRENCY_RATE_TYPE_KEY) - X-RATE 1 RATE TYPE (Rate Type Code X-Rate 1) |
| X-RATES 1 (FROMCURRENCY) - X-RATE 1 FROM CURRENCY (From Currency Code) |
| X-RATES 1 (TOCURRENCY) - X-RATE TO CURRENCY (To Currency Code) |
| X-RATES 2 (CURRENCY_RATE_TYPE_KEY) - X-RATE 2 RATE TYPE (Rate Type Code X-Rate 2) |
| X-RATES 2 (FROMCURRENCY) - X-RATE 2 FROM CURRENCY (From Currency Code) |
| X-RATES 2 (TOCURRENCY) - X-RATE TO CURRENCY (To Currency Code) |