previous

Setting Up Usage Tracking in OBI 11g

Purpose

This topic details how to set up Usage Tracking and create reports to monitor the queries in Oracle OBI 11g. Usage tracking is helpful in determining which user queries are creating performance bottlenecks, based on query frequency and response time.

Introduction

The Oracle BI Server supports a collection of usage tracking data. When usage tracking is enabled, the Oracle BI Server collects usage tracking data for each query, and it writes statistics to a usage tracking log file or inserts them directly into a database table.

Step 1

Steps required for implementing Usage Tracking of OBIEE11g:

  1. Connect to the database.
  2. In the OPERA BI schema, check for the existence of the "S_NA_ACCT" Usage Tracking table.
  3. Check for data in the below tables:

    S_NQ_ACCT

    S_ETL_DAY

    S_ETL_TIME_DAY

  4. Check the column names under S_NQ_ACCT.

    obi_setting_up_usage_tracking_in_obi_11g_1.jpg

Step 2

  1. To Enable Usage Tracking RPD in the Config file, you will copy the command files and PY scripts from the Config folder on the OPERA App server.

    OPERA APP server location:

    \D_DRIVE\MICROS\opera\Tools\BI_11G\Wizard\Server

    Files to copy:

    MFUTracking.cmd

    UTracking.py

    obi_setting_up_usage_tracking_in_obi_11g_2

  2. Place the files in the OPERA server Install fill locations.

    obi_setting_up_usage_tracking_in_obi_11g_3

  3. Run the following Command script: MFUTracking

    Note: This command script will change the NQSCONFIG file to enable the usage tracking.

Step 3:

To Upload the RPD file with Usage Tracking subject area:

  1. Copy the latest version from the below location:

    OPERA app server \D_DRIVE\MICROS\opera\Tools\BI_11G\Repository

  2. Place the RPD in the following file location: D:\media\micros\
  3. Run the following command script: MFLOAD_RPD

    obi_setting_up_usage_tracking_in_obi_11g_4

Step 4:

To merge the Usage Tracking Catalog:

  1. Copy the USAGE TRACKING. CATLOG file from the OPERA APP server to a local machine. Any location will suffice as it will be uploaded using UI (analytics).

    OPERA APP server location: D_Drive\Micros\opera\tools\bi\catalog

    obi_setting_up_usage_tracking_in_obi_11g_5

  2. Log in to Analytics as a user with the “BI Administrator” role and go to "Catalog."
  3. Under Tasks>Shared Folders, select unarchive, browse to the location and unarchive with default settings.

    obi_setting_up_usage_tracking_in_obi_11g_6

    obi_setting_up_usage_tracking_in_obi_11g_7

Step 5:

To checking usage tracking SA reports and dashboards:

  1. Log in as a user, run a few reports and check if the usage tracking subject area is populating the reports.

    obi_setting_up_usage_tracking_in_obi_11g_8

  2. Check to see if the usage tracking subject area is available under the Criteria tab.

    obi_setting_up_usage_tracking_in_obi_11g_9

  3. Run a sample report to test by selecting some of the columns from the Usage Tracking subject area.

    obi_setting_up_usage_tracking_in_obi_11g_10

  4. Check whether the default dashboard is populating the data.

    obi_setting_up_usage_tracking_in_obi_11g_11

    Query Count by Subject Area:

    obi_setting_up_usage_tracking_in_obi_11g_

    Longest Running Queries by User:

    obi_setting_up_usage_tracking_in_obi_11g_13