Resource.Details

Purpose

The Common View for Resource Details, excluding dates or measures, acts as a unified and reliable source for data on project resources. It is accessible to different departments and systems across the organisation. This view supports integration with fact tables for reporting and analysis and provides a limited set of dimension attributes.

Use Case

Owner: Data Engineering
Typical Use Case: Supplies content for a Business Opportunity slicer, ensuring a uniform style for Title descriptions.
Style: Dimension, meaning a single row per Resource ID.

Source

QDIM_RESOURCE_AND_PARENT_IAS$

DIM_RESOURCE_OL

Key Parameters

Company
Employee
Person
Resource

Sample Exec

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

Response

 	src.COMPANY,
	src.CODE as EMP_NO,
	src.[PERSON_ID],
    person.PERSON_GROUP as RESOURCE_ID,

Employee

[EMPLOYEE_NAME],

Resource

       res_resource.[DESCRIPTION] AS RESOURCE_DESCRIPTION,
       res_group.[DESCRIPTION] AS RESOURCE_GROUP,
       RESOURCE_CATEGORY AS RESOURCE_GRADE

SQL

BMT-DWH-DEV/Resource_Details.sql