On this page you will find the specifications regarding the Model: Group Reporting and Dimension Table: FACT REPORTED BALANCES ANALYSIS.
Represents the Reported balances based specific analysis source.
Measures derived from the base amounts will be available in REPORTED BALANCES ANALYSIS MEASURES.
| Attribute | Description (where applicable) |
| Dim Code O ID | Code O ID |
| Dim Code B ID | Code B ID |
| Journal ID | Journal ID |
| Dim Code C ID | Code C ID |
| Dim Code P ID | Code P ID |
| Dim Code E ID | Code E ID |
| Dim Code T ID | Code T ID |
| Dim Code H ID | Code H ID |
| Dim Code S ID | Code S ID |
| Dim Code G ID | Code G ID |
| Dim Account ID | Account ID |
| Dim Code N ID | Code N ID |
| Dim Accounting Period ID | Accounting Period ID |
| Dim Code I ID | Code I ID |
| Dim Code J ID | Code J ID |
| Dim Code D ID | Code D ID |
| Dim Code Q ID | Code Q ID |
| Dim Code R ID | Code R ID |
| ID | ID |
| Dim Code F ID | Code F ID |
| CREDIT_BALANCE | Credit balance as YTD value in reporting currency |
| DEBIT_BALANCE | Debit balance as YTD value in reporting currency |
| Dim Rep Bal ID | Key for Row level security |
| REP_BALANCE | Balance as YTD value in Reporting currency |
| REP_CURR_BALANCE | Balance as YTD value in currency |
| Dim Report Trans Type ID | Reporting Transaction Type ID |
| Dim Currency Code ID | Currency Code |
| Dim Counter Part Two ID | Counterpart Two ID |
| Dim Company ID | Company Code |
| Dim Reporting Company ID | Reporting Company Code |
| Dim Reporting Entity ID | Reporting Entity ID |
| Dim Counter Part One ID | Counterpart One ID |
| Dim Grocon Posting Type ID | Posting Type ID |
| Dim Rep Balance Version ID | Balance Version ID |
| Dim Reporting Period ID | Reporting Period ID |
| 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 REPORTED BALANCES ANALYSIS | FACT_CONSOL_REP_BALANCE_PQ_BI | FACT_CONSOL_REP_BALANCE_PQ | On Line |