This cube dimension represents project cost revenue element and is based on the IFS Applications dimension DIM_COST_REV_ELEMENT. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is company, i.e. each company has its own set of project cost revenue elements.
Attribute | Hierarchy | Description |
Company | NO | Parent key (COMPANY) |
Project Cost Revenue Element | NO | Key. Defined as CODE + ' - ' + ELEMENT_DESCRIPTION |
Project Cost Revenue Element Blocked True-False | NO | Blocked for use flag (BLOCKED_FOR_USE) |
Project Cost Revenue Element Code | NO | The dimension CODE, i.e. cost revenue element |
Project Cost Revenue Element Description | NO | The description (ELEMENT_DESCRIPTION) of the cost revenue element |
Project Cost Revenue Element Type | NO | The client value of the cost revenue element type (ELEMENT_TYPE) |
Hierarchy | YES | Defined as "Company" -> "Project Cost Element" |
Type Element Hierarchy | YES | Defined as "Project Cost Element Type" -> "Project Cost Element" |
Cube Name |
PROJECT |
BI Access View | BI Component | Recommended Source Type |
DIM_COST_REV_ELEMENT_BI | PROJDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.084 Load IFSAppl_DIM_COST_REV_ELEMENT_BI.dtsx | IFSAppl_DIM_COST_REV_ELEMENT_BI |
T - DW | 2.1.084 Load Dw_DIM_COST_REV_ELEMENT.dtsx | Dw_DIM_COST_REV_ELEMENT |
L - DM | 3.1.084 Load Dm_DIM_COST_REV_ELEMENT.dtsx | Dm_DIM_COST_REV_ELEMENT |