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.
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 |
Cube Name |
MANUFACTURING |
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