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