Cube Dimension - Project Cost Revenue Element

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.

ATTRIBUTES

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"

USED BY CUBE

Cube Name
PROJECT

ETL Information

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