CUBE DIMENSION - PLANNER

This cube dimension represents planners (F1 users being a planner) and is based on the IFS Applications dimension DIM_PLANNER. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Planner NO Key. Built as CODE + ' - ' + NAME
Planner Code NO The CODE of the dimension, i.e. planner identity
Planner Name NO The NAME of the planner

USED BY CUBE

Cube Name
MANUFACTURING

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.103 Load IFSAppl_DIM_PLANNER_BI.dtsx IFSAppl_DIM_PLANNER_BI.
T - DW 2.1.103 Load DW_DIM_PLANNER.dtsx Dw_DIM_PLANNER
L - DM 3.1.103 Load DM_DIM_PLANNER.dts Dm_DIM_PLANNER