I am not sure of this issue.. and i tried to read the manual(User guide - System Resource Report Pack
For the Windows®, HP-UX, Solaris, and Linux operating systems Software Version: 4.52 HP Performance Insight 5.41 )...
and found this...:
System Resource Report Pack The reports in System Resource will help you anticipate resource issues before they become serious. You will know whether resources are plentiful, limited, or somewhere in between, and you will be able to make useful comparisons. For example, you can look at hourly utilization levels for yesterday, and if something does not look quite right, you can easily compare yesterday’s performance to weekly and monthly trends.
I do not suppose it possible as there is no such report pack which summarized data for weekly or monthly table. You should ask for same. At DB end you may ask you DBA to write the sql procedure to sum and average the data from day table to weekly/monthly table.
____________________________________ Assign Kudo, if found post useful and mark it accepted if solves the issue.
The daily SR CPU data table - SD_SR_CPU has a default retention period of 150 days so you can adjust the time periods in your daily reports to look at daily data going back 150 days (if it exists).
Alternatively you can create trend_sum *.sum files to summarize the daily data to a weekly and monthly level. When the trend_sum is run for the first time, it will automatically create the destination table if it does not already exist.
Therefore based on the existing SD_SR_CPU.sum file you could create a weekly summarization file SW_SR_CPU.sum as: