Oracle Business Intelligence 11g R1 Cookbook

Oracle Business Intelligence 11g R1 Cookbook

By : Cuneyt Yilmaz

Buy this Book

Oracle Business Intelligence 11g R1 Cookbook

By: Cuneyt Yilmaz

Buy this Book

Overview of this book

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.

Oracle Business Intelligence 11g R1 Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

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

Working with Logical Dimensions

Introduction

Creating level-based hierarchies

Creating parent-child hierarchies

Creating level-based measures

Creating shared measures

Creating presentation hierarchies

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

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

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

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

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

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

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

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

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

Introduction

The major components of OBIEE 11g

Sample processing of an analysis

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Using the Dashboard Builder

The Dashboard Builder is a tool that will be used to modify the dashboards. We're going to learn how to access the Dashboard Builder and also we're going to explore the properties of the dashboards.

How to do it...

Click on the Sales dashboard from the Dashboards menu to navigate to the Sales dashboard.
The Sales dashboard is going to be displayed on the screen and you'll see that there's no content in it.
There are two ways to open the Dashboard Builder. If the dashboard doesn't contain any object, you can click on the Edit link to navigate to the Dashboard Builder.
If there are objects already published in the dashboard then you can click and expand the properties menu and then select the Edit Dashboard link.
After using one of the methods, Dashboard Builder will be displayed. You will see that there are two panes in the left section:
- Dashboard Objects: These are the objects that can be used in the dashboards to extend the functionality of the dashboard.
- Catalog:...

Oracle Business Intelligence 11g R1 Cookbook

By : Cuneyt Yilmaz

Oracle Business Intelligence 11g R1 Cookbook

By: Cuneyt Yilmaz

Overview of this book

Related Content you might be interested in

Current Title:

Oracle Business Intelligence 11g R1 Cookbook

Using the Dashboard Builder

How to do it...