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 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 |
Hierarchy |
Description |
Org Code - Alternative |
NO |
Organization Code |
Org Struct - Alternative |
NO |
Key Column, Hidden. Consists of the Organization code. |
Org Name - Alternative |
NO |
Organization Name |
Structure ID - Alternative |
NO |
Structure ID. |
Org StructHy - Alternative |
YES |
Parent - Child hierarchy supporting drilldown. Referring
to PARENT_ORG_CODE in the underlying table. |