Model: Employee Analysis - Specifications for Dimension Table: ANALYSIS STRUCTURE-ALTERNATIVE

On this page you will find the specifications regarding the Model: Employee Analysis and Dimension Table: ANALYSIS STRUCTURE-ALTERNATIVE.

Attributes

Attribute	Description (where applicable)
Org Code- Alternative	Code of the organization unit
Org Name- Alternative	Name of the organization unit
Structure ID- Alternative	Structure in which the organization is associated with

Hierarchies

Hierarchy	Level
AnalysisStructureAltHy
	L01
	L02
	L03
	L04
	L05
	L06
	L07
	L08
	L09
	L10

USED BY MODEL(S)

Model Name

Employee Analysis

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
ANALYSIS STRUCTURE-ALTERNATIVE	DIM_STRUCT_ORGANIZATION_CODE_ALTERNATIVE_TM	DIM_ORGANIZATION_CODE_BI	DIM_ORGANIZATION_CODE	On Line