Getting Jaspersoft Advanced Reporting to work in Clarity PPM

book

Article ID: 4462

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

One or more of the following symptoms are experienced:

  • Stock reports are not showing updated data 
  • No data is displayed in the report (report is blank)
  • An "invalid identifier" error indicating a synchronization issue between the PPM and DWH schema.
  • This may impact custom and/or out of the box reports
     

 

Cause

The tables in the Data Warehouse are not being updated.

Environment

Release: All Supported Releases
Component: PPMJSP, ODJSP

Resolution

To populate the Data Warehouse, run the following jobs:


1. Time Slicing

2. Update Report Tables

3. Load Data Warehouse (Load DWH) with the 'full' option if 

  • an incremental Load DWH job fails
  • a new language is added in the data warehouse
  • an entity for fiscal time periods is changed in the data warehouse.
  • a data warehouse time slice is changed to include a larger time frame.
  • an attribute is deleted or unselected from the data warehouse via Administration > Studio.
  • an attribute data type is changed.