When To Run Job - Refresh Data Warehouse OData Model

Products

• Clarity PPM SaaS

Issue/Introduction

Refresh Data Warehouse OData Model Job

Resolution

(SaaS only) Refresh Data Warehouse OData Model Job

This job exposes OData entities for the objects that are enabled for the Data Warehouse as part of the Load Data Warehouse job. For example, if you enable a new custom object for the Data Warehouse, the job creates a OData model for the object so that you can access the object as an OData entity. Clarity PPM SaaS customers can run this job to refresh the data warehouse OData model for entities added or removed as part of the Load Data Warehouse job. Users can then write queries and run reports against the OData entities using a reporting solution such as Microsoft Power BI.

Restrictions:

1) Before running this job, verify that the data warehouse read-only user has access to the tables and views in the data warehouse schema.
2) The job is incompatible with the Load Data Warehouse job. Run the job after the Load Data Warehouse job executes successfully.