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

Accessing members and member counts

It's important to understand the structure of the data in the cubes such as those in RDBMS tables. You can easily access the data from BI Administration Tool.

How to do it...

When you right-click on the cube, you'll see View Members. A new window pops up that will display the number of members. Also you're going to see the distinct values. This result set is accessed from the multidimensional source.

How it works...

BI Server generates an MDX query so that it displays the number of attribute values. MDX and SQL languages are used to query databases. SQL statements are used to construct a relational view. MDX generates multidimensional views that consist of multiple-dimension attributes in the result set. While the SQL statements use tables as sources, MDX uses Cubes. The structure of the MDX statement is composed of the following clauses:

WITH (optional): It allows calculated members to be computed during the processing
SELECT: It identifies the dimension...

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

Accessing members and member counts

How to do it...

How it works...