Which table contains OBS Level details of any resource i.e. from level 1 to level 10?
Release : 16.0.1
Component : Clarity Resource Management
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
There is also a DWH table to show the OBS Levels for Investments.
That table is DWH_INV_OBS_MAPPING