Article Summary Historical Subject Area
This subject area contains information on knowledge management article historical metrics. This data shows how articles are ranked in popularity and which articles require updates. Users can create reports on article views, ratings, service request, links article creation, and publishing.
The historical data is refreshed on an hourly basis.
- Refresh Denormalized Time Dimension Table for BI
- Knowledge Article View Aggregation
|
Dimension Folder |
Dimension |
Definition |
|---|---|---|
|
Article - Latest Version |
Answer ID |
The unique identifier for the article. You can exclude this dimension from your report but you must include it for the subject area join to work effectively. |
|
Article Display End Date |
The end date after which the article is no longer available for display. |
|
|
Article ID |
The identifier of the article. |
|
|
Article Latest Update Date |
The date that the article was last 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 Published Date |
The date on which the article is published. |
|
|
Article Status |
The status of the article as set in Authoring. |
|
|
Article Title |
The title of the article. |
|
|
Article 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. |
|
|
Base Locale Code |
The code of the locale to which the article belongs. |
|
|
Base Locale Description |
The description of the locale. |
|
|
Content Type |
The type of the content, for example, article, FAQ. |
|
|
Creation Date |
The date on which the article is added to the repository. |
|
|
Department |
The department of the article. |
|
|
Latest Version Locale Code |
The locale code for the latest version of the article. |
|
|
Latest Version Locale Description |
The description of the locale for the latest version of the article. |
|
|
Original Creation Date |
The date on which the article was originally created and imported. |
|
|
Published |
The article is marked as published. |
|
|
Article Summary |
Rank |
The rank represents article use within the previous 90 days, with a higher weight given to those viewed in more recent time periods. Use this column to sort any list of documents from most popular (highest value) to least popular (lowest value). |
|
Employee |
To view the hierarchy and dimensions for this folder, see the Employee folder 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 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 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. |
|
Time |
Stat Calendar Month |
The calendar month of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured. |
|
Stat Calendar Month End Date |
The calendar month end date of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured. |
|
|
Stat Calendar Month Start Date |
The calendar month start date of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured. |
|
|
State Calendar Quarter |
The calendar quarter of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured. |
|
|
Stat Calendar Quarter End Date |
The calendar quarter end date of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured. |
|
|
Stat Calendar Quarter Start Date |
The calendar quarter start date of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured. |
|
|
Stat Calendar Year End Date |
The calendar year end date of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured. |
|
|
Stat Calendar Year Start Date |
The calendar year start date of the statistics (stat) date. This is the date on which the aggregation job was executed and ratings and other updates captured. |
|
|
Stat Date |
The statistics (stat) date. This is the date on which the aggregation job was executed and ratings and other updates captured. |
|
|
Stat Month |
The month of the statistics (stat) date. This is the date on which the aggregation job was executed, and ratings and other updates captured. |
|
|
Stat Quarter |
The quarter of the statistics (stat) date. This is the date on which the aggregation job was executed and ratings and other updates were captured. |
|
|
Stat Year |
The year of the statistics (stat) date. This is the date on which the aggregation job was executed and ratings and other updates were captured. |
The following table illustrates the facts of historical data:
|
Fact Folder |
Fact |
Definition |
|---|---|---|
|
Article Management |
Number of Article Updates |
The number of times the article was updated. |
|
Number of Articles Published |
The total number of article published. |
|
|
Article Ratings |
# of Rating 1 |
The number of times an article was rated 1 star. |
|
# of Rating 2 |
The number of times an article was rated 2 stars. |
|
|
# of Rating 3 |
The number of times an article was rated 3 stars. |
|
|
# of Rating 4 |
The number of times an article was rated 4 stars. |
|
|
# of Rating 5 |
The number of times an article was rated 5 stars. |
|
|
Average Rating |
The average rating for the article. |
|
|
Article View |
# of Article Views |
The number of times users viewed the article. |
|
Service Request Links |
# of Article Links |
The number of times the article was linked to a service request. |