PacktLib: Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial

Oracle Business Intelligence Enterprise Edition 11: A Hands-On Tutorial

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Preface

Understanding the Oracle BI 11 Architecture

Looking backward and looking forward

Let's look at the big picture

What is Oracle Fusion Middleware?

An application server by any other name

A database repository – for what?

Overall components

WebLogic Server

Oracle Process Management and Notification system

Security

System requirements

Scaling out Oracle BI 11

Directory folder structure

A review – what I should now know!

Additional research suggestions

Summary

Installing the Metadata Repository

Repository Creation Utility (RCU)

Running the RCU

A review – what I should now know!

Summary

Installing on Windows Server 2008

Installation media

System requirements

Installation

A review – what I should now know!

Summary

Installation Options

Oracle BI on its own server

Simple versus Software Only Installation

Custom static ports

Installing Oracle BI 11 on *Nix

Listening on port 80

Automate starting and stopping

Ancillary application integration awareness

Recommendations for further learning

A review – what I should now know!

Summary

Understanding the Systems Management Tools

Let's talk about management tools

WebLogic Server Administration Control

Using WLST

Enterprise Manager Fusion Middleware Control

Creating the Tennis users, roles, and associations

Configuring an LDAP identity provider in WLS

JMX, MBeans, and Java

Migrating FMW Security to other environments

Oracle BI Publisher system management

Monitoring system performance

Have a backup plan!

Recommendations for further learning

A review – what I should now know!

Summary

Upgrading the RPD and Web Catalog to 11

Upgrading an RPD and Web Catalog

Upgrade Assistant

Verification

Upgrading BI Scheduler

Manual migration

Consistency check

Security

Regression testing

A review – what I should now know!

Summary

Reporting Databases

Theories and models

Designing your database – objectives, rules, and goals

Creating a warehouse

Some definitions

A review – what I should now know!

Summary

Developing a BI Repository

Prerequisites

Repository architecture

Physical layer

Business layer

Presentation layer

Calculated measures

Federated and fragmented content

Variables and initialization blocks

A review – what I should now know!

Additional research suggestions

Summary

Features of the Presentation Catalog

Integrated tools

The Home screen

Administration

The Presentation Catalog

A review – what I should now know!

Summary

Creating Dashboards and Analysis

Analysis versus Reporting

Creating an Analysis

Building Dashboards

Some advanced options

Security

Design – best practices

Additional research suggestions

A review – what I should now know!

Summary

Agents and the Action Framework

Agents

Actions

A review – what I should now know!

Additional research suggestions

Summary

Developing Reports Using BI Publisher

Don't miss the installation integration checkpoint!

Where BI Publisher excels?

Yes, BI Publisher is now Published Reporting

Oracle BI Foundation versus Oracle BI Publisher

New features and enhancements

Report design basics, terminology, and locations

Let's get publishing

Auditing and monitoring BI Publisher

BI Publisher nuances

A review – what I should now know!

Additional research suggestions

Summary

Customizing the Style of Dashboards

What's the idea?

Multiple skins and styles in one environment

A strategy for something seemingly simple

General knowledge and tools

Third-party tools

Hands-on – go time!

Developing/designing a new look and feel

Advanced learning topics

A review – what I should now know!

Summary

Improving the Performance

What is poor performance?

A review – what I should now know!

Summary

Using the BI Admin Change Management Utilities

Problems with multiple developers

Merges

Multi-User development

A review – what I should now know!

Additional research suggestions

Summary

Usage Tracking

What is usage tracking?

System setup

A review – what I should now know!

Summary

Oracle Essbase and OLAP Integration

A bit about OLAP

Oracle Essbase Studio

Oracle BI SampleApp v107+ – VM image

Getting started – let's get set up

Modeling Essbase into Oracle BI

Federation of data

Oracle BI/EPM roadmap

A review – what I should now know!

Additional research suggestions

Summary

Programs and Definitions

Programs and Definitions

Programs and Definitions

Programs and Definitions

Programs and Definitions

Programs and Definitions

Useful Resources: Join the Oracle BI Movement

Useful Resources: Join the Oracle BI Movement

Useful Resources: Join the Oracle BI Movement

Useful Resources: Join the Oracle BI Movement

Useful Resources: Join the Oracle BI Movement

Useful Resources: Join the Oracle BI Movement

Useful Resources: Join the Oracle BI Movement

Index