Resource.Capacity

Purpose

For the calculation of Resource Utilisation

Use Case

Owner: Martyn Cole
Typical Use Case: Project Reporting Portal
Style: Fact

Code & Source related to Resource.Activity

Source

QFACT_RESOURCE_ANALYSIS_D_IAS$

Key Parameters

Company
Resource

Sample Exec

EXEC get.myView @dataMart = 'Resource', @viewName = 'Capacity', @token = '<myToken>', @version = '<202404>'

Response

src.COMPANY as COMPANY_ID,
src.RESOURCE_ID as RESOURCE_ID,

SEQ

RESOURCE_SEQ,
RESOURCE_TYPE,
ACTIVITY_ORIGIN as REPORT_GROUP,

Entity

ent_res.resource_id as resource_item_id,
ent_emp.employee_id as employee_item_id,

Dates

convert(date,[LOAD_DATE],23) as [LOAD_DATE],

Measures

cast(CAPACITY_HOURS as decimal(10,3)) as CAPACITY_HOURS,
cast(ADJUSTED_HOURS as decimal(10,3)) as ADJUSTED_HOURS,
cast(UTILIZATION_HOURS as decimal(10,3)) as UTILIZATION_HOURS,

Codes

CATEGORY2_ID = 'CAPACITY'
RESOURCE_PARENT_ID = parent_res.item_code,
RESOURCE_DESCRIPTION = parent_res.item_desc,

SQL

BMT-DWH-DEV/Resource_Capacity.sql