Article Product Real Time Subject Area

The Article Product Real Time subject area contains information about the category or categories an article belongs to. This subject area displays a one-to-many relationship from an article to a category.

Note: Before using this subject area, run the below-mentioned scheduled processes.
  • 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 a 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 was 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 a report but you must include it for the subject area join to work effectively.

Article Minor Version

Article Publish Date

The date on which the article is published.

Article Status

The latest article status.

Article Title

The latest article status.

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 a report but you must include it for the subject area join to work effectively.

Base Locale Code

The code of the locale to which the article belongs.

Base Locale Description

The description of the base locale.

Content Type

The type of the content, for example, article or FAQ.

Creation Date

The date on which the article is added to the repository.

Department Name

The name of the department.

Original Creation Date

The date on which the article was originally created and imported.

Published

The article is marked as published.

Version Locale Code

The locale code for the version of the article.

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 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.

Product

Article Catalog Hierarchy 1 Name

The name of the article catalog hierarchy at level 1.

Article Catalog Hierarchy 2 Name

The name of the article catalog hierarchy at level 2.

Article Catalog Hierarchy 3 Name

The name of the article catalog hierarchy at level 3.

Article Catalog Hierarchy 4 Name

The name of the article catalog hierarchy at level 4.

Article Catalog Hierarchy 5 Name

The name of the article catalog hierarchy at level 5.

Article Catalog Hierarchy 6 Name

The name of the article catalog hierarchy at level 6.

Article Catalog Hierarchy 7 Name

The name of the article catalog hierarchy at level 7.

Article Catalog Hierarchy 8 Name

The name of the article catalog hierarchy at level 8.

Article Catalog Hierarchy Base Level Name

The name of the article catalog present at the base level of the hierarchy.

Article Catalog Hierarchy Top Level Name

The name of the article catalog present at the top level of the hierarchy.

ItemDeleteFlag

The item is marked to be deleted

OrderableFlag

The item is marked as ready to select.

Part Number

The product's part number.

ProdGroupDeleteFlag

The product group is marked to be deleted.

Prod Group Effective End Date

The end date of the product group.

Prod Group Effective Start Date

The start date of the product group.

Product Description

The description of the product.

Product Line

The line to which the product belongs.

Product Name

The name of the product.

Product Row ID

The row identifier of the product.

Product Type

The type of product.

Usage Code

The code for the type of product usage. It can be Base usage, Service usage, or HCM usage codes.

The following table lists the facts and definitions in the article product real time subject area::

Fact Folder

Fact

Definition

Article Product Facts

# of Article Products

The number of products associated with the articles.