Jaspersoft Reports do not show Planned Cost data correctly

book

Article ID: 222005

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Jaspersoft reports and Ad Hoc view are only displaying partial data for Cost Plans

In both Clarity Classic and Modern UX the Planned Cost data displays correctly for example a value of 30,000 is displayed.

However when the Load Data Warehouse job run, only partial data gets displayed in the Jaspersoft reports and Ad Hoc views although all Fiscal slices are correctly configured 

Cause

This is caused by defect id: DE60921

Environment

Release : 15.8.1, 15.9.1, 15.9.2

Component : CLARITY JASPERSOFT

Resolution

The defect is under review by Engineering

As a workaround, untick the checkbox for "Consistent Fiscal Periods across Entities" in the Clarity => Administration => General Settings => System Options page.

Additional Information

In the Data Warehouse database, the fact table - DWH_FIN_PLAN_PERIOD_FACTS is not getting populated correctly

Refer to the following article:

Data Warehouse - Incorrect data gets loaded to dwh_fin_plan_period_facts