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.
Cube Name | Product Area |
Maintenance | Maintenance |
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 |
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.