Data not available in DWH Odata

Article Id: 142425

Status: Published

Updated On: 30-12-2019 14:04

Products:

Clarity PPM SaaS , Clarity PPM SaaS , STARTER PACK-CLARITY PPM , 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 support 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