Point in Time Dimension
- 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.
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