CUBE DIMENSION - CANCEL TASK CAUSE

This cube dimension represents Cancel Task Cause and is based on the IFS Applications dimension DIM_CANCEL_TASK_CAUSE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Cancel Task Cause NO Key. Built as CODE+ ' - ' + DESCRIPTION
Cancel Task Cause Code NO Represents the code of the dimension
Cancel Task Cause Desc NO Represents the description of the cause

USED BY CUBE

Cube Name
MAINTENANCE

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_CANCEL_TASK_CAUSE_BI MSCODI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.194 Load IFSAppl_DIM_CANCEL_TASK_CAUSE_BI.dtsx IFSAppl_DIM_CANCEL_TASK_CAUSE_BI
T - DW 2.1.194 Load Dw_DIM_CANCEL_TASK_CAUSE.dtsx Dw_DIM_CANCEL_TASK_CAUSE
L - DM 3.1.194 Load Dm_DIM_CANCEL_TASK_CAUSE.dtsx Dm_DIM_CANCEL_TASK_CAUSE