Model: Procurement - Specifications for Dimension Table: SUB PROJECT

On this page you will find the specifications regarding the Model: Procurement and Dimension Table: SUB PROJECT.

This model dimension represents sub projects and is based on the IFS Cloud dimension DIM_SUB_PROJECT. All models that refer to this dimension will have the attributes and hierarchies as described below.

Natural parent is project, i.e. each project has its own set of sub projects. A sub project can however have another sub project as a sub project parent.

Attributes

Attribute	Description (where applicable)
Department	The department (DEPARTMENT) referenced by the sub project
Parent Sub Project	Parent Sub Project Id
Project	The project identity that the sub project belongs to. (PROJECT_ID)
Sub Project	Defined as PROJECT_ID + ' - ' +SUB_PROJECT_ID + ' - ' + SUB_PROJECT_DESCRIPTION
Sub Project Description	Defined as SUB_PROJECT_ID + ' - ' + SUB_PROJECT_DESCRIPTION
Sub Project Id	The identity of the sub project (SUB_PROJECT_ID)
Sub Project Id Description	The description of the sub project (SUB_PROJECT_DESCRIPTION)
Sub Project Manager	Name of the sub project manager (MANAGER_NAME)
L1	Level 1 in Sub Project hierarchy structure
L10	Level 10 in Sub Project hierarchy structure
L2	Level 2 in Sub Project hierarchy structure
L3	Level 3 in Sub Project hierarchy structure
L4	Level 4 in Sub Project hierarchy structure
L5	Level 5 in Sub Project hierarchy structure
L6	Level 6 in Sub Project hierarchy structure
L7	Level 7 in Sub Project hierarchy structure
L8	Level 8 in Sub Project hierarchy structure
L9	Level 9 in Sub Project hierarchy structure

Hierarchies

Hierarchy	Level
SubProjectHy
	Project
	L1
	L2
	L3
	L4
	L5
	L6
	L7
	L8
	L9
	L10

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table	BI Access View	Referenced Information Source	Recommended Access Type
SUB PROJECT	DIM_SUB_PROJECT_PQ_BI	DIM_SUB_PROJECT_PQ	On Line