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.