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.
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 |
Cube Name |
PROJECT |
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 |