ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

DWH_CMN_PERIOD /timestamp issue causes Jaspersoft Reports to not return data

book

Article ID: 143193

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Missing or incorrect data in Data Warehouse reports.

 

There are four views in DWH that hold the time period information, deriving the data from DWH_CMN_PERIOD table:
1. DWH_CMN_PERIOD_D_V
2. DWH_CMN_PERIOD_M_V
3. DWH_CMN_PERIOD_F_V
4. DWH_CMN_PERIOD_W_V

Although the DWH_CMN_PERIOD and RPT_CALENDAR table is being populated, one or all of the tables above are not.

 

Cause

This is due to a mismatch in the server date time stamp between the Application and Database server.
The time stamp will need to match and sync down to the second in order for the data to populate into the views.

The Server team will need to be engaged to synchronize the time between the two servers.

Environment

All Clarity Versions

Resolution

The following views derive data from the DWH_CMN_PERIOD table in the DWH database.

nd the range of their data is determined by the Time Slices defined in the PPM Schema. Following is a table, mapping each view to its corresponding Time Slice type.

DWH_CMN_PERIOD_D_V Fiscal
DWH_CMN_PERIOD_M_V Monthly
DWH_CMN_PERIOD_F_V Fiscal
DWH_CMN_PERIOD_W_V Weekly