OBS field availability in the DWH

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Is it possible to make the OBS fields available in the DWH for reporting, which table can we use?

Environment

Release : Any

Resolution

• The OBS fields and their mapping are available in DWH 
• You can report on OBS from table dwh_inv_obs_mapping.
• You will have to filter your query by obs_type_id
• You can use the investment_key field to do your joins.