Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Original Message:
Sent: 02-19-2020 10:55 PM
From: Ram Iyer
Subject: Re: DWH and JS report
Hi Suman
We hit the same issue again on the same environment
Datawarehouse OOTB PMO reports like Resource availability do not return any data for MONTHLY or WEEKLY slice periods
Clarity 15.7 Patch 1
RHEL 7u6 application/jaspersoft servers
Database : Oracle 12.2.0.1.x
Description
We have configured and run our DWH Full Load job successfully. Even checked the health report and see that all our time slices for weekly / monthly etc are set up correctly.
However we do are unable to see any data when running any of the OOTB reports like Resource availability or Capacity related reports.
These reports use the Monthly and weekly slices.
Some further analysis reveals that the DWH_CMN_PERIOD table on the PPM_DWH schema has no records with PERIOD_TYPE_KEY as MONTHLY or WEEKLY.
This is what is causing the reports to return no data.
Please advise on what steps could be taken to fix this.
Thanks Ram
Original Message:
Sent: 12-24-2019 11:07 AM
From: Suman Pramanik
Subject: Re: DWH and JS report
Hi Ram
There is an health report in clarity that tells you if you slices are in order to populate the data, can you check that to see if those are showing as green
------------------------------
Thanks & Regards
Suman Pramanik
Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Broadcom
Original Message:
Sent: 12-20-2019 04:10 AM
From: Ram Iyer
Subject: Re: DWH and JS report
Hi Suman
I am hitting the same issue on 15.7 ( Patch 1).
I am not seeing any records for WEEKLY or MONTHLY in the dwh_cmn_period table in ppm_dwh schema.
We just upgraded a customer from 14.2 to 15.7 ( applied patch 1 on 15.7 ).
We also did a new install Jaspersoft , ran the Load DWH ( full mode ) and the access rights jobs.
Basic OOTB reports like Resource Availability, Capacity vs Demand etc are returning zero records.
Next step of debugging was to take the report query and try running it.
On analyzing further , it was found that the DWH_CMN_PERIODS table in ppm_dwh schema does not have any records with period_type_key MONTHLY or WEEKLY.
This is the reason for the reports to return zero records.
I checked the following
- System Option has all period types enabled
- Time slice dates are fine
Anything else that you can think of?
Environment : UAT
Clarity Version 15.7 Patch 1 with Jaspersoft 7.1
Oracle 12.1.0.2.x with RHEL 7.6 app servers
Subject : OOTB DWH reports are not displaying any data
Description
Upgraded the environment from 14.2 to 15.7
- Initial upgrade from 14.2 to 15.2
- Upgrade from 15.2 to 15.6.1
- Upgrade from 15.6.1 to 15.7
Ran the Load Datawarehouse ( Full Load ) and Load DWH access rights jobs successfully. No errors in the DWH log file
Time Slicing job was run successfully
Time slices are configured correctly
Ran a lot of reports and all of them gave "No matching records" which indicates that the reports are not finding data
Examples are
- Resource Availability
- Capacity vs Demand by Role
Capacity vs Demand by Resource
Original Message:
Sent: 01-27-2017 01:56 AM
From: Suman Pramanik
Subject: Re: DWH and JS report
If you are on 14.3 then these options were not there