Cube Dimension - Sub Project

This cube dimension represents sub projects and is based on the IFS Applications dimension DIM_SUB_PROJECT. All cubes that refers 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 Hierarchy Description
Department NO The department (DEPARTMENT) referenced by the sub project
Parent Sub  Project NO The parent sub project defined as PROJECT_ID + '^' + SUB_PROJECT_ID
Project NO The project identity that the sub project belongs to. (PROJECT_ID)
Sub Project NO Key.Defined as SUB_PROJECT_ID + ' - ' + SUB_PROJECT_DESCRIPTION
Sub Project Description NO The description of the sub project (SUB_PROJECT_DESCRIPTION)
Sub Project Hierarchy NO Parent sub project defined by the technical identity of the parent sub project.
Sub Project Id NO The identity of the sub project (SUB_PROJECT_ID)
Sub Project Manager NO Name of the sub project manager (MANAGER_NAME)
Hierarchy YES Hierachy defined as "Project" -> "Sub Project"

USED BY CUBE

Cube Name
MAINTENENCE
MANUFACTURING
PROJECT
SALES CONTRACT

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_SUB_PROJECT_BI PROJDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.037 Load IFSAppl_DIM_SUB_PROJECT_BI.dtsx IFSAppl_DIM_SUB_PROJECT_BI
T - DW 2.1.037 Load Dw_DIM_SUB_PROJECT.dtsx Dw_DIM_SUB_PROJECT
L - DM 3.1.037 Load Dm_DIM_SUB_PROJECT.dtsx Dm_DIM_SUB_PROJECT