On this page you will find the specifications regarding the Model: Group Reporting and Dimension Table: FACT NODE BASED ANALYSIS.
Represents the Node based specific analysis source.
Measures derived from the base amounts will be available in NODE BASED ANALYSIS MEASURES.
| Attribute | Description (where applicable) |
| Dim Code B ID | Code B ID |
| Dim Code C ID | Code C ID |
| No Elimination | No Elimination |
| Dim Code E ID | Code E ID |
| Dim Code P ID | Code P ID |
| Dim Accounting Period ID | Accounting Period ID |
| Dim Account ID | Account ID |
| Dim Code S ID | Code S ID |
| Dim Code H ID | Code H ID |
| Dim Code Q ID | Code Q ID |
| Dim Code D ID | Code Q ID |
| ID | ID |
| Equity Elimination | Equity Elimination |
| Dim Code I ID | Code I ID |
| Dim Code R ID | Code R ID |
| Dim Code O ID | Code O ID |
| Dim Cons Bal ID | Key for Row level security |
| Dim Code F ID | Code F ID |
| Dim Code N ID | Code N ID |
| Structure | Structure id |
| Year Period | Year and Period |
| Dim Code G ID | Code G ID |
| Dim Code T ID | Code T ID |
| Dim Code J ID | Code J ID |
| Profit Elimination | Profit Elimination |
| Dim Reporting Date ID | Reporting Date |
| Matching ID | Matching ID |
| DEBIT_BALANCE | Dedit Balance as YTD value in Node currency |
| DEBIT_BALANCE_GC | Dedit Balance as YTD value in Group currency |
| CREDIT_BALANCE_GC | Credit Balance as YTD value in Node currency |
| CREDIT_BALANCE | Credit Balance as YTD value in Group currency |
| Dim Grocon Posting Type ID | Posting Type ID |
| Dim Consol Trans Code Type ID | Consolidation Transaction Type ID |
| Dim Currency Code ID | Currency Code |
| Dim Consol Structure Node ID | Consolidation Structure Node ID |
| Dim Par Consol Structure ID | Parallel Structure ID |
| Dim Company ID | Company Code |
| Dim Consol Structure ID | Consolidation Structure ID |
| Dim Counter Part Two ID | Counterpart Two ID |
| Dim Reporting Entity ID | Reporting Entity ID |
| Dim Consol Struct Sub Level ID | Consolidation Structure Sub Level ID |
| Dim Inter Company Elim Rule ID | Intercompany Elimination Rule ID |
| Dim Rep Balance Version ID | Balance Version ID |
| Dim Counter Part One ID | Counterpart One ID |
| Dim Reporting Period ID | Reporting Period ID |
| NOD_BALANCE | Balance as YTD value in Node currency |
| NOD_CURR_BALANCE | Balance as YTD value in Group currency |
| NOD_BALANCE_GC | Balance as YTD value in currency |
| Model Name |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| FACT NODE BASED ANALYSIS | FACT_CONSOL_BALANCE_PQ_BI | FACT_CONSOL_BALANCE_PQ | On Line |