Jump to: navigation, search

METRIC Dimension

Metrics are values that can be associated with a department or process. Metrics are set in iWD and are used to associate a value for evaluation against various attributes for reporting purposes (that is, “Cost per Task” set to $0.50). This dimension contains the following fields:

The METRIC Dimension
Field Data Type Description
METRIC_KEY int Primary key of this table.
METRIC_CONFIG_ID nvarchar(40) iWD GAX Plug-in ID for the metric.
METRIC_CONFIG_EVENT_ID bigint ID of the event that created or updated the metric record.
METRIC_NAME nvarchar(255) Name of the metric as set in iWD.
METRIC_DESCRIPTION nvarchar(255) Description of what the metric represents as set in iWD.
METRIC_VALUE nvarchar(255) Metric value. It is incumbent on the report writer to perform any type conversion on this field.
TENANT_KEY int Key to the TENANT dimension.
SOLUTION_KEY int Key to the SOLUTION dimension
DEPARTMENT_KEY int Key to the DEPARTMENT dimension.
PROCESS_KEY int Key to the PROCESS dimension.
CREATED_ETL_AUDIT_KEY int Key to the ETL_AUDIT dimension, identifying the ETL job that created this record.
UPDATED_ETL_AUDIT_KEY int Key to the ETL_AUDIT dimension, identifying the ETL job that last updated this record.
VALID_FROM datetime The date, in YYYY-M-D HH:MM:SS F format, from which this metric is valid.
VALID_TO datetime The date, in YYYY-M-D HH:MM:SS F format, until which this metric is valid.
VERSION int Version of the record.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on December 19, 2017, at 02:26.