Cube Dimension - Condition Code

This cube dimension represents condition codes and is based on the IFS Applications dimension DIM_CONDITION_CODE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Condition Code NO Key. Built as CODE + ' - ' + DESCRIPTION
Condition Code Description NO Represents the DESCRIPTION of a condition code.
Condition Code Value NO Represents the CODE of the dimension, i.e. the condition code.

USED BY CUBE

Cube Name
PROCUREMENT
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_CONDITION_CODE_BI PARTDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.031 Load IFSAppl_DIM_CONDITION_CODE_BI.dtsx IFSAppl_DIM_CONDITION_CODE_BI
T - DW 2.1.031 Load Dw_DIM_CONDITION_CODE.dtsx Dw_DIM_CONDITION_CODE
L - DM 3.1.031 Load Dm_DIM_CONDITION_CODE.dtsx Dm_DIM_CONDITION_CODE