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:
|Primary key of this table.
|iWD GAX Plug-in ID for the metric.
|ID of the event that created or updated the metric record.
|Name of the metric as set in iWD.
|Description of what the metric represents as set in iWD.
|Metric value. It is incumbent on the report writer to perform any type conversion on this field.
|Key to the TENANT dimension.
|Key to the SOLUTION dimension
|Key to the DEPARTMENT dimension.
|Key to the PROCESS dimension.
|Key to the ETL_AUDIT dimension, identifying the ETL job that created this record.
|Key to the ETL_AUDIT dimension, identifying the ETL job that last updated this record.
|The date, in YYYY-M-D HH:MM:SS F format, from which this metric is valid.
|The date, in YYYY-M-D HH:MM:SS F format, until which this metric is valid.
|Version of the record.