search cancel

Is it possible to have 2 different OBS types appear on one Ad Hoc report without duplicating the records?


Article ID: 129171


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


We use multiple OBS per project (object) and Project object Domain, creating an Ad Hoc View/Report.
We want both OBS Type - Department - OBS Level 3 and OBS Type - Cost OBS - OBS Level 7 to show as a field in the View without duplication of records. Is this possible?


Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment


To display OBS in the Ad Hoc View/Report you need to always add OBS Unit and OBS Type fields.
Unfortunately there will always be 2 rows per project.
So we suggest the following possibilities:
1. Create a Studio Report with your own query
2. Create two Ad Hoc reports, and enter the OBS separately in each one of them (then work with 2 separate reports)
3. Custom field that has the OBS information for both OBS - add it to Ad Hoc
This is functionality limitation regarding OBS and Ad Hoc Views/Reports