CA PPM: Getting Jaspersoft Advanced Reporting to work

Document ID : KB000004462
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

One or more of the following symptoms are experienced:
-Stock reports are not showing updated data.
-An "invalid identifier" error indicating a synchronization issue between the PPM and DWH schema.
 

 

Cause:

The tables in the Data Warehouse are not being updated.

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.

 

 

Additional Information:

Refer to the following post for job scheduling recommendations with the addition of the new jobs in 14.2
https://communities.ca.com/thread/241698250