Sign in  |  Register
Advanced search
Publication Cover

CITATION

Schrader, Michael; Vlamis, Dan; Nader, Mike; Claterbos, Chris; Collins, Dave; Campbell, Mitch; and Conrad, Floyd. Oracle Essbase & Oracle OLAP. US: McGraw-Hill Osborne Media, 2009.

Oracle Essbase & Oracle OLAP

Authors: Michael Schrader, Dan Vlamis, Mike Nader, Chris Claterbos, Dave Collins, Mitch Campbell and Floyd Conrad

Published:  October 2009

eISBN: 9780071627382 0071627383 | ISBN: 9780071621823
Open eBook
  • Contents
  • Foreword
  • Acknowledgments
  • Introduction
  • 1 Introduction to OLAP
  • OLAP as a Component of Business Intelligence
  • Enterprise Performance Management
  • Data Warehousing
  • Business Reporting
  • Predictive Analytics and Data Mining
  • OLAP
  • Why OLAP?
  • Business-Focused Multidimensional Data
  • Business-Focused Calculations
  • Trustworthy Data and Calculations
  • Speed-of-Thought Analysis
  • Flexible, Self-Service Reporting
  • OLAP Primer
  • OLAP System Components
  • OLAP Types
  • OLAP Products
  • OLAP with a Data Warehouse
  • Typical OLAP Applications
  • Why Two OLAP Products from Oracle?
  • Similarities Between Essbase and Oracle OLAP
  • Differences Between Essbase and Oracle OLAP
  • OLAP Business Case Studies
  • Essbase Case Studies
  • Oracle OLAP Case Studies
  • Architecting the Appropriate OLAP Solution
  • Choosing the Solution That Meets Your Needs
  • Better Together
  • Conclusion
  • References
  • 2 OLAP Concepts and History
  • Common OLAP Themes
  • Multidimensional View of Information
  • From Data Source to Multidimensional Data
  • New Results from Existing Data
  • Ad Hoc Analysis: Having a Conversation with Your Data
  • Summary of Common OLAP Themes
  • The History of Oracle OLAP
  • Why a Multidimensional Database?
  • 1960s to 1985—Glory Days of Mainframe Express
  • 1985 to 1990—A New C-Based Engine
  • 1990 to 1996—Express Goes GUI
  • 1995 to 1997—Oracle Buys and Markets Express
  • 1998 to 2001—Integrating Express into the Oracle Database
  • 2002 to 2003—Oracle9i OLAP
  • 2004 to 2006—Oracle OLAP 10g
  • 2007 to 2009—Oracle OLAP 11g
  • 2009 and Beyond
  • The History of Essbase
  • Why Essbase?
  • 1992 to 1994—Essbase Is Born
  • 1994 to 1998—APIs and the Essbase Web Gateway
  • 1998 to 2003—New Reporting Options for Essbase
  • 2003 to 2007—Aggregate Storage and Hybrid Architecture
  • 2007 to Present—Essbase Powers Oracle EPM and BI
  • Conclusion
  • References
  • 3 Design and Overall Methodology
  • General Design Principles
  • Design Is an Iterative Process
  • User Requirements Drive Design
  • What's Left Out Is as Important as What Goes In
  • Dimension Types Offer Convenience
  • Data Types Improve Data Quality
  • Different Uses Require Different Views of the Data
  • User Access and Security Needs Planning
  • Allow Areas for Training and Testing
  • Designing an Oracle OLAP Analytic Workspace
  • Determining Dimensions from User Requirements
  • Relating Oracle OLAP Data to a Star Dimensional Model
  • Mapping Relational Data to Multidimensional Objects
  • Determining Dimensions of Cubes
  • Designing Oracle OLAP Cubes
  • Summary of the Oracle OLAP Design Process
  • Designing an Essbase Database
  • Identifying Data Sources
  • Defining the Outline
  • Validating the Outline with Business Users
  • Enhancing the Outline
  • Choosing a Data Storage
  • Considering Partition Strategies
  • Summary of the Essbase Design
  • OLAP Architectures
  • Oracle OLAP Architecture and Components
  • Essbase Architecture and Components
  • End-User Tools
  • Conclusion
  • References
  • 4 Building an Oracle OLAP Analytic Workspace
  • Oracle OLAP Demonstration Overview
  • From Source to Cubes with Analytic Workspace Manager
  • Getting Started with Analytic Workspace Manager
  • Preparing the Data
  • Creating an Analytic Workspace
  • Creating and Populating Dimensions
  • Creating and Populating Cubes
  • Summary of the Cube-Building Process
  • Adding Business-Savvy Calculations to Cubes
  • Creating a Share Calculation
  • Creating a Percent Different Prior or Parallel Period Calculation
  • Creating a Moving Average Calculation
  • Creating Custom Calculated Measures
  • Managing Calculated Measures
  • Advanced Topics
  • Managing Workspaces with OLAP Worksheet
  • Working with Cube-Organized Materialized Views
  • Managing Security of Cubes and Dimensions
  • Creating Advanced Cubes for Typical Business Purposes
  • Using SQL with OLAP
  • Conclusion
  • 5 Building Your Essbase Database
  • Demonstration Overview
  • From Source to Database with Essbase Studio
  • Overview of Essbase Studio
  • Mapping Data Sources
  • Modeling the Data Source
  • Building Dimensions (Hierarchies)
  • Modeling the Essbase Database
  • Deploying the Essbase Database
  • Summary of the Database Building Process
  • Calculating the Essbase Database
  • Validating the Essbase Database
  • Using Essbase Features
  • Creating Drill-Through Reports
  • Leveraging Lineage Tracking
  • Creating Custom Load Rules
  • Creating Member Formulas and Calculation Scripts
  • Using Essbase Query Languages for Reports
  • Automating Processes
  • Using ESSCMD
  • Using MaxL
  • Conclusion
  • 6 Reporting from an OLAP Application
  • User Discovery
  • Identifying the Consumers of OLAP Reports
  • Gathering Information About Your Users
  • Discussing the Reporting Needs of Your Users
  • Types of Reports
  • Basic Report
  • Compound Report
  • Dashboard Report
  • Production Reports
  • Interactive Management Reports
  • Ad Hoc Spreadsheet Reports
  • Custom Microsoft Office Reports
  • Desirable Functionality in Web-Based OLAP Reporting
  • Creating the Skeleton of a Report
  • Adding Functionality to a Report
  • Desirable Functionality in Desktop-Based Reporting
  • Integrated Database Connection
  • Powerful Ad Hoc Analysis Features
  • Easy Report-Creation Tools
  • Visualization
  • Understanding Deployment Options
  • Fitting in with Enterprise Standards
  • Web-Based Deployment Options
  • Desktop-Based Deployment Options
  • Third-Party Reporting Applications
  • Third-Party Reporting Tools for Oracle OLAP
  • Third-Party Reporting Tools for Essbase
  • Conclusion
  • References
  • 7 Leveraging OLAP in Your Organization
  • Performance Management Applications Leveraging Essbase
  • Oracle Hyperion Planning
  • Oracle Hyperion Profitability and Cost Management
  • Oracle Hyperion Enterprise Performance Management Architect
  • Architecture of Performance Management Applications
  • Oracle Crystal Ball with Essbase
  • Crystal Ball and Monte Carlo Simulation Methods
  • Crystal Ball Analysis
  • Crystal Ball with Planning Models
  • Crystal Ball Decision Optimizer
  • Oracle Smart Space with Essbase
  • Smart Space Desktops
  • Smart Space Gadgets
  • Software Development Kit
  • Oracle Application Express for Oracle OLAP
  • Java Development
  • Using Oracle BI Beans with Oracle OLAP
  • Connecting Java Applications to Essbase
  • Conclusion
  • References
  • 8 Keeping It Running
  • Oracle OLAP Care and Maintenance
  • Configuring and Tuning Oracle OLAP
  • Backing Up Oracle OLAP
  • Troubleshooting Oracle OLAP
  • Essbase Care and Maintenance
  • Optimizing Essbase
  • Backing Up Essbase
  • Conclusion
  • References
  • 9 Real-World Examples
  • Oracle OLAP Examples
  • Accelerating a Data Warehouse
  • Analyzing Projections
  • Analyzing Financial Data
  • Essbase Examples
  • Replacing the Excel Workbook
  • Enhancing an ERP System
  • Replacing Custom SQL Reports
  • Conclusion
  • OLAP as a Cornerstone of BI
  • References
  • Glossary
  • A
  • B
  • C
  • D
  • E
  • F
  • G
  • H
  • I
  • L
  • M
  • O
  • P
  • Q
  • R
  • S
  • T
  • U
  • V
  • X
  • Index