Fact- Wo Task Actuals Sales

This cube fact represents actuals in Work Order and is based on the IFS Applcations fact FACT_WO_TASK_ACTUALS_SALES.

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

USED BY CUBE

Cube Name Product Area
Maintenance Maintenance

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_WO_TASK_ACTUALS_SALES_BI WOFT Data Mart

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.006 Load IFSAppl_FACT_WO_TASK_ACTUALS_SALES_BI.dtsx IFSAppl_FACT_WO_TASK_ACTUALS_SALES_BI
T - DW 2.2.006 Load Dw_FACT_WO_TASK_ACTUALS_SALES.dtsx Dw_FACT_WO_TASK_ACTUALS_SALES
L - DM 3.2.006 Load Dm_FACT_WO_TASK_ACTUALS_SALES.dtsx Dm_FACT_WO_TASK_ACTUALS_SALES

 

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 verification date (VER_DATE) of a work order actuals transaction. This date is also used when finding the currency rate for calculation of reporting currency amounts.