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 |