Free Sample
+ Collection

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

Starting
Christian Screen, Haroun Khan, Adrian Ward

Utilizing the full potential of the Oracle Business intelligent Enterprise Edition is in easy reach with this tutorial. From first principles right through to developing your own tools, it’s the complete guide for beginners and intermediates.
$35.99
$59.99
RRP $35.99
RRP $59.99
eBook
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849685665
Paperback620 pages

About This Book

  • Get to grips with the OBIEE 11g suite for analyzing and reporting on your business data
  • Immerse yourself in BI upgrading techniques, using Agents and the Action Framework and much more in this book and e-book
  • A practical, from the coalface tutorial, bursting with step by step instructions and real world case studies to help you implement the suite’s powerful analytic capabilities

Who This Book Is For

If you are a BI developer or analyst who wants to get practical with your OBIEE 11g knowledge, "Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial" is for you. You will also find it helpful as a technical administrator, consultant or end user.

You should already have a good command of general BI practices and Oracle database, but no knowledge of Oracle BI 11g is required.

Table of Contents

Chapter 1: 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
Chapter 2: Installing the Metadata Repository
Repository Creation Utility (RCU)
Running the RCU
A review – what I should now know!
Summary
Chapter 3: Installing on Windows Server 2008
Installation media
System requirements
Installation
A review – what I should now know!
Summary
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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
Chapter 8: 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
Chapter 9: Features of the Presentation Catalog
Integrated tools
The Home screen
Administration
The Presentation Catalog
A review – what I should now know!
Summary
Chapter 10: 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
Chapter 11: Agents and the Action Framework
Agents
Actions
A review – what I should now know!
Additional research suggestions
Summary
Chapter 12: 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
Chapter 13: 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
Chapter 14: Improving the Performance
What is poor performance?
A review – what I should now know!
Summary
Chapter 15: 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
Chapter 16: Usage Tracking
What is usage tracking?
System setup
A review – what I should now know!
Summary
Chapter 17: 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

What You Will Learn

  • Run though a full sample upgrade from a 10g repository using the upgrade assistants
  • Discover valuable best practices for designing a reporting database
  • Go further with your dashboard knowledge by implementing changes to standard colors, graphics and messages
  • Demonstrate how Agent options affect report delivery
  • Quickly get up and running with BI Publisher and learn to publish reports with bursting and scheduling
  • Speed up your OBIEE system with performance best practices such as Scale out and Caching
  • Go beyond out of the box solutions and develop great management tools
  • Make your knowledge stick by ending each chapter with a self review and further learning resources

In Detail

The Oracle Business Intelligence Enterprise Edition 11g (OBIEE) suite delivers a full range of analytic and reporting capabilities, coupled with powerful user experience for creating reports, dashboards and more with your business data. "Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial" will have you unleashing that power in no time, helping you to take action and make the right decisions ataglance.

"Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial" provides you with valuable insight and the step-by-step know-how you need to take advantage of everything the Oracle BI suite has to offer you, all utilizing real world case studies for a true implementation in action.

"Oracle Business Intelligence Enterprise Edition 11g: A Hands- on Tutorial" takes you on a journey right from inception to a full working OBI 11g System. Using a real-world data walkthrough you’ll explore topics like architecture, reporting and leveraging Essbase as a data source, as well as building the Oracle BI 11g metadata repository (RPD), and developing reports and dashboards in the new Fusion Middleware interface. This practical implementation guide equips you with from the coalface advice which will help you achieve a successful working application by journey’s end.

Authors

Read More