Oracle Business Intelligence and Essbase Solutions Guide  book cover
1st Edition

Oracle Business Intelligence and Essbase Solutions Guide

ISBN 9781315373188
Published November 30, 2016 by Auerbach Publications
216 Pages 110 B/W Illustrations

FREE Standard Shipping

What are VitalSource eBooks?

Prices & shipping based on shipping country


Book Description

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


View More



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 [email protected]