Knowledge Article View Aggregation

Use this scheduled process to aggregate data on the number of articles that have been viewed.

This scheduled process takes data from action capture tables, moves them to analytics staging tables for processing, and writes them to analytics aggregate tables. The end result is that reporting tables named cso_article_stats and cso_popular_answers are populated.

When to Use

This process can be run anytime after you have configured the knowledge management functional area. This process has no dependencies on other processes.

Privileges Required

Verify that you have the following privilege or role:

  • Role

    • Knowledge Manager

  • Privilege

    • SVC_SCHEDULE_SERVICE_JOBS_PRIV

Before You Start

Review the following before scheduling this scheduled process:

  • Recommended Frequency:

    • We recommend that you schedule this process to run automatically every hour by setting the frequency as Hourly/Minute, and the time between runs as one hour. Once started, this process runs continuously and aggregates new data every hour.

  • Execution Time:

    • Within one hour

  • Compatibility:

    • This process depends on the Service process, Refresh Service Categories for Reporting, and on the Analytics process, Refresh Denormalized Time Dimension Table for BI. For more information about Refresh Service Categories for Reporting, see the Refresh Service Categories for Reporting topic in the Service Request Management. For more information about Refresh Denormalized Time Dimension Table for BI, see the Related Topics section.

    • You can't run more than one instance of this scheduled process at the same time. If multiple instances are submitted, the first instance runs and subsequent instances remain in blocked status until the first instance is completed.

Parameters

None.

Troubleshooting Information

You can use the scheduled process page or logs to verify the status of the scheduled process.