On this page you will find the specifications regarding the Model: Production Performance and Dimension Table: PROJECT.
This model dimension represents projects and is based on the IFS Cloud dimension DIM_PROJECT. All models that refer to this dimension will have the attributes and hierarchies as described below.
Attribute | Description (where applicable) |
Project Id | The project identity (same as CODE) |
Project Name | The name of the project (NAME) |
Project Description | The descriton of the project (DESCRIPTION) |
Project Manager | The name of the project manager (MANAGER_NAME) |
Project Status | The status of the project (STATUS) |
Project Customer Responsible | The name of the customer responsible (CUSTOMER_RESPONSIBLE_NAME) |
Category 1 Id | Project Category 1 Code |
Category 2 Id | Project Category 2 Code |
Multi Currency Budgeting | TRUE/FALSE indicator for Multi Currency Budgeting |
Project Currency Code | The project currency code (PROJECT_CURRENCY_CODE) |
Plan Start | Represents the planned start date for the project |
Plan Finish | Represents the planned finish date for the project |
Actual Start | Represents the date the project was actually started |
Actual Finish | Represents the date the project was actually finished |
Project | Built as PROJECT_ID + ' - ' + NAME (i.e. project id and its name) |
Project Name - Id | Built as NAME + ' - ' + PROJECT_ID |
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 |
PROJECT | DIM_PROJECT_BI | DIM_PROJECT | On Line |