Article Real Time Rating Subject Area
The Article Real Time Rating subject area contains information about article ratings, such as ratings values, rated article details, and the users who rated the articles.
This subject area helps analysts identify content that satisfies users' needs, content that users are dissatisfied with, and content linked to SRs that effectively resolves them.
- Refresh Denormalized Time Dimension Table for BI
- Knowledge Content Batch Process
- Refresh Service Categories for Reporting
|
Dimension Folder |
Dimension |
Description |
|---|---|---|
|
Article |
Article Display End Date |
The last date on which the article will be available to end-users. |
|
Article ID |
The article ID. |
|
|
Article Last Updated Date |
The date on which the article was most recently updated. |
|
|
Article Major Version |
The major version of an article. The numbering of this version is 1, 2, 3 and so on. You can exclude this dimension from your report but you must include it for the subject area join to work effectively. |
|
|
Article Minor Version |
The minor version of the article. This version includes minor edits to the major version. The numbering of this version is .1, .2, .3, and so on, for example 1.1, 1.2, 2.1. |
|
|
Locale |
The locale in which the article is published. |
|
|
Creation Date |
The date on which the article was created. |
|
|
Version |
The current version of the article. |
|
|
Employee |
To view the hierarchy and dimensions for this folder, see the Employee folder dimensions in the Article Real Time Subject Area topic. |
The folder that contains dimensions for employees who owned article versions. Employees must be assigned the Resource role to be visible in Analytics reports. For more information on assigning roles, see the Create Knowledge Roles chapter in this guide. |
|
Employee Original Article Author |
To view the hierarchy and dimensions for this folder, see the Employee folder dimensions in the Article Real Time Subject Area topic. |
The folder that contains dimensions for employees who created original articles. Employees must be assigned the Resource role to be visible in Analytics reports. For more information on assigning roles, see the Create Knowledge Roles chapter in this guide. |
|
Employee Version Article Author |
To view the hierarchy and dimensions for this folder, see the Employee folder dimensions in the Article Real Time Subject Area topic. |
The folder that contains dimensions for employees who created versions of an article Employees must be assigned the Resource role to be visible in Analytics reports. For more information on assigning roles, see the Create Knowledge Roles chapter in this guide. |
|
Ratings |
Rating Type |
The ID of the rating type, 2.0 for like/dislike or 4.0 for 5 star. |
|
Rating Name |
The name of rating type, 5 star or like/dislike. |
|
|
Rating Values |
Rating Value |
The actual rating value recorded. |
|
Date Added |
The date that the user rated the article. |
|
|
Rating Facts |
Average Rating |
The average of all ratings of an article. |
|
# of Ratings |
The total number of ratings of an article. |
|
|
# of Rated Articles |
The total number of articles rated by all users in the selected time period. |
|
|
Content Type |
Content Type |
The content type of the rated article. |
|
Rating Added By |
User E-mail |
The e-mail address of the user who rated the article. |
|
User First Name |
The rating user's first name. |
|
|
User Last Name |
The rating user's last name. |
|
|
User Locale |
The locale of the user who rated the article. |
|
|
User Login |
The login of the user who rated the article. |
|
|
Time |
Date |
The time-related attributes of the article. For more information, see Time Attributes in the Article Links Real Time Subject Area. |
|
Day Name |
||
|
Enterprise Period |
||
|
Enterprise Quarter |
||
|
Enterprise Year |
||
|
Month |
||
|
Quarter |
||
|
Week |
||
|
Year |
||
|
Version Locale |
Locale Code |
The locale and its description to which the current version of the article belongs. |
|
Locale Description |
Facts
|
Fact Folder |
Fact |
Description |
|---|---|---|
|
Rating Facts |
# of Rating |
The number of ratings that were entered by all users in the selected time period. |
|
Average Rating |
The sum of all rating values divided by the number of ratings entered. |
|
|
# of Rated Articles |
The number of articles that were rated by all users in the selected time period. |