Cube Dimension - Org Structure - Alternative

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.

ATTRIBUTES

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.

USED BY CUBE

Cube Name
HUMAN RESOURCES

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_ALT Dm_DIM_STRUCT_ORGANIZATION_ALT