Jerin_Sebastian

CA PPM(Clarity) Tuesday Tip: Jaspersoft reports(Advanced reporting) returns with no records after the upgrade to 14.4

Discussion created by Jerin_Sebastian Employee on Jun 28, 2016

The Advanced Reporting reports especially the Resource management and Investment management reports are returning with no records after the upgrade to 14.4.

Even after running the required PPM and DWH jobs to populate the DWH, majority of the reports come back with no records  in it.

The reason for this is -  as part of eliminating the unused Time Slice periods, there has been a new DWH configuration change done to the Advanced Reporting Section in version 14.4. Users will have the ability to decide whether to include the facts records and this will help in improving the processing time to fetch data from DWH.

To enable the v14.4 introduced DWH configuration, navigate to Administration -->  General Settings --> System Options --> Data Warehouse Options.

 

 

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.

Disable Resource Security for Reporting?
Specifies if you want to exclude the resource security for reporting purpose. Select this option if you do not care about resource security for reporting.

Disable Investment Security for Reporting?
Specifies if you want to exclude investment security for reporting purpose. Select this option if you do not care about investment security for reporting.

Once the required boxes are checked, save the changes and run the Load DWH job.

 

For more information, check http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1676265.aspx

 

Thanks,

Jerin

Outcomes