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

Creating the multidimensional Business Model

Creating a Business Model for cubes is easier than RDBMS tables. Actually, the structure of cubes is very similar to the Business Models. Cubes contain dimensions and measures. We can see that structure in the Physical layer as well.

Dimensions and their levels are already created in the cubes. Measures are also specified in the cubes. So all required object definitions already exist in the cubes.

How to do it...

First step will be creating a blank Business Model in the BMM layer. Then we're just going to drag-and-drop a cube from the Physical layer onto the new Business Model. At this step, all logical dimensions and fact tables will be created automatically, plus dimensions and their hierarchies are also created in only one step.
Now we're going to clean up the Forecast Business Model. Unneeded columns should be removed from the model. Product Type - Memnor and Product Type - Member Key columns will be removed in the following screenshot:
We're going...

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

Creating the multidimensional Business Model

How to do it...