Model: Cash Planning - Specifications for Dimension Table: PROJECT ACTIVITY
Attributes
Attribute | Description (where applicable) |
Activity Code | Represents the Activity Code |
Activity Descr | Represents the Activity Description |
Activity No | Represents the Activity Number |
Activity Responsible | Represents the Activity Responsible |
Activity ShortName | Represents the Activity Short Name |
Activity Status | Represents the Activity Status |
ID | Project activity ID |
SubprojectKey | Sub Project ID |
USED BY MODEL(S)
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 |
PROJECT ACTIVITY | DIM_ACTIVITY_TM | DIM_ACTIVITY_BI | DIM_ACTIVITY | On Line |