Cube Dimension - Project Forecast

This cube dimension represents project forecast information in Project Budgeting and Forecasting based on the IFS Applications dimension DIM_PROJ_FORECAST. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Active Budget NO  
Financially Responsible NO Financially Responsible user identity
Financially Responsible Name NO Financially Responsible user name
Forecast Status NO Status (Db value)
Project Forecast Version NO Key. Displayed as PROJECT_ID + ' - ' + FORECAST_VERSION_ID + ' - ' + VERSION_DESCRIPTION
Project Forecast Version Description NO Forecast version description (VERSION_DESCRIPTION
Project Forecast Version Id NO Forecast version identity (FORECAST_VERSION_ID)
Project Id NO Project identity
Reference Forecast NO Is this a reference forecast? (boolean)

USED BY CUBE

Cube Name
PROJECT

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_PROJ_FORECAST_BI PJBFDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.128 Load IFSAppl_DIM_PROJ_FORECAST_BI IFSAppl_DIM_PROJ_FORECAST_BI
T - DW 2.1.128 Load Dw_DIM_PROJ_FORECAST Dw_DIM_PROJ_FORECAST
L - DM 3.1.128 Load Dm_DIM_PROJ_FORECAST Dm_DIM_PROJ_FORECAST