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 Hidden Not Used |
| Company Id | NO | The company code. (COMPANY) Hidden Not Used |
| Project Program | NO | Key. 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 Hidden |
| Project Program Descr | NO | The project program description (PROGRAM_DESCRIPTION) |
| Cube Name |
| MAINTENENCE |
| PROJECT |
| RISK MANAGEMENT |
| SALES CONTRACT |
| BI Access View | BI Component | Recommended Source Type |
| DIM_PROJECT_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 |