This cube dimension represents project program and is based on the IFS Applications dimension DIM_PROJ_PROGRAM. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is company, i.e. each company has its own set of project programs.
| Attribute | Hierarchy | Description |
| Company | NO | Defined as the name of the company |
| Company Id | NO | The company code. (COMPANY) |
| Project Program | NO | Key. Built as COMPANY + ' - ' PROGRAM_ID + ' - ' + PROGRAM_DESCRIPTION |
| Project Program Code | NO | The dimension CODE, i.e. the project program identity |
| Project Program Code - Descr | NO | Built as PROGRAM_ID + ' - ' + PROGRAM_DESCRIPTION |
| Project Program Descr | NO | The project program description (PROGRAM_DESCRIPTION) |
| Hierarchy | YES | Defined as "Company" -> "Project Program Code - Descr" |
| Cube Name |
| MAINTENENCE |
| PROJECT |
| SALES CONTRACT |
| BI Access View | BI Component | Recommended Source Type |
| DIM_PROJ_PROGRAM_BI | PROJDI | On Line |
| ETL Step | File Name of SSIS Package | Table Name |
| E - Stage | 1.1.017 Load IFSAppl_DIM_PROJ_PROGRAM_BI.dtsx | IFSAppl_DIM_PROJ_PROGRAM_BI |
| T - DW | 2.1.017 Load Dw_DIM_PROJ_PROGRAM.dtsx | Dw_DIM_PROJ_PROGRAM |
| L - DM | 3.1.017 Load Dm_DIM_PROJ_PROGRAM.dtsx | Dm_DIM_PROJ_PROGRAM |