CA PPM OData not showing data

book

Article ID: 145006

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Issue accessing a specific table through OData connection using PowerBI/Tableau/Excel.

Environment

Release : 15.6.1, 15.7, 15.7.1

Component : CA PPM SAAS OPERATIONS ODATA

Resolution

If running any Custom Process / Job that updating the tables (Please run the job before the DWH Load Job and Odata Refresh Job).

As new tables and columns are added in the data warehouse, the OData endpoints can get outdated. Run or schedule the following jobs in the listed order to update the OData endpoints with latest changes from the data warehouse. This procedure ensures that your reports reflect the most current data available.