This Analysis Model is used for: Group Reporting. There is a list of Analysis Models pre-packaged and delivered as a part of Analysis Models - Power BI, and you can refer to them here.
| Model Table | 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 | BI Access View | Referenced Information Source | Recommended Access Type |
| BALANCE SET | BI_GROCON_SET_CUBE_CONFIG_BIA | BI_GROCON_SET_CUBE_CONFIG | On Line |
| ACCOUNT | DIM_ACCOUNT_BI | DIM_ACCOUNT | On Line |
| ACCOUNTING PERIOD | DIM_ACCOUNTING_PERIOD_BI | DIM_ACCOUNTING_PERIOD | On Line |
| BALANCE VERSION | DIM_REP_BALANCE_VERSION_PQ_BI | DIM_REP_BALANCE_VERSION_PQ | On Line |
| CODE B | DIM_CODE_B_BI | DIM_CODE_B | On Line |
| CODE C | DIM_CODE_C_BI | DIM_CODE_C | On Line |
| CODE D | DIM_CODE_D_BI | DIM_CODE_D | On Line |
| CODE E | DIM_CODE_E_BI | DIM_CODE_E | On Line |
| CODE F | DIM_CODE_F_BI | DIM_CODE_F | On Line |
| CODE G | DIM_CODE_G_BI | DIM_CODE_G | On Line |
| CODE H | DIM_CODE_H_BI | DIM_CODE_H | On Line |
| CODE I | DIM_CODE_I_BI | DIM_CODE_I | On Line |
| CODE J | DIM_CODE_J_BI | DIM_CODE_J | On Line |
| CODE N | DIM_CODE_M_BI | DIM_CODE_M | On Line |
| CODE O | DIM_CODE_N_BI | DIM_CODE_N | On Line |
| CODE P | DIM_CODE_O_BI | DIM_CODE_O | On Line |
| CODE Q | DIM_CODE_P_BI | DIM_CODE_P | On Line |
| CODE R | DIM_CODE_Q_BI | DIM_CODE_Q | On Line |
| CODE S | DIM_CODE_R_BI | DIM_CODE_R | On Line |
| CODE T | DIM_CODE_S_BI | DIM_CODE_S | On Line |
| COMPANY | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| REPORTING COMPANY | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| COUNTERPART TWO | DIM_COUNTER_PART_TWO_GR_PQ_BI | DIM_COUNTER_PART_TWO_GR_PQ | On Line |
| INTERCOMPANY ELIM RULE | DIM_INTERCOM_ELIM_RULE_PQ_BI | DIM_INTERCOM_ELIM_RULE_PQ | On Line |
| REPORT TRANS TYPE | DIM_REPORT_TRANS_TYPE_PQ_BI | DIM_REPORT_TRANS_TYPE_PQ | On Line |
| REPORTING CURRENCY | DIM_REPORTING_CURRENCY_PQ_BI | DIM_CURRENCY_CODE_GR_PQ | On Line |
| REPORTING ENTITY | DIM_REPORTING_ENTITY_PQ_BI | DIM_REPORTING_ENTITY_PQ | On Line |
| STRUCTURE NODE | CONSOL_STRUCT_NODE_SORT_ID_BIA | CONSOL_STRUCT_NODE_SORT_ID_BIA | On Line |
| POSTING TYPE | DIM_GROCON_POSTING_TYPE_BI | DIM_GROCON_POSTING_TYPE | On Line |
| CONSOLIDATION TRANS TYPE | DIM_CONSOL_TRANS_CODE_TYPE_BI | DIM_CONSOL_TRANS_CODE_TYPE | On Line |
| SWITCH COMPARISON MEASURE | N/A | N/A | |
| SWITCH CURRENCY TYPE | N/A | N/A | |
| SWITCH DISPLAY UNIT | N/A | N/A | |
| SWITCH TIME PERSPECTIVE | N/A | N/A | |
| COUNTERPART ONE | DIM_COUNTER_PART_ONE_GR_PQ_BI | DIM_COUNTER_PART_ONE_GR_PQ | On Line |
| X-RATE 1 FROM CURRENCY | N/A | N/A | |
| X-RATE 1 RATE TYPE | N/A | N/A | |
| X-RATE 2 FROM CURRENCY | N/A | N/A | |
| X-RATE 2 RATE TYPE | N/A | N/A | |
| X-RATE TO CURRENCY | N/A | N/A | |
| X-RATES 1 | N/A | N/A | |
| X-RATES 2 | N/A | N/A | |
| MEASURE LIST ACTUAL | N/A | N/A | |
| MEASURE LIST COMPARISON | N/A | N/A | |
| CODE B ATTRIBUTE | DIM_ACC_ATTR1_ACCOUNT_GR_PQ_BI | DIM_ACC_ATTR1_CODE_B_GR_PQ | On Line |
| CODE C ATTRIBUTE | DIM_ACC_ATTR1_CODE_C_GR_PQ_BI | DIM_ACC_ATTR1_CODE_C_GR_PQ | On Line |
| CODE D ATTRIBUTE | DIM_ACC_ATTR1_CODE_D_GR_PQ_BI | DIM_ACC_ATTR1_CODE_D_GR_PQ | On Line |
| CODE E ATTRIBUTE | DIM_ACC_ATTR1_CODE_E_GR_PQ_BI | DIM_ACC_ATTR1_CODE_E_GR_PQ | On Line |
| CODE F ATTRIBUTE | DIM_ACC_ATTR1_CODE_F_GR_PQ_BI | DIM_ACC_ATTR1_CODE_F_GR_PQ | On Line |
| CODE G ATTRIBUTE | DIM_ACC_ATTR1_CODE_G_GR_PQ_BI | DIM_ACC_ATTR1_CODE_G_GR_PQ | On Line |
| CODE H ATTRIBUTE | DIM_ACC_ATTR1_CODE_H_GR_PQ_BI | DIM_ACC_ATTR1_CODE_H_GR_PQ | On Line |
| CODE I ATTRIBUTE | DIM_ACC_ATTR1_CODE_I_GR_PQ_BI | DIM_ACC_ATTR1_CODE_I_GR_PQ | On Line |
| STRUCTURE | DIM_CONSOL_STRUCTURE_PQ_BI | DIM_CONSOL_STRUCTURE_PQ | On Line |
| STRUCTURE NODE SUB LEVEL | DIM_CON_SUB_STRUCT_LEVEL_PQ_BI | DIM_CON_SUB_STRUCT_LEVEL_PQ | On Line |
| STRUCTURE HIEARCHY | DIM_CONSOL_STRUCT_BY_PER_PQ_BI | DIM_CONSOL_STRUCT_BY_PER_PQ | On Line |
| CODE J ATTRIBUTE | DIM_ACC_ATTR1_CODE_J_GR_PQ_BI | DIM_ACC_ATTR1_CODE_J_GR_PQ | On Line |
| ACCOUNT ATTRIBUTE | DIM_ACC_ATTR1_ACCOUNT_GR_PQ_BI | DIM_ACC_ATTR1_ACCOUNT_GR_PQ | On Line |
| FACT NODE BASED ANALYSIS | FACT_CONSOL_BALANCE_PQ_BI | FACT_CONSOL_BALANCE_PQ | On Line |
| FACT STRUCTURE BASED ANALYSIS | FACT_CON_PER_ADD_DET_BAL_PQ_BI | FACT_CON_PER_ADD_DET_BAL_PQ | On Line |
| FACT REPORTED BALANCES ANALYSIS | FACT_CONSOL_REP_BALANCE_PQ_BI | FACT_CONSOL_REP_BALANCE_PQ | On Line |
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| 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 2 (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 1 (TOCURRENCY) - X-RATE TO CURRENCY (To Currency Code) |
| X-RATES 2 (FROMCURRENCY) - X-RATE 2 FROM CURRENCY (From Currency Code) |
| STRUCTURE NODE SUB LEVEL (Reporting Company Code) - REPORTING COMPANY (Reporting Company Code) |
| STRUCTURE NODE SUB LEVEL (Currency Code) - REPORTING CURRENCY (Reporting Currency Code) |
| MEASURE LIST ACTUAL (Dim Time Perspective Id) - SWITCH TIME PERSPECTIVE (Row Index) |
| MEASURE LIST ACTUAL (Dim Currency Type Id) - SWITCH CURRENCY TYPE (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) |
| FACT REPORTED BALANCES ANALYSIS (Dim Accounting Period ID) - ACCOUNTING PERIOD (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 C ID) - CODE C (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code D ID) - CODE D (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code E ID) - CODE E (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code F ID) - CODE F (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code G ID) - CODE G (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code H ID) - CODE H (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code I ID) - CODE I (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code J ID) - CODE J (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 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 Rep Balance Version ID) - BALANCE VERSION (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Company ID) - COMPANY (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Cons Bal ID) - CONSOL COMBINATION (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Consol Trans Code Type ID) - CONSOLIDATION TRANS TYPE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Counter Part One ID) - COUNTERPART ONE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Counter Part Two ID) - COUNTERPART TWO (ID) |
| FACT STRUCTURE BASED ANALYSIS (Currency Code) - CURRENCY CODE X RATE (Currency Code) |
| FACT STRUCTURE BASED ANALYSIS (Dim Inter Company Elim Rule ID) - INTERCOMPANY ELIM RULE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Grocon Posting Type ID) - POSTING TYPE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Currency Code ID) - REPORTING CURRENCY (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Reporting Entity ID) - REPORTING ENTITY (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Consol Structure ID) - STRUCTURE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Consol Structure By Period ID) - STRUCTURE HIEARCHY (Child Long 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) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code B ID) - CODE B ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code C ID) - CODE C ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code D ID) - CODE D ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code E ID) - CODE E ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code F ID) - CODE F ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code G ID) - CODE G ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code H ID) - CODE H ATTRIBUTE (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code I ID) - CODE I ATTRIBUTE (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 R ID) - CODE R (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 Code Q ID) - CODE Q (ID) |
| FACT NODE BASED ANALYSIS (Dim Account ID) - ACCOUNT ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Accounting Period ID) - ACCOUNTING PERIOD (ID) |
| FACT NODE BASED ANALYSIS (Dim Code B ID) - CODE B ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code C ID) - CODE C ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code D ID) - CODE D ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code E ID) - CODE E ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code F ID) - CODE F ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code G ID) - CODE G ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code H ID) - CODE H ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code I ID) - CODE I ATTRIBUTE (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 Cons Bal ID) - CONSOL COMBINATION (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Account ID) - ACCOUNT (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Account ID) - ACCOUNT (ID) |
| FACT NODE BASED ANALYSIS (Dim Account ID) - ACCOUNT (ID) |
| FACT NODE BASED ANALYSIS (Dim Code B ID) - CODE B (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code B ID) - CODE B (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code B ID) - CODE B ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code C ID) - CODE C (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code C ID) - CODE C (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code C ID) - CODE C ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code D ID) - CODE D (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code D ID) - CODE D (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code D ID) - CODE D ATTRIBUTE (ID) |
| FACT NODE BASED ANALYSIS (Dim Code E ID) - CODE E (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code E ID) - CODE E (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code F ID) - CODE F (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code G ID) - CODE G (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code H ID) - CODE H (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code I ID) - CODE I (ID) |
| FACT STRUCTURE BASED ANALYSIS (Dim Code J ID) - CODE J (ID) |
| FACT NODE BASED ANALYSIS (Dim Code F ID) - CODE F (ID) |
| FACT NODE BASED ANALYSIS (Dim Code G ID) - CODE G (ID) |
| FACT NODE BASED ANALYSIS (Dim Code H ID) - CODE H (ID) |
| FACT NODE BASED ANALYSIS (Dim Code I ID) - CODE I (ID) |
| FACT NODE BASED ANALYSIS (Dim Code J ID) - CODE J (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code E ID) - CODE E ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code F ID) - CODE F ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code G ID) - CODE G ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code H ID) - CODE H ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code I ID) - CODE I ATTRIBUTE (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Code J ID) - CODE J ATTRIBUTE (ID) |
| CONSOL BAL ACCESS RLS (CONS_BAL_ID) - CONSOL COMBINATION (ID) |
| REPORT BAL ACCESS RLS (REP_BAL_ID) - REPORT COMBINATION (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Rep Bal ID) - REPORT COMBINATION (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Reporting Company ID) - REPORTING COMPANY (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 Entity ID) - REPORTING ENTITY (ID) |
| FACT REPORTED BALANCES ANALYSIS (Dim Report Trans Type ID) - REPORT TRANS TYPE (ID) |
| FACT NODE BASED ANALYSIS (Dim Rep Balance Version ID) - BALANCE VERSION (ID) |
| FACT NODE BASED ANALYSIS (Dim Company ID) - COMPANY (ID) |
| FACT NODE BASED ANALYSIS (Dim Consol Trans Code Type ID) - CONSOLIDATION TRANS TYPE (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 Inter Company Elim Rule ID) - INTERCOMPANY ELIM RULE (ID) |
| FACT NODE BASED ANALYSIS (Dim Grocon Posting Type ID) - POSTING TYPE (ID) |
| FACT NODE BASED ANALYSIS (Dim Reporting Entity ID) - REPORTING ENTITY (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) |