Expand All Collapse All
Stat Dimensions

StatDimensions Table

Stat Dimensions

The StatDimensions table stores the relationship between the report hierarchies set and a unique identifier field called DimensionSet. The system reuses the DimensionSet value for identical report hierarchies set. Note that since time is not part of the report hierarchies set, the number of records in this table should be relatively manageable.

  • Table Type - Lookup
  • Last Changed Version - 16.3.0.354
  • Last Changed Reason - Updated SD_SummDimSet index to include cDimension1

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
DimensionSet int False No

The unique identifier referencing a set of report hierarchies.

 4.0.106.453 4.0 Release
SummDimensionSet int True No

The unique identifier referencing a set of report hierarchies for summary dimensions. This identifier can be translated back to the report hierarchies with this table. The system reuses the DimensionSet for identical report hierarchies set.

 4.0.106.453 4.0 Release
cType char (1) False No

Type of Queue statistics data.

Value Description
A; Agent
W Workgroup
S Statistics Group
4.0.106.453 4.0 Release
cDimension1 nvarchar (50) False Yes

First dimension. The possible values depend on the type of data. Please refer to each of the queue period data.

 4.0.106.453 4.0 Release
cDimension2 nvarchar (50) False Depends on customer usage

Second dimension. The possible values depend on the type of data. Please refer to each of the queue period data.

 4.0.106.453 4.0 Release
cDimension3 nvarchar (50) False No

Third dimension. The possible values depend on the type of data. Please refer to each of the queue period data.

 4.0.106.453 4.0 Release
cDimension4 nvarchar (50) False No

Fourth dimension. The possible values depend on the type of data. Please refer to each of the queue period data.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_StatDim_DimSet Clustered DimensionSet (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_StatDimensions_SummStatDim SummDimensionSet StatDimensions DimensionSet Yes

Index Name Type Column Name (sort order)
SD_CDim1Covering Unique non-clustered cDimension1 (Ascending)
cDimension2 (Ascending)
cDimension3 (Ascending)
cDimension4 (Ascending)
cType (Ascending)
SD_SummDimSet Non-clustered SummDimensionSet (Ascending)
cDimension1 (Ascending)