PacktLib: Oracle Essbase 9 Implementation Guide

Oracle Essbase 9 Implementation Guide


About the Authors

About the Reviewer



Installing Oracle Essbase

Installing the Essbase analytic server

Installing Essbase Administration Services

Starting the EAS

Installing the Essbase Add-in for Microsoft Excel

A typical network setup


Essbase Data and Design Considerations

Introduction to OLAP

Determining the data requirements

Determine data storage options

Types of Essbase applications

Creating your first Essbase application

Types of Essbase databases

Database components

Allowing duplicate member names

Create your first Essbase database

Types of Essbase users


Building the Essbase Outline

Before we begin

The Essbase outline—the foundation

Dimensions and members

Types of dimensions

Build your first outline

Member properties

Build your first data rules file

Update your outline using a rules file

Attribute dimensions

User Defined Attributes (UDA)

Dynamic Time Series

Shared members


Loading Data into Essbase

Make your data Essbase-friendly

Types of data sources

Data load methods

Building your first data load rules file

Loading data into your database

Data Load vs. Dimension Build


Calculating your Essbase Cube

Calculating your database

Calculation types explained

Essbase calculation terminology

Default database calculation script

Calc All

Calculate/Aggregate dimension

Essbase Calc commands and functions

Order of calculation

Two-Pass Calc

Using Substitution Variables

Building your first Calculation Script

Executing your Calculation Scripts


Using your Essbase Cube

Using your Essbase database

Ways to extract your Essbase data

The Essbase Report Script

Executing your report scripts

Previewing data in EAS


Getting the most out of the Microsoft Excel Add-in

Reporting with the Microsoft Excel Add-in

Using the Essbase Query Designer


Automating your Essbase Cube

Essbase command scripts (EssCmd)

Essbase MaxL scripts

Essbase Application Programming Interface (API)


Advanced Techniques

Performance tuning your database

The shape of your database outline

Database configuration settings

Partitioning databases

Analytic server configuration file

Memory management


Essbase Analytics Option

What is ASO

MDX query language

Pros and cons of ASO and BSO


Essbase System 9 Components

Overview of System 9 components


A New Essbase Companion—Oracle Smart View

A New Essbase Companion—Oracle Smart View