Fact - Project Forecast Snapshot Summary

This cube fact represents project forecast snapshot summary information and is based on the IFS Applications fact FACT_PROJ_FRC_SNAP_SUM

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.036 Load IFSAppl_FACT_PROJ_FRC_SNAP_SUM_BI.dtsx IFSAppl_FACT_PROJ_FRC_SNAP_SUM_BI
T - DW 2.2.036 Load Dw_FACT_PROJ_FRC_SNAP_SUM.dtsx Dw_FACT_PROJ_FRC_SNAP_SUM
L - DM 3.2.036 Load Dm_FACT_PROJ_FRC_SNAP_SUM.dtsx Dm_FACT_PROJ_FRC_SNAP_SUM

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)