Fact- Shop Order Operation

This cube fact represents shop order operation information and is based on the view FACT_SHOP_ORDER_OPERATION_BI.

Note: Please refer to documentation of each cube to find out about attributes used in referenced cubes.

USED BY CUBE

Cube Name Product Area
Manufacturing Manufacturing

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_SHOP_ORDER_OPERATION_BI SHPOFT On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.026 Load IFSAppl_FACT_SHOP_ORDER_OPERATION_BI.dtsx IFSAppl_FACT_SHOP_ORDER_OPERATION_BI
T - DW 2.2.026 Load Dw_FACT_SHOP_ORDER_OPERATION.dtsx Dw_FACT_SHOP_ORDER_OPERATION
L - DM 3.2.026 Load Dm_FACT_SHOP_ORDER_OPERATION.dtsx Dm_FACT_SHOP_ORDER_OPERATION

 

SPECIAL INFO

This fact supports Reporting Date, i.e. a time dimension that can be used to when doing cross product/module reporting. The date chosen to connect the fact with the dimension is NVL(ACTUAL_FINISH_DATE, PLAN_FINISH_DATE), i.e. if ACTUAL_FINISH_DATE is NULL the PLAN_FINISH_DATE is selected. This date is also used when finding the currency rate for calculation of reporting currency amounts.