Oracle Business Intelligence 11g R1 Cookbook

Here’s an opportunity to learn all the key elements of the OBIEE 11g suite by doing tasks rather than just reading. Packed with practical recipes, it empowers you to create complex analytical reports with minimum effort.

Oracle Business Intelligence 11g R1 Cookbook

Cookbook
Cuneyt Yilmaz

Here’s an opportunity to learn all the key elements of the OBIEE 11g suite by doing tasks rather than just reading. Packed with practical recipes, it empowers you to create complex analytical reports with minimum effort.
$32.99
$54.99
RRP $32.99
RRP $54.99
eBook
Print + eBook
$12.99 p/month

Want this title & more? Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.
Code Files
+ Collection
Free sample

Book Details

ISBN 139781849686006
Paperback364 pages

About This Book

  • Improve the productivity of business intelligence solution to satisfy business requirements with real-life scenarios
  • Practical guide on the implementation of OBIEE 11g from A to Z including best practices
  • Full of useful instructions that can be easily adapted to build better business intelligence solutions

Who This Book Is For

If you are a business analyst, BI administrator or developer working with Oracle Business Intelligence 11g R1 then this book is exactly what you have been looking for. Hands on practical examples, real world solutions and best practices make this book an essential guide for Oracle BI. Clear a space on your desk as you won't want this handy reference to be too far away.

Table of Contents

Chapter 1: 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
Chapter 2: Working with Logical Dimensions
Introduction
Creating level-based hierarchies
Creating parent-child hierarchies
Creating level-based measures
Creating shared measures
Creating presentation hierarchies
Chapter 3: 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
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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
Chapter 8: 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
Chapter 9: 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
Chapter 10: 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
Chapter 11: 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

What You Will Learn

  • Understand the architecture of the Oracle BI Server
  • Explore the three layers of the repository and learn how to implement complex business rules
  • Build a secure, well-designed repository for the BI Server
  • Work with multidimensional sources to improve the performance of the analyses
  • Create the simple analyses and use advanced features of the analyses
  • Measure the productivity by implementing Key Performance Indicators
  • Customize dashboards to support your business requirements
  • Build a BI solution based on the best practices

In Detail

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.

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.

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.

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.

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.

Authors

Table of Contents

Chapter 1: 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
Chapter 2: Working with Logical Dimensions
Introduction
Creating level-based hierarchies
Creating parent-child hierarchies
Creating level-based measures
Creating shared measures
Creating presentation hierarchies
Chapter 3: 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
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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
Chapter 8: 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
Chapter 9: 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
Chapter 10: 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
Chapter 11: 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

Book Details

ISBN 139781849686006
Paperback364 pages
Read More

Recommended for You