On this page you will find the specifications regarding the Model: Inventory 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) |
| Project Id | Represents the project id that the activit is connected to (PROJECT_ID) |
| Activity No | Represents the activity number (ACTIVITY_NO) |
| Activity Descr | Represens the activity description (ACTIVITY_DESCRIPTION) |
| Activity ShortName | Represents the short name of the activity (ACTIVITY_SHORT_NAME) |
| Activity Responsible | Represents the name of the activity responsible (RESPONSIBLE_NAME) |
| Activity Status | Represents the status of the activity (STATUS) |
| Sub Project Id | Represents the sub project id that the activity is connected to (SUB_PROJECT_ID) |
| Activity Code | The code of the dimension built as ACTIVITY_SEQ (activity sequence number) |
| 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 |
| SubprojectKey | Represents the sub project key that the activity is connected to (PROJECT_SUBPROJECT_ID_KEY) |
| Hierarchy | Level |
| ProjHy | |
| Sub Project Id | |
| SubprojectKey | |
| 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 |