KPIDashboardMetric_SNAPSHOT_FACT Table

KPIDashboardMetric_SNAPSHOT_FACT is a fact table storing historical KPI Metric data.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.

Table 1. Database columns for `KPIDashboardMetric_SNAPSHOT_FACT` table
Database Column	Details
`KPIMetricRecordID`	Type: integer. Key. Generated ID Primary key to the Metric Record.
`MetricTypeID`	Type: small integer Foreign key to MetricType.
`MetricSubTypeID`	Type: small integer Foreign key to MetricType.
`SoftwareTitlePublisherID`	Type: integer. Nullable ID of software title publisher.
`SoftwareTitlePublisher Name`	Type: text (max 1000 characters). Nullable Name of software title publisher.
`SoftwareTitleProductID`	Type: integer. Nullable Name of software title publisher.
`SoftwareTitleProductName`	Type: text (max 200 characters). Nullable Name of software title publisher.
`MetricValue1`	Type: decimal Calculated value of the metric.
`MetricValue2`	Type: decimal. Nullable Additional parameter value of the metric.
`MetricCurencyRateID`	Type: integer. Nullable Currency Rate Snapsot ID of the metric.
`CostCenterID`	Type: text (max 128 characters). Nullable CostcenterID against which the metric value is calculated.
`CostCenterPath`	Type: text (max 500 characters). Nullable CostcenterPath against which the metric value is calculated.
`CorporateUnitID`	Type: text (max 128 characters). Nullable CorporateUnitID against which the metric value is calculated.
`CorporateUnitPath`	Type: text (max 500 characters). Nullable CorporateUnitPath against which the metric value is calculated.
`LocationID`	Type: text (max 128 characters). Nullable LocationID against which the metric value is calculated.
`LocationPath`	Type: text (max 500 characters). Nullable LocationPath against which the metric value is calculated.
`SnapshotDate`	Type: date. Key Date when the data was collected
`ComplianceSavedSearch SystemID`	Type: integer. Key. Nullable An identifier for a system custom view.
`SoftwareLicenseID`	Type: integer. Nullable SoftwarelicenseID related to the metric.
`SoftwareLicenseName`	Type: text (max 256 characters). Nullable SoftwareLicenseName related to the metric.