Cube Dimension - Resource Group

This cube dimension represents resource group information in Project based on the IFS Applications dimension DIM_RESOURCE_GROUP. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Calendar Id NO Calendar identity
Company Id NO Company
Cost Element NO Cost element identity
Resource Category NO Resource category
Resource Group NO Key. Displayed as COMPANY + ' - ' + CODE + ' - ' + DESCRIPTION
Resource Group Code NO Resource group (CODE)
Resource Group Description NO Resource group description
ResourceCategoryHy YES Hierarchy defined as Resource Category -> Resource Group

USED BY CUBE

Cube Name
PROJECT

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.124 Load IFSAppl_DIM_RESOURCE_GROUP_BI IFSAppl_DIM_RESOURCE_GROUP_BI
T - DW 2.1.124 Load Dw_DIM_RESOURCE_GROUP Dw_DIM_RESOURCE_GROUP
L - DM 3.1.124 Load Dm_DIM_RESOURCE_GROUP Dm_DIM_RESOURCE_GROUP