Cube Dimension - Org Structure - Current
This cube dimension represents an Organization Structure (in HR) based on the IFS Applications dimension DIM_ORGANIZATION_CODE.
The dimension supports drilldown analysis as well as time series analysis. The
Organization structure beeing seen as the current 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.
ATTRIBUTES
| Attribute |
Hierarchy |
Description |
| Org Code - Current |
NO |
Organization Code |
| Org Struct - Current |
NO |
Key Column, Hidden. Consists of the Organization code. |
| Org Name - Current |
NO |
Organization Name |
| Structure ID - Current |
NO |
Structure ID. |
| Org StructHy - Current |
YES |
Parent - Child hierarchy supporting drilldown. Referring
to PARENT_ORG_CODE in the underlying table. |
USED BY CUBE
ETL Information
| BI Access View |
BI Component |
Recommended
Source Type |
| DIM_ORGANIZATION_CODE |
PERSFT |
On Line |
| ETL Step |
File Name of SSIS Package |
Table Name |
| L - DM |
3.1.096 Load Dm_DIM_STRUCT_ORGANIZATION_CODE_CURR |
Dm_DIM_STRUCT_ORGANIZATION_CURR |