Cube Dimension - Project Forecast Type

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

ATTRIBUTES

Attribute Hierarchy Description
Allow Assignment When Approved NO  
Net Change Budget Control NO  
Periodic Review NO  
Proj Forecast Type NO Key. Displayed as CODE + ' - ' + TYPE_DESCRIPTION
Proj Forecast Type Description NO Project type description (TYPE_DESCRIPTION)
Project Forecast Type Code NO Project type code (CODE)
Set As Budget NO  

USED BY CUBE

Cube Name
PROJECT

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.129 Load IFSAppl_DIM_PROJ_FORECAST_TYPE_BI IFSAppl_DIM_PROJ_FORECAST_TYPE_BI
T - DW 2.1.129 Load Dw_DIM_PROJ_FORECAST_TYPE Dw_DIM_PROJ_FORECAST_TYPE
L - DM 3.1.129 Load Dm_DIM_PROJ_FORECAST_TYPE Dm_DIM_PROJ_FORECAST_TYPE