Model 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.

Attributes

Attribute Description (where applicable)
ActivityBuilt as PROJECT_ID + ' - ' + SUB_PROJECT_ID + ' - ' + ACTIVITY_NO + ' - ' + ACTIVITY_DESCRIPTION
Activity CodeThe code of the dimension built as ACTIVITY_SEQ (activity sequence number)
Activity DescrRepresens the activity description (ACTIVITY_DESCRIPTION)
Activity NoRepresents the activity number (ACTIVITY_NO)
Activity No DescriptionRepresents the activity number description as ACTIVITY_NO + ' - ' + ACTIVITY_DESCRIPTION
Activity ResponsibleRepresents the name of the activity responsible (RESPONSIBLE_NAME)
Activity ShortNameRepresents the short name of the activity (ACTIVITY_SHORT_NAME)
Activity StatusRepresents the status of the activity (STATUS)
Project IdRepresents the project id that the activit is connected to (PROJECT_ID)
Project Subproject IdRepresents a string identity of the parent project and sub project defined as PROJECT_ID + '^' + SUB_PROJECT_ID
Sub Project IdRepresents the sub project id that the activity is connected to (SUB_PROJECT_ID)
SubprojectKey

Hierarchies

Hierarchy Level
ActivityHy
Activity Code
Activity
ProjHy
Project Id
Sub Project Id
Activity

USED BY MODEL(S)

Model Name
Crm
Inventory
Maintenance
Procurement
Production Performance
Project
Sales

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
ACTIVITYDIM_ACTIVITY_TMDIM_ACTIVITY_BIDIM_ACTIVITYOn Line