Point in Time Dimension

FlexNet Manager Suite 2020 R2 (On-Premises)

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 by default.

This dimension has no equivalent in the management views within FlexNet Manager Suite, 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. Data warehouse reference: `SnapshotData` table, in the `SnapshotYear` column.
Month	The month in which a snapshot was captured. Data warehouse reference: `SnapshotData` table, in the `SnapshotMonth` column.
Month-year	A convenience caption for reporting that combines the numeric month and year values. For example, August 2016 is represented as `8 - 2016`. Data warehouse reference: `SnapshotData` table, combining the `SnapshotMonth` and `SnapshotYear` columns.
Day	The day (number within the month) on which the snapshot was captured. Data warehouse reference: `SnapshotData` table, in the `SnapshotDay` column.
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. Data warehouse reference: `SnapshotData` table, in the `SnapshotDate` column.

FlexNet Manager Suite (On-Premises)

2020 R2