CA PPM: Getting Jaspersoft Advanced Reporting to work

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

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.



The tables in the Data Warehouse are not being updated.


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