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
This is caused by defect id: DE60921
Release : 15.8.1, 15.9.1, 15.9.2
Component : CLARITY JASPERSOFT
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.
In the Data Warehouse database, the fact table - DWH_FIN_PLAN_PERIOD_FACTS is not getting populated correctly
Refer to the following article: