The Resource management and Project Management reports are coming back as blank after upgraded to 14.4

Document ID : KB000044476
Last Modified Date : 05/06/2018
Show Technical Document Details
Issue:

After upgrade to 14.4, the Resource Management reports and Investment Management reports are generated with blank reports. The reports continues to be blank even after running the required DWH jobs and PPM jobs like Load DWH, Time Slicing, Datamart jobs.
 

Environment:
CA PPM SaaS and CA PPM On Premise
Cause:

To eliminating the unused Time Slice periods in Data Warehouse and enhance the performance, there are new Data Warehouse configuration options introduced from CA PPM 14.4 release. This new configuration will help reduce the number of fact records stored which in turn will improve the processing time for populating the data. These options will have to be enabled for the Resource and Investment management reports to show data if the facts are used.

Resolution:
To enable this Data Warehouse configuration:
1. Login as Admin and Navigate to Administration -->  General Settings --> System Options
2. Scroll down to  'Data Warehouse Options'
 Capture.JPG
3. Please go through the below description of each configuration and enable them as per your system configuration.

Store Weekly Time Increments?
Specifies if you want to look at the data by week. If this option is selected, facts are loaded in weekly increments.

Store Monthly Time Increments?
Specifies if you want to look at the data by months. If this option is selected, facts are loaded in monthly increments.

Store Fiscal Time Increments?
Specifies if you want to look at the data by fiscal time periods. If this option is selected, facts are loaded in fiscal time periods. The fiscal time period is determined by the value set in the Entity for Fiscal Periods field.

One Set of Fiscal Periods?
Specifies if the fiscal time period dates are consistent across the entities.

4. Save the changes and run following jobs in the listed order:
     - Time Slices,
     - Load Data Warehouse (Full Load) opion
     - Load Data Warehouse Access Rights

 
Additional Information:
There is change in Field Names from CA PPM 15.1 release.
For more information, visit Change Impact and Upgrade (SaaS) documentation at https://docops.ca.com/ca-ppm-saas/15-1/en/release-information/change-impact-and-upgrade-saas#ChangeImpactandUpgrade(SaaS)-DataWarehouseUpdatesforRelease15.1