Model: Group Reporting - Specifications for Dimension Table: FACT NODE BASED ANALYSIS

On this page you will find the specifications regarding the Model: Group Reporting and 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)

Model Name

Group Reporting

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