Time Granularity

The HDR Reports and Analytics feature in Oracle® Session Delivery Management Cloud (Oracle SDM Cloud) bases all time measurements on Coordinated Universal Time (UTC).

Devices sending data to Oracle SDM Cloud transmit raw data in UTC format. CSV data files are named using UTC timestamps in seconds, also known as Unix Epoch time.

Time Granularity for Data Aggregation and Reports

Aggregated data is available in the following time intervals:

Hourly—Starts at the 00 minute of the hour and ends at minute 59.
Daily—Starts at 00:00 (midnight) and ends at 23:59.
Weekly—Starts at 00:00 on the first day of the week and ends at 23:59 on the last day.
Monthly—Starts at 00:00 on the first day of the month and ends at 23:59 on the last day.

Canned reports are also available in Yearly intervals, which source data from monthly aggregated data.

Note:

Aggregated data for each time granularity is dependent on its child granularity. For example, Hourly data is derived by aggregating the raw data, Daily data is derived by aggregating the hourly data, and so on.

For example, to calculate the Daily Average CPU Utilization for a unique combination of device, redundancy state, and I2C bus state in the 'System' HDR group, the system aggregates the Hourly Average CPU Utilization records for that specific combination. Specifically, Oracle SDM Cloud computes the average of all 24 hourly records (for the same unique combination) to derive the Daily value.

This hierarchical aggregation ensures that data at each granularity level is consistent and accurately reflects the underlying metrics.