Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Use DimCaseSeverity to display severity labels when you analyze case detail.
Business value
Severity classifies cases separately from priority. The system doesn't use it as a filter or a grouping key in Case dashboard.
Grain and source
The table contains one row per SeverityCode in the default language. Its source is HelperOptionSet, filtered to incident.severitycode with IsDefaultLanguage = true.
Columns
| Column | Type | Source field | Description |
|---|---|---|---|
SeverityCode |
INT | HelperOptionSet.Option |
Original severity option code and primary key. |
SeverityLabel |
STRING | HelperOptionSet.LocalizedLabel |
Severity label in the default language, including custom options. |
SortOrder |
INT | Derived | Dense rank by ascending option code. |
_LastRefreshedDateTimeUtc |
TIMESTAMP | System | Last data refresh date and time in UTC. |
Use the published label column SeverityLabel, not SeverityName.
Reporting relationships
For detail analysis, create a single-direction, one-to-many relationship from SeverityCode to FactCase.SeverityCode.
The default dashboard doesn't import this dimension or FactCase. None of its three aggregates contains SeverityCode. Adding only the dimension therefore doesn't let you filter those metrics with a severity slicer.