Point in Time Dimension

IT Asset Management (Cloud)
The Point in time dimension expands into a tree hierarchy with three levels:
  • Year
  • Month within a year
  • Day, which is really the full date/time value when the snapshot was recorded in the data warehouse database.

You can, of course, pick any period (such as a year) to prepare your report, and then within the published report drill through to smaller time intervals, down to the individual data snapshot. Snapshots are recorded weekly.

This dimension has no equivalent in the management views within IT Asset Management, and does not reflect data stored in the compliance database.

Table 1. Attributes for the Point in time dimension
Attributes Notes
Year

The year in which a snapshot was captured.

Month

The month in which a snapshot was captured.

Month-year

A convenience caption for reporting that combines the numeric month and year values. For example, August 2016 is represented as 8 - 2016.

Day

The day (number within the month) on which the snapshot was captured.

Date

The full date/time value when the snapshot was stored (for example, 2016-09-03 14:40:00.000). The date is represented in the extended format defined in ISO 8601:2004 (that is, YYY-MM-DD) and the time is in 24-hour format listing hours, minutes, seconds, and milliseconds. The time zone is not included, but all timestamps are recorded using the time setting on your central application server.

IT Asset Management (Cloud)

Current