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 |