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

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

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 STRUCTURE BASED ANALYSIS	FACT_CONSOL_BALANCE_STRUCTBASED_TM	FACT_CONSOL_BALANCE_STRUCTBASED_BI	FACT_CONSOL_PER_ADD_DET_BAL	Data Mart