Odata pulls from DWH_FIN_PLAN_PER_FACTS_F_V take 5 times longer when DWH settings not just loading plans of record

Products

• Clarity PPM SaaS

Issue/Introduction

Odata pulls from DWH_FIN_PLAN_PER_FACTS_F_V  take 5 times longer when DWH settings not just loading plans of record

 

Environment

Release : 16.1.1

Resolution

It is suggested to only pull delta data as that would be a lot less data and perform much better. 

For example:

https://<reporting_host>.ondemand.ca.com/api/odata/cppmXXXXXXXXpdatasource/DWH_FIN_PLAN_PER_FACTS_F_V?$select=period_key,plan_detail_key&$filter=dw_updated_date ge '2023-03-28T00:00:00Z'