Book Image

Oracle Business Intelligence 11g R1 Cookbook

By : Cuneyt Yilmaz
Book Image

Oracle Business Intelligence 11g R1 Cookbook

By: Cuneyt Yilmaz

Overview of this book

<p>Extracting meaningful and valuable business information from transactional databases is crucial for any organization. OBIEE 11g is a reporting tool that satisfies all the business requirements regarding complex reporting. It consists of a powerful back-end engine with a repository and a highly customizable graphical web interface.</p> <p>Oracle Business Intelligence 11g R1 Cookbook provides all the key concepts of the product including the architecture of the BI Server. This practical guide shows each and every step of creating analytical reports starting from building a well-designed repository. You will learn how to create analytical reports that will support different business perspectives. <br /><br />This practical guide covers how to implement OBIEE 11g suite in order to enable BI developers to create sophisticated web based reports. All of tasks will be covered step by step in detail. <br /><br />You will explore the architecture of the Oracle Business Intelligence Server and learn how to build the repository (RPD). We will also discuss how to implement the business rules in the repository with real-life scenarios.</p> <p>Best practices of a successful BI implementation are esssential for any BI developer so they are also covered in depth.If you are planning to implement OBIEE 11g suite, this step-by-step guide is a must have resource.All the key tasks are defined in detail and supported with diagrams and screenshots.</p>

Related Content you might be interested in

Current Title:

Small book image
Oracle Business Intelligence 11g R1 Cookbook
Cuneyt Yilmaz
Jun, 2013 | 364 pages
No titles found
Table of Contents (19 chapters)
Oracle Business Intelligence 11g R1 Cookbook
Oracle Business Intelligence 11g R1 Cookbook
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Exploring and Building the Repository
Exploring and Building the Repository
Introduction
Building the Physical layer in the repository
Building the Business Model and Mapping layer
Adding multiple sources to the logical table source
Adding calculations to the fact table
Creating variables
Building the Presentation layer
Validating the repository using Consistency Check Manager
Uploading the repository
2
Working with Logical Dimensions
Working with Logical Dimensions
Introduction
Creating level-based hierarchies
Creating parent-child hierarchies
Creating level-based measures
Creating shared measures
Creating presentation hierarchies
3
Using Aggregates and the Time Series Functions
Using Aggregates and the Time Series Functions
Introduction
Creating aggregate tables
Implementing aggregate tables
Using the Aggregate Persistence Wizard
Creating calculations by using the time series functions
4
Working with Multidimensional Data Sources
Working with Multidimensional Data Sources
Introduction
Importing the multidimensional data source
Accessing members and member counts
Creating the multidimensional Business Model
Implementing Horizontal Federation
Implementing Vertical Federation
5
Security in Oracle BI
Security in Oracle BI
Introduction
Configuring security settings
Creating users
Creating groups
Creating application roles
Setting up permissions on repository objects
Configuring query limits
Specifying the time restrictions
Creating data filters
6
Managing Usage Tracking and Enabling the Cache
Managing Usage Tracking and Enabling the Cache
Introduction
Enabling Usage Tracking
Creating the Business Model for Usage Tracking
Creating dashboards for Usage Statistics
Enabling the cache
Gathering cache statistics
Managing the cache
7
Creating Simple Oracle Business Intelligence Analyses
Creating Simple Oracle Business Intelligence Analyses
Introduction
Constructing the analysis
Exploring the table view properties
Formatting the table view
Filter types and creating the filters
Using the selections
Adding column prompts
8
Adding Views to Analyses and Advanced Features
Adding Views to Analyses and Advanced Features
Introduction
Adding the pivot table view
Adding the graph view
Adding the gauge view
Adding the legend view
Adding the column selector view
Adding the view selector view
Configuring the master-detail view settings
9
Measuring Performance with Key Performance Indicators
Measuring Performance with Key Performance Indicators
Introduction
Creating the KPIs and the KPI watchlists
Creating the scorecards
Creating the objectives
Creating the initiatives
Adding the perspectives
Building the strategy trees and maps
10
Creating and Configuring Dashboards
Creating and Configuring Dashboards
Introduction
Creating the dashboards
Using the Dashboard Builder
Exploring the properties of dashboard objects
Adding catalog objects to the dashboards
Creating the dashboard prompts
11
Oracle BI Best Practices
Oracle BI Best Practices
Introduction
Best practices of the Physical layer
Best practices of the Business Model and Mapping layer
Best practices of the Presentation layer
Best practices of the analyses and the dashboards
Performance and security tips
The Major Components of OBIEE 11g
The Major Components of OBIEE 11g
Introduction
The major components of OBIEE 11g
Sample processing of an analysis
Index
Index

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 folder where you can find the scripts is <ORACLE_INSTANCE>\bifoundation\OracleBIServerComponent\coreapplication_obis1\schema.

  2. The SAACCT.Oracle.sql script file is going to be used to create the Usage Tracking table. It's good to create this table...

Previous Section
End of Section 3
Next Section