This cube dimension represents project related activities and is based on the IFS Applications dimension DIM_ACTIVITY. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural parents are Project Id and Sub Project Id.
| Attribute | Hierarchy | Description |
| Activity | NO | Key. Built as PROJECT_ID + ' - ' + SUB_PROJECT_ID + ' - ' + ACTIVITY_NO + ' - ' + ACTIVITY_DESCRIPTION |
| Activity Class | NO | The activity class represented by the CLASS_DESCRIPTION |
| Activity Code | NO | The code of the dimension built as ACTIVITY_SEQ (activity sequence number) |
| Activity Descr | NO | Represens the activity description (ACTIVITY_DESCRIPTION) |
| Activity No | NO | Represents the activity number (ACTIVITY_NO) |
| Activity No Description | NO | Represents the activity number description as ACTIVITY_NO + ' - ' + ACTIVITY_DESCRIPTION |
| Activity Responsible | NO | Represents the name of the activity responsible (RESPONSIBLE_NAME) |
| Activity ShortName | NO | Represents the short name of the activity (ACTIVITY_SHORT_NAME) |
| Activity Status | NO | Represents the status of the activity (STATUS) |
| Project Id | NO | Represents the project id that the activit is connected to (PROJECT_ID) |
| Project Subproject Id | NO | Represents a string identity of the parent project and sub project defined as PROJECT_ID + '^' + SUB_PROJECT_ID |
| Sub Project Id | NO | Represents the sub project id that the activity is connected to (SUB_PROJECT_ID) |
| Hierarchy | YES | Hierarchy defined as "Activity Class" -> "Activity" |
| Proj Hierarchy | YES | Hierarchy defined as "Project Id" -> "Sub Project Id" -> "Activity" |
| Cube Name |
| MAINTENENCE |
| PROCUREMENT |
| PROJECT |
| SALES |
| SALES CONTRACT |
| BI Access View | BI Component | Recommended Source Type |
| DIM_ACTIVITY_BI | PROJDI | On Line |
| ETL Step | File Name of SSIS Package | Table Name |
| E - Stage | 1.1.002 Load IFSAppl_DIM_ACTIVITY_BI.dtsx | IFSAppl_DIM_ACTIVITY_BI |
| T - DW | 2.1.002 Load Dw_DIM_ACTIVITY.dtsx | Dw_DIM_ACTIVITY |
| L - DM | 3.1.002 Load Dm_DIM_ACTIVITY.dtsx | Dm_DIM_ACTIVITY |