CUBE DIMENSION - PRODUCTION LINE

This cube dimension describes Production Line and is based on the IFS Applications dimension DIM_PRODUCTION_LINE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Production Line NO Key. The attribute is built up as Site Code - Code - Description.
Production Line - Last Loaded NO ETL process date
Production Line Code NO Code of production line.
Production Line Descr NO Description of production line.
Production Line Site NO Site code of production line.
ProdLineHy YES Hierarchy defined as "Production Line Site" -> "Production Line"

USED BY CUBE

Cube Name
MANUFACTURING

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_PRODUCTION_LINE_BI MFGSDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.111 Load IFSAppl_DIM_PRODUCTION_LINE_BI.dtsx IFSAppl_DIM_PRODUCTION_LINE_BI
T - DW 2.1.111 Load Dw_DIM_PRODUCTION_LINE.dtsx Dw_DIM_PRODUCTION_LINE
L - DM 3.1.111 Load Dm_DIM_PRODUCTION_LINE.dtsx Dm_DIM_PRODUCTION_LINE