Cube Dimension - Proj Fcst Conn Rfc

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

ATTRIBUTES

Attribute Hierarchy Description
Connection Type NO  
Forecast Connected Resource Forecast NO Key. Displayed as PROJECT_ID + ' - ' + cast(FORECAST_ID as nvarchar) + ' - ' + FORECAST_VERSION_ID + ' - ' + VERSION_DESCRIPTION
Forecast Connected Resource Forecast Description NO Version Description (VERSION_DESCRIPTION)
Forecast Connected Resource Forecast  Id NO Forecast version id (FORECAST_VERSION_ID )
Forecast Id NO Forecast identity
Project Id NO Project identity

USED BY CUBE

Cube Name
PROJECT

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.127 Load IFSAppl_DIM_PROJ_FCST_CONN_RFC_BI IFSAppl_DIM_PROJ_FCST_CONN_RFC_BI
T - DW 2.1.127 Load Dw_DIM_PROJ_FCST_CONN_RFC Dw_DIM_PROJ_FCST_CONN_RFC
L - DM 3.1.127 Load Dm_DIM_PROJ_FCST_CONN_RFC Dm_DIM_PROJ_FCST_CONN_RFC