oData Feed Issue - financial plans showing both plans of record and non-plans of record

Products

• Clarity PPM SaaS

Issue/Introduction

You have changed the System Options in Test environment to load only Plan of Records into DWH and we have verified in DWH that only the Plan of records are being loaded now.

The reporting team is saying there is an issue with their data containing both plans of record and non-plans of record cost plans

How can we validate the data being returned from ODATA

Environment

Release : 16.0.3

Component : PPMDWH, ODATA

Resolution

You may use a $filter in your ODATA call to validate the data

 

You can also filter by the investment_id or other column

$filter=investment_key eq 5110604

 

You can also use $select=column_name1,column_name2 to fetch only the columns you need.