Slowly Changing Dimensions

Static data which can change slowly but unpredictably

A slowly changing dimension (SCD) in data management and data warehousing is a dimension which contains relatively static data which can change slowly but unpredictably, rather than according to a regular schedule.

Services

A Service is a Endpoint acting for the service tasks as a middle layer between users and customers (or other task initiators). 

Attribute 

Data Type

Description 

Id  guid Primary key 
Name  text Service name 
OrganizationUnitId guid References Organization unit of the service
ServiceOrganizationUnitId guid Contains service Organization Unit for permission purposes

🔍 Services are managed via Nimbus Service Administration.

 
 

Users

Users are the the persons who interact with Nimbus e.g. to accept calls. 

Attribute 

Data Type

Description 

Id  guid Primary key 
O365Id guid Nimbus user O365 identifier
Upn text Nimbus caller User Principal Name
UserName text Display name of the Nimbus user First name + Last Name 
OrganizationUnitId guid Reference user's organization

🔍 Users are synced from your Microsoft Entra ID and added via Nimbus User Administration.

 
 

Callers

Callers are the customers that contact the service.

Attribute

Data Type

Description

Id integer Primary key
O365Id guid caller O365 identifier
Upn text caller User Principal Name
TelNumber text caller telephone number
TenantId guid Tenant Id
CustomerIdentifier text Caller's UPN, telephone or O365 id (depending on origin type)
 
 

Organization Units

Organization units are used to describe hierarchal structure of the organization.

Attribute  Data Type Description 
Id  guid Primary key 
Name  text Organization name 
ParentId guid References parent Organization unit
🔍 Fields below are not provided by OData feed, but calculated in Power BI template
OU_PATH text Represents path to OU from root level
OULevel1 text Name of OU at level 1 of the hierarchy
OULevel2 text Name of OU at level 2 of the hierarchy
OULevel...7 text Name of OU at level 7 of the hierarchy

🔍 Visit Organization Units to learn more about the concept and its configuration.

 
 

Opening Hours

Opening Hours are applied as part of General Service Settings and added to the session at the point of an incoming task.

Attribute  Data Type Description 
Id  guid Primary key 
Name  text
  • None
  • Open
  • Closed
  • Holiday
  • 1 Special
  • 2 Special
  • 3 Special
  • 4 Special

🔍 Visit Opening Hours to learn more about the concept and its configuration.

 
 

Codes

Connected with FirstPrimaryCodeId field of Service Sessions table.

Attribute

Data Type

Description

Id guid Primary key
PrimaryCode text primary code name
Description text primary code description

Connected with FirstSecondaryCodeId field of Service Sessions table.

Attribute

Data Type

Description

Id guid Primary key
SecondaryCode text secondary code name
Description text secondary code description

🔍 Visit Codes to learn how the codes are defined and used.

 
 

Tags

Connected with TagId field of Service Session Tags table.

Attribute

Data Type

Description

Id guid Primary key
Tag text tag description

🔍 Tags are used in the My Sessions view to complete open task as part of "After Call Work" (ACW). They are freely user-definable.

 
 

DistributionPriority

DistributionPriorityTypes is connected with DistributionPriority field of Service Sessions table.

Attribute

Data Type

Description

Id int Primary key
Name text Distribution name

UserSessionDistributionPriority isConnected with DistributionPriority field of User Sessions table.

Attribute

Data Type

Description

Id int Primary key
Name text Distribution name

🔍Both DistributionPriorityTypes and UserSessionDistributionPriority are sharing the same OData endpoint.

 
 
 

Tasks

TaskDirections are connected with TaskType dataset and Service Sessions table.

Attribute

Data Type

Description

Id int Primary key
Name text Distribution name

TaskTypeGroups areconnected with TaskTypeGroupId field of TaskType table.

Attribute

Data Type

Description

Id int Primary key
Name text Distribution name

TaskTypes areconnected with TaskTypeGroupId field of TaskType table.

Attribute

Data Type

Description

Id int Primary key
Name text Distribution name
IsService bool Flag true or false
TaskDirectionId int Reference to Task direction table
TaskGroupId int Reference to Task group table
 
 

NotAvailableReasons

NotAvailableReasons are used with UserStates table.

Attribute

Data Type

Description

Id quid Primary key
Name text NAR name
TenantId guid Reference to Tenant
OrganizationUnitId guid Reference to Organization unit in which particular NAR is used.
 
 

Row-level security (RLS)

Row-level-security datasets.

ServiceDataPermissions areused to create Row-level security rules in Power BI Desktop. This data is available via OData, but it is not represented as a dataset in Power BI and must be added manually.

Attribute

Data Type

Description

UserId guid UserId who has permission to Organization Unit
OrganizationUnitId guid Organization Unit which is mapped to User.

UserDataPermissions areused to create Row-level security rules in Power BI Desktop. This data is available via OData, but it is not represented as a dataset in Power BI and must be added manually.

Attribute

Data Type

Description

UserId guid UserId who has permission to Organization Unit
OrganizationUnitId guid Organization Unit which is mapped to User.
 
 

NOTES

These dimensions are slowly changing, meaning have changing set of dimension members. The set changes depending on data configuration.

💡Note: Description columns are generally not part of the dataset.

 

 

Table of Contents