Article Real Time Subject Area
The Article Real Time subject area enables you to create reports that provide information on articles in your knowledge base, such as the version, locale, content type, author, and lifecycle dates. It also provides information on employee interaction with articles.
This subject area doesn't include product, category, or linking information.
- Refresh Denormalized Time Dimension Table for BI
- Knowledge Content Batch Process
- Refresh Service Categories for Reporting
Dimension Folder |
Dimension |
Definition |
---|---|---|
Article Version |
Answer ID |
The unique identifier of 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 Last Updated Date |
The date that the article is last updated. |
|
Article Latest Version |
The latest version of the article. |
|
Article Locale |
The language and region of the article. |
|
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. 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 latest article status |
|
Article Title |
The title of the article. |
|
Base Locale Code |
The code of the locale to which the article belongs. |
|
Base Locale Description |
The description of the locale to which the article belongs. |
|
Creation Date |
The date on which the article is added to the repository. |
|
Department |
The department of the article. |
|
Original Creation Date |
The date on which the article is originally created and imported. |
|
Owner ID |
The identifier of the article's owner. |
|
Version |
The current version of the article. |
|
Published |
The article is marked as published. |
|
Content Type |
Content Type |
The type of content such as an article, or FAQ. |
Employee |
Employee Extension |
The folder that contains dimensions for employees who owned article versions. Employees must be assigned the Resource role to be visible in reports. For more information on assigning roles, see the Create Knowledge Roles chapter in this guide. |
Version Article Owner Resource Hierarchy: Current Level -1 - Current Level - 16 Login Current Level -1 - Current Level - 16 Resource Name Current Level 1 - Current Level 16 Position Code Current Level 1 - Current Level 16 Position Name Current Level 1 - Current Level 16 Resource Id Current Level 1 - Current Level 16 Resource Organization Code Level 1 - Current Level 16 Resource Organization Name Level 1 - Current Level 16 Resource Name Current Base, Current Top Level - Login Current Base, Current Top Level - Position Code Current Base, Current Top Level - Position Name Current Base, Current Top Level Resource Id Current Base, Current Top Level Organization Code Current Base, Current Top Level Organization Name Current Base, Current Top-Level Resource Name Direct Reports Fixed Hierarchy Level Hierarchy Based Login User Organization Direct Reports Name User Organization Hierarchy Based Login |
The available hierarchy for the employee version article owners. |
|
Resource Hierarchy Address Line 1 - Address Line 4 City State County Country |
The employee address. |
|
Employee Job Title |
Describes the employee job title. |
|
Employee Job Title Name |
The employee's job title. |
|
Employee Login |
The login of the employee. |
|
Employee Login Name |
The employee's login name. |
|
Employee Party Id |
The employee party identifier. |
|
Employee Row ID |
The table row identifier stored in the source system for the employee. |
|
First Name |
The employee's first name. |
|
From Date |
The start date. |
|
Hire Date |
The employee's date of hire. |
|
Internal |
An internal code. |
|
Key ID |
A unique identifier for a dimension or fact. |
|
Last Name |
The employee's last name. |
|
Manager E-mail Address |
The employee's manager's email address. |
|
Manager ID |
The employee 's manager's identifier. |
|
Manager Job Title |
The employee's 'manager's job title. |
|
Manager Job Title Name |
The employee's manager's job title. |
|
Manager Login ID |
The employee's manager's login identifier. |
|
Manager User Name |
The employee's manager's user name. |
|
Manager of Employee |
The employee's manager. |
|
Middle Name |
The employee's middle name. |
|
Name |
The employee's name. |
|
Parent Organization |
The parent organization to which the employee belongs. |
|
Parent Organization Name |
The name of the parent organization. |
|
Person ID |
The person identifier. |
|
Phone Line Type |
The employee's phone line. |
|
Postal Code |
The employee's postal code. |
|
Previous Last Name |
The employee's previous last name, if applicable. |
|
Primary Email |
The employee's primary email. |
|
Primary Phone Primary Phone Area Code Primary Phone Country Code |
The employee's primary phone number, area code and country code. |
|
Resource Primary Organization |
The organization for the Resource role. |
|
Resource Primary Organization Name |
The organization name for the Resource role. |
|
Resource Profile ID |
The profile identifier for the Resource role. |
|
Salutation Introduction |
The salutation name. |
|
Suffix |
The employee article version owner's suffix, for example, Jr. or III. |
|
Title |
The employee's personal title, (for example Mr. or Dr.). |
|
To Date |
The end date. |
|
User Creation Date |
The date the user created the article. |
|
User Name |
The user's name. |
|
User Status |
The user's status. |
|
Employee Original Article Author |
To view the hierarchy and dimensions in this folder see the dimensions in the Employee folder in this table. |
The folder that contains dimensions for employees who created articles. Employees must be assigned the Resource role to be visible in 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 in this folder, see the dimensions in the Employee folder in this table. |
The folder that contains dimensions for employees who created versions of articles. Employees must be assigned the Resource role to be visible in reports. For more information on assigning roles, see the Create Knowledge Roles chapter in this guide. |
Secondary Dates |
Update Date |
The date on which the article is updated. |
Update Day Name |
The day on which the article is updated. |
|
Update Enterprise Period |
The enterprise period in which the article is updated. |
|
Update Enterprise Year |
The enterprise year in which the article is updated. |
|
Update Month |
The month in which the article is updated. |
|
Update Quarter |
The quarter in which the article is updated. |
|
Update Year |
The year in which the article is updated. |
|
Secondary Dates - Additional Attributes |
Update Calendar Month Update Calendar Month End Date Update Calendar Month Start Date Update Calendar Quarter Update Calendar Quarter Start Date Update Calendar Quarter End Date Update Calendar Week Update Calendar Week Start Date Update Calendar Week End Date Update Day Of Month Update Day Of Week Update Day Of Year Update Enterprise Period End Date Update Enterprise Period Number Update Enterprise Period Start Date Update Enterprise Quarter End Date Update Enterprise Quarter Number Update Enterprise Quarter Start Date Update Enterprise Year End Date Update Enterprise Year Number Update Enterprise Year Period Number Update Enterprise Year Start Date Update Offset Week Update Week Update Week By Year |
The additional attributes that denote the period in which the article is updated. See the For more information, see Time Additional Attributes in the Article Links Real Time Subject Area table. |
Time |
Date Day Name Enterprise Period Enterprise Quarter Enterprise Year Month Quarter Week Year |
The Time-related attributes of the article. For more information, see Time attributes in the Articles Links Real Time Subject Area. |
Time - Additional Attributes |
Calendar Date Calendar Month Calendar Month End Date Calendar Month Start Date Calendar Quarter Calendar Week Start Date Calendar Week End Date Calendar Week Calendar Week Start Date Calendar Week End Date Calendar Year Calendar Year Start Date Calendar Year End Date Day of Month Day of Week Day of Year Enterprise Period End Date Enterprise Period Number Enterprise Period Sort Order Enterprise Period Start Date Enterprise Quarter End Date Enterprise Quarter Number Enterprise Quarter Start Date Enterprise Year End Date Enterprise Year Number Enterprise Year Period Number Enterprise Year Start Date Offset Week Week By Year Year By Week |
The additional time attributes available. For more information, see Time Additional Attributes in the Article Links Real Time Subject Area. |
Version Author |
User E-mail User First Name User Last Name User Locale User Login |
The E-mail, first name, last name, locale, and login details of the author for the current version. |
Version Locale |
Locale Code Locale Description |
The locale and its description to which the current version of the article belong. |
Version Owner |
User E-mail User First Name User Last Name User Locale User Login |
The E-mail, first name, last name, locale, and login details of the owner for the current version. |
The following table lists the facts of the article real time subject area:
Fact Folder |
Fact |
Definition |
---|---|---|
Article Facts |
# of Article Locales |
The number of article locales. |
# of Article Versions |
The number of article versions. |
|
# of Articles |
The number of articles. |