Oracle Business Intelligence and Essbase Solutions Guide: 1st Edition (Hardback) book cover

Oracle Business Intelligence and Essbase Solutions Guide

1st Edition

By Rosendo Abellera, Lakshman Bulusu

Auerbach Publications

216 pages | 110 B/W Illus.

Purchasing Options:$ = USD
Hardback: 9781482234077
pub: 2016-12-12
SAVE ~$14.99
eBook (VitalSource) : 9781315373188
pub: 2016-11-30
from $37.48

FREE Standard Shipping!


This book highlights the practical aspects of using Oracle Essbase and Oracle Business Intelligence Enterprise Edition (OBIEE) as a comprehensive BI solution. It explains the key steps involved in Oracle Essbase and OBIEE implementations. Using case studies, the book covers Oracle Essbase for analytical BI and data integration, using OBIEE for operational BI including presentation services and BI Publisher for real-time reporting services, Self-service BI– in terms of VLDB, scalability, high performance, stability, long-lasting and ease of use that saves time, effort, and costs, while maximizing ROI.

Table of Contents


A Basic Business Need

What Is Business Intelligence?

Why BI?

Enabling a Competitive Advantage

BI and Reporting Categories


Why Oracle Essbase Now

OBIEE and Essbase: History and Importance

Why Essbase Now: From History to Historical,

Analytical, and Beyond


Oracle Essbase and Oracle BI: Successful Players and Products

The Primary Vendors: Inventors and Presenters

The Primary Products and Tools Set: Inclusions and Exclusions

The Primary Users: Evaluators, Investors, Implementers and Eventual Benefiters


Analysis, Evaluation, and Selection

Essential Criteria for Requirements Analysis of Oracle Essbase and OBIEE as a Comprehensive

BI Solution

Key and Critical Deciding Factors in Selecting Such a Solution

The Final Pick is a Customer-Centric Solution:

Key Indicator Checklist


Data Integration, Implementation, and Customization Using Essbase

Building an Integrated Approach for Data

Implementation Specifics of Data, from Data Source to Data Analytics

Semantic Integration between OBIEE and Essbase, Using OBIEE as a Data Source for

Oracle Essbase

Extending and Customizing Essbase


Using Essbase for Analytical BI


What Kind of Analytics Are Good for Essbase


Implementation Specifics of Using Analytical BI Using Essbase


Using OBIEE for Operational BI

Don’t Let Your Tool Wag Your Data

Categories for Business Intelligence and Reporting

What Is Operational Business Intelligence?

Delivering Operational BI

The Operational Data Store Option

Using OBIEE for Self-Service BI

In Search of Self-Service BI

Enter OBIEE as a Solution

OBIEE for Self-Service BI

Big Data and Self-Service BI

Best Practices for Solution Implementation and Customization

Establishing a Data Foundation Based on a Logical Model

Extending the Logical Data Model for Implementation and Customization

The Logical Model as a Scalable Best Practice Solution

Use Case Scenarios

The Challenge

The Resolution

The Prize for the Price: A Win–Win or Not

The True Value of Expertise

Data-Driven Development

A 360-Degree View of a Holistic Solution

Oracle Big Data and the Cloud for Analytics

Using the Cloud To Unleash the Potential of Big Data

Oracle’s Role in Cloud Services and Big Data

Beyond BI


Slides from Data Warehouse Architectures

Overview of the Corporate Information Factory and Dimensional Modeling

Slides from OBIEE 12c Presentation

Oracle Data Sheets


About the Authors

From military intelligence to business intelligence, Rosendo Abellera has made a lifelong career out of utilizing data as a critical asset. His early career in software development began with several commercial software packages across various industries and business areas, including work order management, telecom billing, prescription refill, and even voter registration. This extensive hands-on experience of developing data-driven applications has contributed heavily to his expertise and proven, successful approach to Business Intelligence (BI) and Analytics solutions development. As an early adopter and pioneer of BI coupled with modern data warehousing (DW) approaches and technologies, he has successfully architected DW and BI solutions from the ground up for leading companies, including AAA, Comcast, John Hancock Financial, Koch Industries, LexisNexis, Mercury Systems, and State Street Bank. Additionally, Rosendo has consulted a multitude of leading organizations across various industries both in the government and commercial realm. As a DW and BI Subject Matter Expert (SME) and proven successful practitioner, he has held key management positions to establish the DW and BI practices of several major, prolific consulting organizations. A consummate entrepreneur, he has founded DW and BI irms including a former Oracle Partner as well as a Big Data Analytics company.

Lakshman Bulusu is a Senior Oracle Consultant with 23 years of experience in the fields of Oracle RDBMS, SQL, PL/SQL, EDW/BI/EPM, and Oracle-related Java. As an Enterprise-level data warehouse, and business intelligence solution architect/technical manager in the ORACLE RDBMS space, he focused on a best-fit solution architecture and implementation of the Oracle Industry Data Model for telecom. He has worked for major clients in the pharma/healthcare, telecom, financial (banking), retail, and media industry verticals, with special emphasis on cross-platform heterogeneous information architecture and design. He has published eight books on Oracle and related technologies, all published in the United States, as well as four books on English poetry. He serves on the development team of and Qteria Big Data Analytics. Bulusu is OCPcertified and holds an Oracle Masters credential. He was selected as a FOCUS Expert for his research briefs titled "Raising your ‘SIQ’ (Social Intelligence Quotient): 5 Key Business Indicators," "Raising your ‘BIQ’ (Business Intelligence Quotient): 5 Things Your Company Can Do NOW," and "High- Fives for an Innovative HR Strategy" on He has written a host of technical articles and spoken at major Oracle conferences in the United States and abroad. He can be reached at

Subject Categories

BISAC Subject Codes/Headings:
BUSINESS & ECONOMICS / Information Management
COMPUTERS / Database Management / General
COMPUTERS / Information Technology