Model: Group Reporting - Specifications for Dimension Table: STRUCTURE HIEARCHY

On this page you will find the specifications regarding the Model: Group Reporting and Dimension Table: STRUCTURE HIEARCHY.

Attributes

Attribute	Description (where applicable)
AlphaCONL01	Structure Level 1 - Alphabetical sort order
AlphaCONL02	Structure Level 2 - Alphabetical sort order
AlphaCONL03	Structure Level 3 - Alphabetical sort order
AlphaCONL04	Structure Level 4 - Alphabetical sort order
AlphaCONL05	Structure Level 5 - Alphabetical sort order
AlphaCONL06	Structure Level 6 - Alphabetical sort order
AlphaCONL07	Structure Level 7 - Alphabetical sort order
AlphaCONL08	Structure Level 8 - Alphabetical sort order
AlphaCONL09	Structure Level 9 - Alphabetical sort order
AlphaCONL10	Structure Level 10 - Alphabetical sort order
Child ID	Child ID
Description	Description
Node Type	Node Type
Sort Order Latest	Last available sort order applied on all periods
Structure ID	Structure ID
Year Period	Accounting Year and Period

Hierarchies

Hierarchy	Level
Structure Alphabetical Order
	Structure ID
	AlphaCONL01
	AlphaCONL02
	AlphaCONL03
	AlphaCONL04
	AlphaCONL05
	AlphaCONL06
	AlphaCONL07
	AlphaCONL08
	AlphaCONL09
	AlphaCONL10
Structure By Sort Order
	Structure ID
	CONL01
	CONL02
	CONL03
	CONL04
	CONL05
	CONL06
	CONL07
	CONL08
	CONL09
	CONL10

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
STRUCTURE HIEARCHY	DIM_CONSOL_STRUCTURE_BY_PER_GC_TM	DIM_CONSOL_STRUCTURE_BY_PER_GC_BI	CONSOL_STRUCT_BIA	On Line