Yearly report resolution change from 1-Day Resolution to 1-hour Resolution

Document ID : KB000098272
Last Modified Date : 29/05/2018
Show Technical Document Details
Introduction:
How to generate a yearly report resolution from 1-Day Resolution to 1-hour Resolution when existing resolution of yearly report is daily condition and expect to select the "Resolution" as "1 Hour" in last 12 months report.
The yearly report cannot indicate the trend on utilization growth. The daily interval average out a lot value.
  
Question:
How to generate a yearly report resolution from 1-Day Resolution to 1-hour Resolution. Existing resolution of yearly report is daily condition and expect to select the "Resolution" as "1 Hour" in last 12 months report..
Environment:
Product Release = CA PM 3.5
Answer:
If it is increased the hourly retention then it will take another 300+ days to build up 365 days of hourly data.

It  doesn't recalculate hourly data on change of the setting. It will require more disk space on vertica to hold that data and should figure that in the overall footprint of the vertica data area. As far as using the data, it would require enabling the High Resolution role right on the user's role that wish to use it.

It means anyone with that role right will be able to read the rate table for up to 30 days, and hourly for up to 365 days.
That's a lot of data to churn through for a report, in terms of DR memory and CPU.
The reports will take some time to run, so you will need to make sure their DR nodes are spec'd higher and might need to increase the RIB timeout depending on how long it's taking to run reports using 365 days of hourly data.

In order to modify the high resolution Report Resolution numbers in the admin UI, you need to insert a value into netqosportal general table.

REPLACE INTO general values ( 'ReportResolutionSettable', 'true' ); Then you can goto Administration -> System Settings -> Report Resolution. Enter 365 for hourly when using high resolution role right, and Save.