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 Azure AD 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 |
|
🔍 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.