Fact- Customer Order Line

This cube fact represents customer order lines and is based on the IFS Applcations fact FACT_CUSTOMER_ORDER_LINE

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

USED BY CUBE

Cube Name Product Area
Sales Supply Chain

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_CUSTOMER_ORDER_LINE_BI ORDEFT On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.001 Load IFSAppl_FACT_CUSTOMER_ORDER_LINE_BI.dtsx IFSAppl_FACT_CUSTOMER_ORDER_LINE_BI
T - DW 2.2.001 Load Dw_FACT_CUSTOMER_ORDER_LINE.dtsx Dw_FACT_CUSTOMER_ORDER_LINE
L - DM 3.2.001 Load Dm_FACT_CUSTOMER_ORDER_LINE.dtsx Dm_FACT_CUSTOMER_ORDER_LINE

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 the reporting date represented by the following: if REAL_SHIP_DATE is NULL then use DATE_ENTERED, else use REAL_SHIP_DATE. This date is also used when finding the currency rate for calculation of reporting currency amounts.