Cube Dimension - Proj Fcst Conn Cco

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

ATTRIBUTES

Attribute Hierarchy Description
Change Order State NO  
Connection Type NO  
Forecast Connected Change Order NO Key. Displayed as PROJECT_ID + ' - ' + cast(FORECAST_ID as nvarchar) + ' - ' + CHANGE_OBJECT_ID + ' - ' + CHANGE_OBJECT_NAME
Forecast Connected Change Order Code NO Change Object identity (CHANGE_OBJECT_ID)
Forecast Connected Change Order Name NO Change Object name (CHANGE_OBJECT_NAME)
Forecast Id NO Forecast identity
Project Id NO Project identity
Sales Contract No NO  
Sub Contract No NO  

USED BY CUBE

Cube Name
PROJECT

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.126 Load IFSAppl_DIM_PROJ_FCST_CONN_CCO_BI IFSAppl_DIM_PROJ_FCST_CONN_CCO_BI
T - DW 2.1.126 Load Dw_DIM_PROJ_FCST_CONN_CCO Dw_DIM_PROJ_FCST_CONN_CCO
L - DM 3.1.126 Load Dm_DIM_PROJ_FCST_CONN_CCO Dm_DIM_PROJ_FCST_CONN_CCO