On this page you will find the specifications regarding the Model: Production Performance and Dimension Table: WORK CENTER.
This model dimension represents work centers and is based on the IFS Cloud view WORK_CENTER. There is no core dimension that supports this information. All models that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is contract, i.e. a contract has work centers.
| Attribute | Description (where applicable) |
| Department No | Department description based on CONTRACT and DEPARTMENT_NO |
| Site No | |
| Work Center | Built as WORK_CENTER_NO + ' - ' + DESCRIPTION |
| Work Center Description | Description of the work center (DESCRIPTION) |
| Work Center No | Work center number (WORK_CENTER_NO) |
| Hierarchy | Level |
| WorkCenterHy | |
| Site No | |
| Work Center |
| Model Name |
| Production Performance |
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 |
| WORK CENTER | DIM_WORK_CENTER_TM | DIM_WORK_CENTER_BI | DIM_WORK_CENTER | On Line |