Cube Dimension - Project

This cube dimension represents projects and is based on the IFS Applications dimension DIM_PROJECT. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Project NO Key. Built as PROJECT_ID + ' - ' + NAME (i.e. project id and its name)
Project Currency Code NO The project currency code (PROJECT_CURRENCY_CODE)
Project Customer Responsible NO The name of the customer responsible (CUSTOMER_RESPONSIBLE_NAME)
Project Description NO The descriton of the project (DESCRIPTION)
Project Id NO The project identity (same as CODE)
Project Id - Name NO Built as PROJECT_ID +  ' - ' + NAME
Project Manager NO The name of the project manager (MANAGER_NAME)
Project Name NO The name of the project (NAME)
Project Name - Id NO Built as NAME + ' - ' + PROJECT_ID
Project Status NO The status of the project (STATUS)

USED BY CUBE

Cube Name
MAINTENENCE
PROCUREMENT
PROJECT
SALES
SALES CONTRACT

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_PROJECT_BI PROJDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.018 Load IFSAppl_DIM_PROJECT_BI.dtsx IFSAppl_DIM_PROJECT_BI
T - DW 2.1.018 Load Dw_DIM_PROJECT.dtsx Dw_DIM_PROJECT
L - DM 3.1.018 Load Dm_DIM_PROJECT.dtsx Dm_DIM_PROJECT