Model: Employee Analysis - Specifications for Dimension Table: POSITION
Attributes
Attribute |
Description (where applicable) |
Company | Company in which the Position is defined |
Position | The name/title of the position |
Position Code | The identifier (ID) of a position created for the company |
Position Code Title | The name/title of the position |
Position Title | The name/title of the position |
Hierarchy |
Level |
PositionHy | |
| Company |
| Position |
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 |
POSITION | DIM_POSITION_TM | DIM_POSITION_BI | DIM_POSITION | On Line |