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