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

Implementing aggregate tables

In order to improve query performance, we have created aggregate tables at the database level. Now we're going to modify the Physical and BMM layers of the repository to gain benefit of summary data.

  • Physical layer: Aggregate tables should be imported and physical joins should be created

  • Business Model and Mapping layer: Secondary logical table sources are going to be added to the corresponding logical tables

  • Presentation layer: No modification will be made at this layer. Usage of aggregate tables will be transparent to the end users

How to do it...

  1. As we have already demonstrated how to import tables into the Physical layer in Chapter 1, Exploring and Building the Repository, you won't find every detailed step in this task. Here is the screenshot that shows the imported tables.

  2. The physical joins between the fact table and all three dimensions tables should be created. The first physical join is between FACT_SALES_AGG and DIM_SUBTYPE_AGG tables. The join condition...

Previous Section
End of Section 4
Next Section