Model: Group Reporting - Specifications for Dimension Table: FACT STRUCTURE BASED ANALYSIS
Attributes
| Attribute |
Description (where applicable) |
| ACC_PERIOD_END |
Accounting Period End Date |
| ACC_PERIOD_FROM |
Accounting Period Start Date |
| Balance Version |
Balance Version Code |
| CREDIT_BALANCE |
Credit balance in node currency |
| CREDIT_BALANCE_GC |
Credit balance in group currency |
| Currency Code |
Currency Code |
| DEBIT_BALANCE |
Dedit balance in node currency |
| DEBIT_BALANCE_GC |
Dedit balance in group currency |
| Dim Account ID |
Account ID |
| Dim Accounting Period ID |
Accounting Period ID |
| Dim Balance Set ID |
Balance Set ID |
| Dim Code B ID |
Code B ID |
| Dim Code C ID |
Code C ID |
| Dim Code D ID |
Code D ID |
| Dim Code E ID |
Code E ID |
| Dim Code F ID |
Code F ID |
| Dim Code G ID |
Code G ID |
| Dim Code H ID |
Code H ID |
| Dim Code I ID |
Code I ID |
| Dim Code J ID |
Code J ID |
| Dim Code N ID |
Code N ID |
| Dim Code O ID |
Code O ID |
| Dim Code P ID |
Code P ID |
| Dim Code Q ID |
Code Q ID |
| Dim Code R ID |
Code R ID |
| Dim Code S ID |
Code S ID |
| Dim Code T ID |
Code T ID |
| Dim Company ID |
Master Company ID |
| Dim Consol Structure By Period ID |
Consolidation Structure Hiearchy ID |
| Dim Consol Structure ID |
Consolidation Structure ID |
| Dim Consol Trans Code Type ID |
Consolidation Transaction Type ID |
| Dim Counter Part One ID |
Counterpart One ID |
| Dim Counter Part Two ID |
Counterpart Two ID |
| Dim Currency Code ID |
Currency Code |
| Dim Grocon Balance Set ID |
Balance Set ID |
| Dim Grocon Posting Type ID |
Posting Type ID |
| Dim Inter Company Elim Rule ID |
Intercompany Elimination Rule ID |
| Dim Node Currency ID |
Node Currency ID |
| Dim Par Consol Structure ID |
Parallel Structure ID |
| Dim Rep Balance Version ID |
Balance Version ID |
| Dim Reporting Entity ID |
Reporting Entity ID |
| Dim Reporting Period ID |
Reporting Period ID |
| Elimination ID |
Elimination ID |
| Equity Elimination |
Equity Elimination |
| Group Currency |
Group Currency Code |
| ID |
ID |
| MVT_CREATED_DT |
Time stamp from data load |
| Matching ID |
Matching ID |
| No Elimination |
No Elimination |
| Node Currency |
Node Currency Code |
| Node Type |
Node Type |
| Period |
Accounting Period |
| Profit Elimination |
Profit Elimination |
| Row ID |
Row ID |
| STR_BALANCE |
Balance in Node currency |
| STR_BALANCE_GC |
Balance in Group currency |
| Year |
Accounting Year |
| Year Period |
Accounting Year and Period |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data source contains a number of
transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View
Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| FACT STRUCTURE BASED ANALYSIS |
FACT_CONSOL_BALANCE_STRUCTBASED_TM |
FACT_CONSOL_BALANCE_STRUCTBASED_BI |
FACT_CONSOL_PER_ADD_DET_BAL |
Data Mart |