Data not available in DWH Odata

book

Article ID: 142425

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Using Tableau as a reporting tool, Some attributes that added to the status report object not seeing the data in OData, You can see the tables in the DWH Schema report, the attributes are viable in OData but the data that is in there is not. ran all 3 jobs (Load DWH, Load DWH Access, and Refresh DWH) but are still not seeing any data.

Cause

OData v4 is not supported by Tableau; it supports only v2

Environment

Release : 15.6.1

Component : CA PPM SAAS OPERATIONS ODATA

Resolution

OData v4 is not supported by Tableau; it support only v2

 Using the OdataV2 connector and were able to get data.

Additional Information

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-demand/15-6-1/administration/configure-the-data-warehouse-and-advanced-reporting/configure-odata-access-to-the-data-warehouse.html