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

Exploring the table view properties

We already noticed that the Title and Table views are added to Compound Layout when the Analysis is first created. According to business requirements, we may need to modify the Table view properties. For example, Subtotals and Grand Totals are not displayed in the default layout. Some additional modifications can be performed in the Table views:

  • Table prompts

  • Sections

  • Subtotals and Grand Totals

  • Excluded columns

How to do it...

  1. We're going to create a simple analysis and click on the Results tab in the Analysis Editor. You will see that the Title and the Table views are added by default. You'll need to click on the Pencil icon to open the table view editor.

  2. When the table view editor is opened, you'll see the Layout section below the Results section. The results will be automatically previewed according to the settings that you've changed. The Layout section is divided into four parts:

    • Table Prompts

    • Sections

    • Table - Columns and Measures

    • Excluded

  3. We're going...

Previous Section
End of Section 4
Next Section