Thursday, June 20, 2013

Setting Up Usage Tracking in Oracle BI 11g Part 2

Setting Up Usage Tracking in Oracle BI 11g Part 2

Here am going to providing, configure usage tracking through Oracle Enterprise Manager (EM) by performing the following steps.

Log into EM. In this example, the user name is satya and the password is admin123.

Select WebLogic Domain>bifoundation_domain from the left navigation pane then Click the WebLogic Domain drop-down list in the right pane.

Select System MBean Browser from the list and Expand Application Defined MBeans>oracle.biee.admin.

Expand bifoundation_domain then Lock the domain to update it. Expand BIDomain and select the BIDomain MBean where group=ServiceNote: Expand Show MBean Information in the right pane.

'Click the Operation tab then Click the Lock link. On the Operation:lock page, click the Invoke button.

Click the Return button then Expand BIDomain.BIInstance.ServerConfiguration, and then select the BIDomain.BIInstance.ServerConfiguration MBean.

Click the Attributes tab. Scroll down and click UsageTrackingCentrallyManaged. Set Value to true in the drop-down list then Click the Apply button. When you see the confirmation message for the update, click the Return button.

Similarly, set the UsageTrackingEnabled attribute to true to enable usage tracking and Set the UsageTrackingDirectInsert attribute to true to enable direct insertion.

Set the UsageTrackingPhysicalTableName attribute to the name of the fully qualified database table for collecting query statistic information, as it appears in the Physical layer of the Oracle BI repository. In this example, it is set as follows:

"Satya Usage Tracking"."Satya Ranki Reddy Usage Schema"."S_NQ_ACCT".

Set the UsageTrackingConnectionPool attribute to the name of the fully qualified connection pool for the query statistics database, as it appears in the Physical layer of the Oracle BI repository. In this example, it is set as follows:

"Satya Usage Tracking"."Usage Tacking Connection Pool"

Note: For usage tracking insertions to succeed, the connection pool must be configured with a user ID that has write access to the back-end database. Also, it is recommended that the connectivity type support international data.

After applying your changes, release the lock on the domain, as follows:

Return to the BIDomain MBean where group=Service under oracle.biee.admin, Domain:bifoundation_domain, BIDomain.
Click the Operations tab.

Click one of the first commit operations.

Go to the Oracle Business Intelligence Instance page and click Restart All on the Availability>Processes tab.

Creating and Running to Populate Usage Tracking Table:

Login to OBIEE answers then create report and check the usage tracking functionality.

Create and run the following analysis in the Satya Usage BMM subject area:

And see the result.

Usage Tracking implementation Part 1:   Usage Tracking Part 1

Good Luck !!!.

Satya Ranki Reddy.


  1. Hi Satya,
    Thanks for sharing this, I was trying to implement Usage Tracking the same way you have mentioned. But facing the BI services issues, not starting. In the error log it says syntex error, and mentioned Physical Table name and Coreapplication is incorrect. Can you please help us fix this issue. We have OBIEE

  2. Hi Dhiraj,

    You haven’t defined Physical table name correctly in BI Domain.BI instance. Server Config. Please cross check this step.