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 DimCaseWorker to filter by a case's current or last known worker separately from its owner.
Business value
A team can own a case that an individual works on. Separate dimensions let you analyze owner and worker responsibilities without joining one role through the other. Worker attribution doesn't describe who performed every action or resolved the case.
Grain and source
The query reads DimCaseOwner and returns one row per one row for each user or team worker, plus one row for unassigned cases. The source contains user, team, and unassigned identities.
Columns
Use these names in the semantic model.
| Model column | Model type | Source column in DimCaseOwner | Description |
|---|---|---|---|
WorkerKey |
STRING | OwnerKey |
Worker-role primary key. |
WorkerPrincipalId |
STRING | PrincipalId |
User or team ID from the source. |
WorkerPrincipalType |
STRING | PrincipalType |
User, Team, or Unassigned. |
WorkerName |
STRING | DisplayName |
Worker display name. |
Worker data refreshes with the underlying owner data. The query doesn't import _LastRefreshedDateTimeUtc.
Dashboard relationships
Create independent, single-direction, one-to-many relationships from WorkerKey to WorkerKey on AggCaseAnalytics, AggCaseSLA, and AggCaseSnapshot. Don't create a direct relationship between DimCaseWorker and DimCaseOwner.
For detailed analysis, use FactCase.CurrentWorkerKey. The unassigned key is Unassigned:00000000-0000-0000-0000-000000000000. Worker-assignment coverage columns distinguish cases known to be unassigned from cases with unknown assignments.
The Worker agent filter, Agent tab in the Case dashboard, and hourly drill-through group by WorkerName. Users or teams with identical display names appear together in these views. Representative-count measures include only user-type principals.