(updated for 11.1.1.7.0)
When usage tracking is enabled, the BI server collects information related to usage such as the query that was sent to the server, how much time it took to execute it, etc. This information can help in data warehouse optimization and optimization of the BI system as a whole.
when creating the schemas using the repository creation utility (rcu) during OBIEE installation, the below table was created which stores the usage tracking information.
| Schema Name | Table Name |
| DEV_BIPLATFORM | S_NQ_ACCT |
Be sure you remember the above schema password.
Open up BI Admin Tool and create a new repository or use your existing one. create a new database –> add a connection pool –> import metadata
got to $ORACLE_INSTANCE\config\OracleBIServerComponent\coreapplication_obis1 and edit the NQSConfig.INI file
[USAGE_TRACKING]
ENABLE = YES;
DIRECT_INSERT = YES;
#==============================================================================
# Parameters used for inserting data into a table (i.e. DIRECT_INSERT = YES).
#
#PHYSICAL_TABLE_NAME = "<Database>"."<Catalog>"."<Schema>"."<Table>"; # Or "<Database>"."<Schema>"."<Table>" ;
PHYSICAL_TABLE_NAME = "UsageDB"."DEV_BIPLATFORM"."S_NQ_ACCT";
#CONNECTION_POOL = "<Database>"."<Connection Pool>";
CONNECTION_POOL = "UsageDB"."Usage Connection Pool";
BUFFER_SIZE = 250 MB;
BUFFER_TIME_LIMIT_SECONDS = 5;
NUM_INSERT_THREADS = 5;
MAX_INSERTS_PER_TRANSACTION = 1;
notice that there is no data present in the usage table yet.
save the NQSConfig file, save your rpd and deploy it using the FM Enterprise Manager.
login to Answers and create / run an analysis and observer the output.
you can confirm that usage tracking has been enabledby viewing the log file
usage tracking records will now be available in the S_NQ_ACCT table.
you can make better use of this information in the true business intelligence sense by creating a dimensional data model for the data in the S_NQ_ACCT table and creating some analysis in your presentation layer. This is nicely illustrated in the OBE tutorial Setting Up Usage Tracking in Oracle BI EE
In OBIEE 11.1.1.6.0, / 11.1.1.7.0 the usage tracking settings can be done from Fusion Middleware enterprise manager.
Login to FM enterprise manager. on the LHS tree view, navigate to Farm_bifoundation_domain –> Welblogic Domain –> bifoundation_domain. right click to get the context menu
Expand Application Defined MBeans –> oracle.biee.admin –> Domain: bifoundation_domain.
Lock the domain, as follows: ref [Oracle docs]
-
Expand BIDomain and select the BIDomain MBean where group=Service.
-
Display the Operations tab.
-
Click the lock link.
Expand BIDomain.BIInstance.ServerConfiguration, then select the BIDomain.BIInstance.ServerConfiguration MBean.
Ensure that the UsageTrackingCentrallyManaged attribute is set to true. When UsageTrackingCentrallyManaged is set to false, the following parameters are managed using the NQSConfig.INI file (just like in OBIEE 11.1.1.5) on each Oracle BI Server computer rather than the System MBean Browser:
-
SummaryAdvisorTableName
-
SummaryStatisticsLogging
-
UsageTrackingConnectionPool
-
UsageTrackingDirectInsert
-
UsageTrackingEnabled
-
UsageTrackingPhysicalTableName
Set the UsageTrackingEnabled attribute to true to enable usage tracking.
Set the UsageTrackingDirectInsert attribute to true to enable direct insertion.
Set the UsageTrackingPhysicalTableName and the UsageTrackingConnectionPool with the values as shown previously above in the NQSConfig.INI file
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.
-
Display the Operations tab.
-
Click one of the commit operations.
Restart OBIEE services.
No comments:
Post a Comment