Book Image

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial

By : Christian Screen, Haroun Khan, Adrian Ward
Book Image

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial

By: Christian Screen, Haroun Khan, Adrian Ward

Overview of this book

<p>The Oracle Business Intelligence Enterprise Edition 11g (OBIEE) suite delivers a full range of analytic and reporting capabilities, coupled with powerful user experience for creating reports, dashboards and more with your business data. "<em>Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial"</em> will have you unleashing that power in no time, helping you to take action and make the right decisions ataglance. <br /><br /><em>"Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial"</em> provides you with valuable insight and the step-by-step know-how you need to take advantage of everything the Oracle BI suite has to offer you, all utilizing real world case studies for a true implementation in action.<br /><br /><em>"Oracle Business Intelligence Enterprise Edition 11g: A Hands- on Tutorial"</em> takes you on a journey right from inception to a full working OBI 11g System. Using a real-world data walkthrough you’ll explore topics like architecture, reporting and leveraging Essbase as a data source, as well as building the Oracle BI 11g metadata repository (RPD), and developing reports and dashboards in the new Fusion Middleware interface. This practical implementation guide equips you with from the coalface advice which will help you achieve a successful working application by journey’s end.</p>
Table of Contents (26 chapters)
Oracle Business Intelligence Enterprise Edition 11: A Hands-On Tutorial
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

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 use since the nQuire days (hence the NQ in the name) but it has been updated in this release. The change has been to add some columns that are bigger, to cope with large queries. You do not need to use this specific table; you may prefer instead to...