Cube Dimension - Job

This cube represents the human resouces dimension job and is based on the IFS Applications dimension DIM_JOB_DETAILS_JOB.

ATTRIBUTES

Attribute Hierarchy Description
Company NO Natural parent.
Job NO CODE +' - '+ JOB_TITLE as CODE_TITLE.
Job Code NO Refered as Code in dimension.
Job Grade NO  
Job Title NO  

USED BY CUBE

Cube Name
HUMAN RESOURCES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_JOB_DETAILS_JOB_BI PERSDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.093 Load IFSAppl_DIM_JOB_DETAILS_BI.dtsx IFSAppl_DIM_JOB_DETAILS_BI
T - DW 2.1.093 Load Dw_DIM_JOB_DETAILS.dtsx Dw_DIM_JOB_DETAILS
L - DM 3.1.093 Load Dm_DIM_JOB_DETAILS.dtsx Dm_DIM_JOB_DETAILS