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

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

book

Article ID: 251476

calendar_today

Updated On:

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.