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

Introduction

The implementation process of Oracle Business Intelligence Enterprise Edition 11g should be very well planned and designed not to have a failed project. Every single step of this implementation is very crucial and any kind of mistake is going to impact the other dependent tasks. We should always focus on business requirements and also analyze technical features of the product in order to see the gap. We need to start with the business requirements and then we are going to drill down to the technical features. We're not going to discuss how to analyze the business needs in this book. Instead, technical details are going to be discussed.

In this chapter, we're going to cover the best practices of the OBIEE 11g. You will find useful recommendations about every layer of the implementation starting from the Physical layer of the repository to the dashboards.

Also you will find useful tips about performance and security in this chapter.

Before starting this recipe, we assume that the...

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

Introduction