Enable Usage Tracking in OBIEE 11g

Usage Tracking is one of the finest features in OBIEE. This helps to get a lot of details which helps in database optimization, aggregation strategies, or billing users or departments based on the usage.

There are two ways of doing this.

1. Through Enterprise Manager
2. Directly changing the Usage Tracking section in NQSCONFIG.INI file.

Till Version 11.1.1.5 we have only one option of doing it and it is a direct configuration change. But in the later versions Oracle has provided a standard way of making these config changes to enable Usage Tracking.

Lets start with the process.The first step is to check the Connection Pool in RPD to confirm if it is pointed to the DEV_BIPLATFORM schema (RCU Schema).

There are two things that needs to be noted from here.

• Connection Pool details

                  "[Database]"."[Connection Pool]"

                  e.g. "Oracle BI Usage Tracking". "Oracle BI Usage Tracking Connection Pool"

• Path to the table S_NQ_ACCT

                 "[Database]". "[Catalog]"."[Schema]". "[Table]"

                  e.g. "Oracle BI Usage Tracking".""."BIPLATFORM"."S_NQ_ACCT"

refer to Create Usage Tracking tables and complete the step before we go for configuring the parameters.

• Login to Enterprise Manager as Weblogic Administrator
• Navigate to WebLogic Domain - bifoundation_domain - System MBean Browser

• Navigate to oracle.biee.admin - Domain: bifoundation_domain  - BIDomain - BIDomain (the 2nd one listed)

• On the right-hand side, go to the “Operations” tab and then click the “lock” option

• Invoke the operation

• Back in the “System MBean Browser” window pane, expand and select the following

oracle.biee.admin - Domain: bifoundation_domain - BIDomain.BIInstance.ServerConfiguration - BIDomain.BIInstance.ServerConfiguration and select Attributes in the right hand pane.

• Click the “Apply” button at the top-right
• Go back to BI Domain and on the right-hand side, go to the “Operations” tab and then click the “simpleCommit” option

• Invoke the operation and restart the BI server using EM or using OPMNCTL commnd.

Click Here to download the PDF format of the steps for Enabling the Usage Tracking in OBIEE.