O'Reilly logo

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial by Adrian Ward, Haroun Khan, Christian Screen

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

System setup

Let's get the system set up to track usage. For our system, which is the standard method, the configuration is in three parts, and they are all linked to each other. The steps are:

  1. Setting up the database table.
  2. Setting up the BI Server repository.
  3. Updating the BI Server's configuration file.

Tip

There is an option to store the usage tracking records in a text file, but as this is not as useful as the database method, it will be more difficult and slower to analyze a text file than a database table.

Setting up the database table

Near the beginning of the book, we ran the RCU. This created a database schema with several tables in, one of which is normally used for the storing of the usage tracking records. The S_NQ_ACCT table has been in ...

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