On this page you will find the specifications regarding the Model: Procurement and Dimension Table: ACTIVITY.
This model dimension represents project related activities and is based on the IFS Cloud dimension DIM_ACTIVITY. All models that refer to this dimension will have the attributes and hierarchies as described below.
Natural parents are Project Id and Sub Project Id.
| Attribute | Description (where applicable) |
| Activity Code | The code of the dimension built as ACTIVITY_SEQ (activity sequence number) |
| Activity Status | Represents the status of the activity (STATUS) |
| Project Id | Represents the project id that the activit is connected to (PROJECT_ID) |
| Activity No | Represents the activity number (ACTIVITY_NO) |
| Sub Project Id | Represents the sub project id that the activity is connected to (SUB_PROJECT_ID) |
| Activity Responsible | Represents the name of the activity responsible (RESPONSIBLE_NAME) |
| Activity ShortName | Represents the short name of the activity (ACTIVITY_SHORT_NAME) |
| Activity Descr | Represens the activity description (ACTIVITY_DESCRIPTION) |
| Activity | Built as PROJECT_ID + ' - ' + SUB_PROJECT_ID + ' - ' + ACTIVITY_NO + ' - ' + ACTIVITY_DESCRIPTION |
| Activity No Description | Represents the activity number description as ACTIVITY_NO + ' - ' + ACTIVITY_DESCRIPTION |
| Project Subproject Id | Represents a string identity of the parent project and sub project defined as PROJECT_ID + '^' + SUB_PROJECT_ID |
| Hierarchy | Level |
| ProjHy | |
| Project Id | |
| Sub Project Id | |
| Activity |
| Model Name |
| CRM |
| Inventory |
| Production Performance |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| ACTIVITY | DIM_ACTIVITY_BI | DIM_ACTIVITY | On Line |