Return to the BIDomain MBean where group=Service under, Domain:bifoundation_domain, BIDomain.
![oracle bi administration tool 11.1.1.5 oracle bi administration tool 11.1.1.5](https://docplayer.net/docs-images/46/21662642/images/page_10.jpg)
Set the UsageTrackingPhysicalTableName and the UsageTrackingConnectionPool with the values as shown previously above in the NQSConfig.INI fileĪfter applying your changes, release the lock on the domain, as follows: Set the UsageTrackingDirectInsert attribute to true to enable direct insertion. Set the UsageTrackingEnabled attribute to true to enable usage tracking. 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: Įxpand, then select the MBean.Įnsure that the UsageTrackingCentrallyManaged attribute is set to true.Lock the domain, as follows: ref Įxpand BIDomain and select the BIDomain MBean where group=Service. right click to get the context menuĮxpand Application Defined MBeans –> –> Domain: bifoundation_domain. on the LHS tree view, navigate to Farm_bifoundation_domain –> Welblogic Domain –> bifoundation_domain. In OBIEE 11.1.1.6.0, / 11.1.1.7.0 the usage tracking settings can be done from Fusion Middleware enterprise manager. This is nicely illustrated in the OBE tutorial Setting Up Usage Tracking in Oracle BI EE 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. Usage tracking records will now be available in the S_NQ_ACCT table. You can confirm that usage tracking has been enabledby viewing the log file Login to Answers and create / run an analysis and observer the output. Save the NQSConfig file, save your rpd and deploy it using the FM Enterprise Manager. Creating Analyses and Dashboards in Oracle BI EE 11g (11.1.1.7) Creating a Repository Using the Oracle BI Administration Tool (11.1.1. Notice that there is no data present in the usage table yet. PHYSICAL_TABLE_NAME = "UsageDB"."DEV_BIPLATFORM"."S_NQ_ACCT" ĬONNECTION_POOL = "UsageDB"."Usage Connection Pool"
![oracle bi administration tool 11.1.1.5 oracle bi administration tool 11.1.1.5](https://www.siebelhub.com/main/wp-content/uploads/2011/05/obiee-11.1.1.5-iPad.jpg)
![oracle bi administration tool 11.1.1.5 oracle bi administration tool 11.1.1.5](https://www.rittmanmead.com/blog/content/images/2016/05/05509NewImage.png)
# Parameters used for inserting data into a table (i.e.