Time Granularity
Time Measurements in Report Manager
Report Manager time measurements are based on the UTC time. The devices pushing data to Oracle® Communications Report Manager send raw data in UTC time. UTC does not operate on Daylight Savings Time (DST), and therefore the timestamps of CSV files do not fluctuate due to DST. Time zones of the server on which the Oracle® Communications Report Manager application runs nor the reporting device are relevant in Report Manager.
Reports are available in the following time granularities: hourly, daily, weekly and monthly.
The aggregation schedule below describes the time frame for processing data based on UTC time.
- CSV Timestamps: CSV data files are titled with the UTC timestamp in seconds, otherwise known as the Unix Epoch time.
- Aggregation and Purging: Aggregation time granularities and purging schedules are based on the Gregorian calendar. References to start time and date are based on the UTC time relative to the Gregorian calendar.
Time Granularity Start and End Date
The table below describes the collection and aggregation periods of data in the Report Manager:
| Time Granularity | Aggregation Schedule |
|---|---|
| Hourly | Starts at the 00 minute of the hour and ends at minute 59 of the hour. The next hour starts at the following 00 minute. |
| Daily | Starts at the 00:00 hour and minute of the day (midnight), and ends at hour and minute 23:59. The next day starts at the following 00:00 hour. |
| Weekly | Starts at the 00:00 hour and minute on the first week of the month, and ends at hour and minute 23:59 on the last day of the week. The next week starts at the following 00:00 hour. |
| Monthly | Starts at the 00:00 hour and minute on the first day of the month, and ends at hour and minute 23:59 on the last day of the month. The next month starts at the following 00:00 hour. |
