search cancel

CA PPM Power BI OData Report does not match Jasper soft reporting

book

Article ID: 190252

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

.I am seeing discrepancies in reporting with Power BI OData and Jasper soft reports.

When compare Power-bi  Odata and information does not match for the same resource and month.  It will be way off,  checked the logic in the power bi script and it looks good, and has historically worked for the last year.

 

Environment

Release : 15.7

Component : CA PPM SAAS APPLICATION

Resolution

Project was ended, but not removed from the slices

A) Re-an the slices

- (Project Removed)

B) Full Load of DWH

C) DWH Access Rights Job

Tested the Power BI Report with corrected data