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.
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) |