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.
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" |
Cube Name |
MAINTENENCE |
MANUFACTURING |
PROJECT |
SALES CONTRACT |
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 |