On this page you will find the specifications regarding the Model: Employee Analysis and Dimension Table: ANALYSIS STRUCTURE-ALTERNATIVE.
This model dimension represents an Organization Structure (in HR) based on the IFS Cloud dimension DIM_ORGANIZATION_CODE. The dimension supports drilldown analysis as well as time series analysis. The Organization structure beeing seen as the alternative structure is set up in the Config Utility. In addition a reference date of the structure is given. If no date is given the structure is displayed as it looks today. The dimension is derived from DIM_ORGANIZATION_CODE in the last step of the ETL Flow.
| Attribute | Description (where applicable) |
| Structure ID- Alternative | Structure in which the organization is associated with |
| Org Code- Alternative | Code of the organization unit |
| Org Name- Alternative | Name of the organization unit |
| Hierarchy | Level |
| AnalysisStructureAltHy | |
| L01 | |
| L02 | |
| L03 | |
| L04 | |
| L05 | |
| L06 | |
| L07 | |
| L08 | |
| L09 | |
| L10 |
| Model Name |
| Employee Analysis |
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 |
| ANALYSIS STRUCTURE-ALTERNATIVE | DIM_ORGANIZATION_CODE_BI | DIM_STRUCT_ORG_CODE_ALT_PQ | On Line |