Contents

Title and Copyright Information

Send Us Your Comments

Preface

Conventions

Documentation Accessibility

1 Learning the Basics

Why OLAP?

The Oracle OLAP Solution

Building Analytical Applications

Managing OLAP Services

2 Developing OLAP Applications

The Java Solution

Introducing the BI Beans

Understanding the OLAP API

Data Storage Alternatives

3 Administering an OLAP Service

Managing the Service Environment

Introducing OLAP Services Instance Manager

Starting OLAP Services

Stopping or Pausing OLAP Services

Acquiring System Administration Privileges

Changing the Configuration Settings

Unlocking Database Identities

Managing Sessions

Viewing Status Messages

Creating New Services

Command-line Administration

Granting Access Rights to Users

Configuring Instance Manager

Configuring OLAP Services Agent

4 Configuring Your Data Warehouse

Your Data Warehouse

Transforming Tables into Multidimensional Data Structures

Database Requirements

Creating Metadata

Defining Dimensions

Defining Cubes

Viewing Cubes

Defining Measure Folders

Modifying the Metadata

Creating Materialized Views

5 Localization

Introduction

About Oracle Globalization Technology

Understanding Encoding Schemes

Introduction to Character Sets

Choosing an Instance Character Set

Identifying the Locale

Supported Languages and Territories

Supported Character Sets

6 Tuning

Evaluating Your Installation

Setting the Server Mode

Configuring the Hardware

Tuning Your Data Warehouse

Monitoring Performance

A Upgrading from Express Server

Upgrading Express Databases

Support for Applications

Administration Methods

Localization Support

Index