Cube Dimension - Inspection Code

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

ATTRIBUTES

Attribute Hierarchy Description
Inspection Code YES Key. Built as CODE + ' - ' + DESCRIPTION
Inspection Code Value NO Represents the CODE of the dimension, i.e. the inspection code.
Inspection Code Description NO Represents the Name of a inspection code.
Inspection Type YES Represents the inspection type

USED BY CUBE

Cube Name
PROCUREMENT

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_INSPECTION_CODE_BI INVEDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.034 Load IFSAppl_DIM_INSPECTION_CODE_BI.dtsx IFSAppl_DIM_INSPECTION_CODE
T - DW 2.1.034 Load Dw_DIM_INSPECTION_CODE.dtsx Dw_DIM_INSPECTION_CODE
L - DM 3.1.034 Load Dm_DIM_INSPECTION_CODE.dtsx Dm_DIM_INSPECTION_CODE