O'Reilly logo

Oracle Business Intelligence 11g R1 Cookbook by Cuneyt Yilmaz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Enabling Usage Tracking

Usage Tracking is a very important feature of Oracle BI. It can be enabled at the server level and it can store all query execution information in a table in the database. This feature allows us to create usage reports as well. We're going to learn how to enable Usage Tracking in this recipe. After enabling Usage Tracking we're going to access some sample analyses. This will generate the logs about the query executions and these logs will be stored in the Usage Tracking table. Then we will create the reports that will show the usage statistics.

How to do it...

  1. To store the usage data in a database table, first of all we'll have to create this table. The table creation script can be found in the installation directory. The ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required