On this page you will find the specifications regarding the Model: Group Reporting and Dimension Table: FACT STRUCTURE BASED ANALYSIS.
Represents the Structure based specific analysis source.
Measures derived from the base amounts will be available in STRUCTURE BASED ANALYSIS MEASURES.
| Attribute | Description (where applicable) |
| Dim Code T ID | Code T ID |
| Dim Consol Structure By Period ID | Consolidation Structure Hiearchy ID |
| Dim Node Currency ID | Node Currency ID |
| ID | ID |
| Dim Code S ID | Code S ID |
| Dim Code G ID | Code G ID |
| Dim Code N ID | Code N ID |
| Dim Code H ID | Code H ID |
| Equity Elimination | Equity Elimination |
| Dim Counter Part Two ID | Counterpart Two ID |
| Node Currency | Node Currency Code |
| Dim Currency Code ID | Node Currency ID |
| Dim Code E ID | Code E ID |
| Balance Version | Balance Version Code |
| Dim Code C ID | Code C ID |
| Dim Rep Balance Version ID | Balance Version ID |
| Currency Code | Currency Code |
| Dim Reporting Entity ID | Reporting Entity ID |
| Dim Balance Set ID | Balance Set ID |
| Dim Cons Bal ID | Key for Row level security |
| Dim Code I ID | Code I ID |
| Year Period | Accounting Year and Period |
| Profit Elimination | Profit Elimination |
| Dim Code O ID | Code O ID |
| Dim Code D ID | Code D ID |
| Dim Code F ID | Code F ID |
| Dim Reporting Period ID | Reporting Period ID |
| Dim Consol Trans Code Type ID | Consolidation Transaction Type ID |
| Dim Grocon Posting Type ID | Posting Type ID |
| Dim Code J ID | Code J ID |
| Elimination ID | Elimination ID |
| Node Type | Node Type |
| Dim Code R ID | Code R ID |
| Dim Par Consol Structure ID | Parallel Structure ID |
| Dim Code P ID | Code P ID |
| Dim Counter Part One ID | Counterpart One ID |
| Group Currency | Group Currency Code |
| Dim Company ID | Master Company ID |
| Dim Inter Company Elim Rule ID | Intercompany Elimination Rule ID |
| Dim Code B ID | Code B ID |
| No Elimination | No Elimination |
| Dim Consol Structure ID | Consolidation Structure ID |
| Dim Grocon Balance Set ID | Balance Set ID |
| Dim Account ID | Account ID |
| Dim Code Q ID | Code Q ID |
| Dim Accounting Period ID | Accounting Period ID |
| ACC_PERIOD_END | Accounting Period End Date |
| ACC_PERIOD_FROM | Accounting Period Start Date |
| STR_BALANCE | Balance in Node currency |
| CREDIT_BALANCE_GC | Credit balance in group currency |
| Matching ID | Matching ID |
| CREDIT_BALANCE | Credit balance in node currency |
| DEBIT_BALANCE | Dedit balance in node currency |
| STR_BALANCE_GC | Balance in Group currency |
| Row ID | Row ID |
| DEBIT_BALANCE_GC | Dedit balance in group currency |
| Year | Accounting Year |
| Period | Accounting Period |
| 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 STRUCTURE BASED ANALYSIS | FACT_CON_PER_ADD_DET_BAL_PQ_BI | FACT_CON_PER_ADD_DET_BAL_PQ | On Line |