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 Aggregate Persistence Wizard

Designing and creating the aggregate tables is not an easy task. Especially, creating the aggregate dimension tables and aggregating the fact tables will take some time. You'll have to think about the joins as well.

There's a utility called Aggregate Persistence in BI Administration Tool. This utility will help us create the aggregate tables and load the precomputed data into them automatically. But you'll have to reflect all changes to the ETL process. Once this wizard is executed, the aggregate tables are going to be created in the database. Also, summary data will be calculated and it's going to be inserted into the aggregate tables. Obviously these tables should be imported into the BI repository and the physical joins should be created. These two steps are going to be done automatically too. The next step is reflecting the changes in the BMM Layer. Actually, Aggregate Persistence Wizard will do this task too. As a summary, it's a completely automated...

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 Aggregate Persistence Wizard