Cube Dimension - Shop Order Operation Hist

Represents a cube specific dimension based on the fact FACT_SHOP_ORDER_OPERATION_HIST, that is built in the ETL step using the view FACT_SHOP_ORDER_OPERATION_HIST as source. The dimension is based on a fact and there is no corresponding dimension in core.

ATTRIBUTES

Attribute Hierarchy Description
Shop Order No NO Shop Order Number.
Shop Order Operation Hist NO Key. Built up as Shop Order - Rel No - Seq No - Operation No
SO Scrap Cause NO Scrap cause.
SO Team Id NO Team identity.
SO Transaction NO Transaction Type.
SO Operation No NO Operation Number

USED BY CUBE

Cube Name
MANUFACTURING

ETL Information

Source Object BI Component Recommended
Source Type
FACT_OPERATION_HISTORY_BI MFGSFT On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.030 Load IFSAppl_FACT_SHOP_ORDER_OPERATION_HIST_BI.dtsx IFSAppl_FACT_SHOP_ORDER_OPERATION_HIST_BI
T - DW 2.2.030 Load Dw_FACT_SHOP_ORDER_OPERATION_HIST.dtsx Dw_FACT_SHOP_ORDER_OPERATION_HIST
L - DM 3.2.030 Load Dm_FACT_SHOP_ORDER_OPERATION_HIST.dtsx Dm_FACT_SHOP_ORDER_OPERATION_HIST
     

Please refer to FACT_SHOP_ORDER_OPERATION_HIST