On this page you will find the specifications regarding the Model: Cash Planning 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 | Built as PROJECT_ID + ' - ' + NAME (i.e. project id and its name) |
| Project Name | The name of the project (NAME) |
| Project Status | The status of the project (STATUS) |
| Plan Start | Represents the planned start date for the project |
| Project Code | Project code |
| Project Description | The description of the project (DESCRIPTION) |
| Plan Finish | Represents the planned finish date for the project |
| Actual Start | Represents the date the project was actually started |
| Category 1 Code | Project Category 1 Code |
| Category 2 Code | Project Category 2 Code |
| Project Manager | The name of the project manager (MANAGER_NAME) |
| Actual Finish | Represents the date the project was actually finished |
| Project Currency Code | The project currency code (PROJECT_CURRENCY_CODE) |
| Multi Currency Budgeting | TRUE/FALSE indicator for Multi Currency Budgeting |
| Project Customer Responsible | The name of the customer responsible (CUSTOMER_RESPONSIBLE_NAME) |
| 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 |