PacktLib: Oracle Essbase 9 Implementation Guide

Oracle Essbase 9 Implementation Guide

Credits

About the Authors

About the Reviewer

Acknowledgements

Preface

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

Summary

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

Summary

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

Summary

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

Summary

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

Summary

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

Summary

Getting the most out of the Microsoft Excel Add-in

Reporting with the Microsoft Excel Add-in

Using the Essbase Query Designer

Summary

Automating your Essbase Cube

Essbase command scripts (EssCmd)

Essbase MaxL scripts

Essbase Application Programming Interface (API)

Summary

Advanced Techniques

Performance tuning your database

The shape of your database outline

Database configuration settings

Partitioning databases

Analytic server configuration file

Memory management

Summary

Essbase Analytics Option

What is ASO

MDX query language

Pros and cons of ASO and BSO

Summary

Essbase System 9 Components

Overview of System 9 components

Summary

A New Essbase Companion—Oracle Smart View

A New Essbase Companion—Oracle Smart View