Fact - Project Forecast Item

This cube fact represents project forecast items information and is based on the IFS Applications fact FACT_PROJ_FORECAST_ITEM

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

USED BY CUBE

Cube Name Product Area
Project Project Based

ETL Information

BI Access View BI Component Recommended Access Type
FACT_PROJ_FORECAST_ITEM_BI PJBFFT On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.034 Load IFSAppl_FACT_PROJ_FORECAST_ITEM_BI.dtsx IFSAppl_FACT_PROJ_FORECAST_ITEM_BI
T - DW 2.2.034 Load Dw_FACT_PROJ_FORECAST_ITEM.dtsx Dw_FACT_PROJ_FORECAST_ITEM
L - DM 3.2.034 Load Dm_FACT_PROJ_FORECAST_ITEM.dtsx Dm_FACT_PROJ_FORECAST_ITEM

SPECIAL INFO

This fact consists of amounts calculated to reporting currency. The data used to find the rates is cut_off_date (representing DIM_CUT_OFF_DATE)