Model: Group Reporting - Specifications for Dimension Table: FACT NODE BASED ANALYSIS
Attributes
| Attribute |
Description (where applicable) |
| Balance_Version_Key |
Balance Version Code |
| CREDIT_BALANCE |
Credit Balance as YTD value in Node currency |
| CREDIT_BALANCE_GC |
Credit Balance as YTD value in Group currency |
| Company_Key |
Master Company code |
| DEBIT_BALANCE |
Dedit Balance as YTD value in Node currency |
| DEBIT_BALANCE_GC |
Dedit Balance as YTD value in Group currency |
| Dim Account ID |
Account ID |
| Dim Accounting Period ID |
Accounting Period 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 |
Company Code |
| Dim Consol Struct Sub Level ID |
Consolidation Structure Sub Level ID |
| Dim Consol Structure ID |
Consolidation Structure ID |
| Dim Consol Structure Node ID |
Consolidation Structure Node 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 Posting Type ID |
Posting Type ID |
| Dim Inter Company Elim Rule ID |
Intercompany Elimination Rule ID |
| Dim Par Consol Structure ID |
Parallel Structure ID |
| Dim Rep Balance Version ID |
Balance Version ID |
| Dim Reporting Date ID |
Reporting Date |
| Dim Reporting Entity ID |
Reporting Entity ID |
| Dim Reporting Period ID |
Reporting Period ID |
| Equity Elimination |
Equity Elimination |
| ID |
ID |
| Matching ID |
Matching ID |
| NOD_BALANCE |
Balance as YTD value in Node currency |
| NOD_BALANCE_GC |
Balance as YTD value in Group currency |
| NOD_CURR_BALANCE |
Balance as YTD value in currency |
| No Elimination |
No Elimination |
| Profit Elimination |
Profit Elimination |
| Sort_Struct_Sub_Level_Code_Desc |
Sort order and Sub level |
| Structure_Key |
Structure code |
| Tot_Sort_Struct_Node_Code_Desc |
Sort order and Node level |
| Transaction |
Transaction ID |
| Year_Period_Key |
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 NODE BASED ANALYSIS |
FACT_CONSOL_BALANCE_NODEBASED_TM |
FACT_CONSOL_BALANCE_NODEBASED_BI |
FACT_CONSOL_BALANCE |
Data Mart |