Cube Dimension - Shop Order Material

Represents a cube specific dimension based on the fact FACT_SHOP_ORDER. The dimension is based on a fact and there is no corresponding dimension in core.

ATTRIBUTES

Attribute Hierarchy Description
Shop Order NO Key. Built up as OrderNo - ReleaseNo - SeqNo.
SO - Last Loaded NO ETL process date.
SO Cust Order No NO Corresponding customer order number for Shop Order.
SO Demand Code NO Demand Code Description, type of demand.
SO Material State NO Status of material on shop order. Typically Completely Issued, Not Reserved etc.
SO Multilevel Repair NO Is the shop order repair a part of the as built stricture ? True/False.
SO Operation State NO Status of Operation on shop order. Typically Reported, Not Reported.
SO Order Code NO Describing type of Shop order. Assembly, Repair, Manufacturing etc.
SO Order No NO Shop order number.
SO Product State NO Status of products on Shop Order. Received, Not Received etc.
SO State NO Status of shop order. Planned, Finished Closed etc.
SO Used Struc BOM Type NO Bill of Material Structure type used to build the shop order.

USED BY CUBE

Cube Name
MANUFACTURING

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.025 Load IFSAppl_FACT_SHOP_ORDER_BI.dtsx IFSAppl_FACT_SHOP_ORDER_BI
T - DW 2.2.025 Load Dw_FACT_SHOP_ORDER.dtsx Dw_FACT_SHOP_ORDER
L - DM 3.2.025 Load Dm_FACT_SHOP_ORDER.dtsx Dm_FACT_SHOP_ORDER
     

Please refer to FACT_SHOP_ORDER