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