Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Knowledge Management Article Views- Unable to view the data for Knowledge Article Status.

Received Response
28
Views
3
Comments
User_UE94E
User_UE94E Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Hello,

I attempted to run an OTBI analysis using the 'Knowledge Management - Article Summary Historical' Subject Area to retrieve data
on "# of Article Views," "# of Article Links," and Article Status for Knowledge Articles.
However, I am unable to view the data for the Knowledge Article Status column in OTBI.

I've also scheduled the below required schedule processes for the same.

Refresh Service Categories for Reporting - Hourly
Refresh Denormalized Time Dimension Table for BI- Daily
Knowledge Article View Aggregation - Hourly
Knowledge Search Aggregation - Hourly

Are the "Article Status" in this Subject Area populated with data?

Thank you.

Tagged:

Answers

  • Mark Stoker
    Mark Stoker Rank 4 - Community Specialist

    Hi @User_UE94E,

    We also have no data in the article status column.

    What are you trying to report on?

    Below are the steps to generate statistics on Knowledge Articles:

    The CRM Calendar should be configured in the system for current year.

    The below processes should be scheduled:

    Knowledge Content Batch Process (run daily)
    Knowledge Search Batch Process (run every 2 mins)
    Knowledge Article View Aggregation (run hourly)

    If the 'Knowledge Article View Aggregation' is not scheduled it may take more than a day or more for the tables to be populated for Knowledge stats by this process.

  • User_UE94E
    User_UE94E Rank 2 - Community Beginner

    Hello Mark,

    Thanks for the update.

    I attempted to run an OTBI analysis using the 'Knowledge Management - Article Summary Historical' Subject Area to retrieve data on "# of Article Views and Article Status for Knowledge Articles.

    Additionally, The below processes has been scheduled:

    Refresh Service Categories for Reporting - Hourly
    Refresh Denormalized Time Dimension Table for BI- Daily
    Knowledge Article View Aggregation - Hourly
    Knowledge Search Aggregation - Hourly

    Thank you!

  • User_UE94E
    User_UE94E Rank 2 - Community Beginner

    Hello @Mark Stoker

    After enabling the 'Enable Article Statuses' option from the 'Manage Knowledge Article Status' task still can't see the data in the Article Status column.

    Additionally, I've scheduled the below schedule processes as well.

    Knowledge Content Batch Process-Daily
    Knowledge Search Batch Process-15 min

     Thank you!