This cube fact represents sales contract item and is based on the IFS Applcations fact FACT_SALES_CONTRACT_ITEM.
Note: Please refer to documentation of each cube to find out about attributes used in referenced cubes.
| Cube Name | Product Area |
| Sales Contract | Sales Contract |
| BI Access View | BI Component | Recommended Source Type |
| FACT_SALES_CONTR_ITEM_BI_OPT | CONMFT | On Line |
| ETL Step | File Name of SSIS Package | Table Name |
| E - Stage | 1.2.015 Load IFSAppl_FACT_SALES_CONTR_ITEM_BI_OPT.dtsx | IFSAppl_FACT_SALES_CONTR_ITEM_BI_OPT |
| T - DW | 2.2.015 Load Dw_FACT_SALES_CONTR_ITEM.dtsx | Dw_FACT_SALES_CONTR_ITEM |
| L - DM | 3.2.015 Load Dm_FACT_SALES_CONTR_ITEM.dtsx | Dm_FACT_SALES_CONTR_ITEM |
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 DIM_CONTRACT_ITEM_DATE_ID, i.e. ITEM_DATE. This date is also used when finding the currency rate for calculation of reporting currency amounts.