Resource.Activity

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.Capacity

Source

QFACT_RESOURCE_ANALYSIS_D_IAS$

Key Parameters

Company
Resource
Project

Sample Exec

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

Response

src.COMPANY as COMPANY_ID,
src.RESOURCE_ID as RESOURCE_ID,
src.[PROJECT_ID],

SEQ

[SUB_PROJECT_ID],
[ACTIVITY_ID],
[ACTIVITY_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,
ent_proj.project_item_id,

Dates

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

Measures

cast(PLANNED_HOURS as decimal(10,3)) as PLANNED_HOURS,

Codes

RESOURCE_PARENT_ID = parent_res.item_code,
RESOURCE_DESCRIPTION = parent_res.item_desc,
CATEGORY2_ID =
CASE
WHEN ACTIVITY_ORIGIN like '%absence%' THEN 'ABSENCE'
ELSE ent_proj.[Project Category]
END

SQL

BMT-DWH-DEV/Resource_Activity.sql