search cancel

Finding the OBS Level details of Resource

book

Article ID: 243007

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Which table contains OBS Level details of any resource i.e. from level 1 to level 10?

 

Environment

Release : 16.0.1

Component : Clarity Resource Management

Resolution

The easiest way to get this information is from the Data Warehouse.

There is a table called

dwh_res_obs_mapping

It has all the levels as well as the path.

You can make a report using your query tool connecting to OData or any other way.

Also you can make an ad-hoc report from Advanced Reporting using the Resource Domain.

The OBS Path as well as each OBS level are there.

Here is a simple query from the DWH for your reference:

SELECT DWH_RES_RESOURCE.RESOURCE_NAME,
  dwh_res_obs_mapping.OBS_UNIT,
  dwh_res_obs_mapping.OBS_TYPE_ID,
  dwh_res_obs_mapping.OBS_LEVEL1,
  dwh_res_obs_mapping.OBS_LEVEL2,
  dwh_res_obs_mapping.OBS_LEVEL3,
  dwh_res_obs_mapping.OBS_LEVEL5,
  dwh_res_obs_mapping.OBS_LEVEL6,
  dwh_res_obs_mapping.OBS_LEVEL7,
  dwh_res_obs_mapping.OBS_LEVEL8,
  dwh_res_obs_mapping.OBS_LEVEL9,
  dwh_res_obs_mapping.OBS_LEVEL10,
  dwh_res_obs_mapping.OBS_PATH
FROM dwh_res_obs_mapping
INNER JOIN DWH_RES_RESOURCE
ON dwh_res_obs_mapping.RESOURCE_KEY = DWH_RES_RESOURCE.RESOURCE_KEY

Additional Information

There is also a DWH table to show the OBS Levels for Investments.

That table is DWH_INV_OBS_MAPPING