Fact - Project Forecast Item Period

This cube fact represents project forecast item period information and is based on the IFS Applications fact FACT_PROJ_FRC_ITEM_PER

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_FRC_ITEM_PER_BI PJBFFT On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.035 Load IFSAppl_FACT_PROJ_FRC_ITEM_PER_BI.dtsx IFSAppl_FACT_PROJ_FRC_ITEM_PER_BI
T - DW 2.2.035 Load Dw_FACT_PROJ_FRC_ITEM_PER.dtsx Dw_FACT_PROJ_FRC_ITEM_PER
L - DM 3.2.035 Load Dm_FACT_PROJ_FRC_ITEM_PER.dtsx Dm_FACT_PROJ_FRC_ITEM_PER

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)