Oracle 9i OLAP Services. Concepts and Administration Guide

The Oracle 9i OLAP Services Concepts and Administration Guide describes how to use Oracle OLAP Services (hereinafter referred to as “OLAP Services”) for business analysis. It introduces the concepts underlying analytical applications and multidimensional querying, and the tools used for application development and system administration.This guide provides some information that is specific to Unix platforms. If you are using OLAP Services on a Windows system, refer to the Oracle 9i OLAP Services Concepts and Administration Guide for Windows. It is located on the Oracle 9i Windows installation CD.

---

Table of contents :
Send Us Your Comments……Page 7
Preface……Page 9
Conventions……Page 11
Documentation Accessibility……Page 12
Why OLAP?……Page 13
The Oracle OLAP Solution……Page 15
Building Analytical Applications……Page 16
Managing OLAP Services……Page 18
The Java Solution……Page 21
Introducing the BI Beans……Page 25
Understanding the OLAP API……Page 29
Data Storage Alternatives……Page 31
3 Administering an OLAP Service……Page 33
Managing the Service Environment……Page 34
Introducing OLAP Services Instance Manager……Page 35
Starting OLAP Services……Page 37
Stopping or Pausing OLAP Services……Page 40
Acquiring System Administration Privileges……Page 41
Changing the Configuration Settings……Page 43
Unlocking Database Identities……Page 46
Managing Sessions……Page 49
Viewing Status Messages……Page 50
Creating New Services……Page 53
Command-line Administration……Page 55
Configuring Instance Manager……Page 59
Configuring OLAP Services Agent……Page 60
4 Configuring Your Data Warehouse……Page 63
Your Data Warehouse……Page 64
Transforming Tables into Multidimensional Data Structures……Page 66
Database Requirements……Page 70
Creating Metadata……Page 72
Defining Dimensions……Page 75
Defining Cubes……Page 78
Viewing Cubes……Page 80
Defining Measure Folders……Page 81
Modifying the Metadata……Page 84
Creating Materialized Views……Page 85
Introduction……Page 91
About Oracle Globalization Technology……Page 92
Understanding Encoding Schemes……Page 93
Introduction to Character Sets……Page 95
Choosing an Instance Character Set……Page 96
Identifying the Locale……Page 98
Supported Languages and Territories……Page 99
Supported Character Sets……Page 101
Evaluating Your Installation……Page 109
Configuring the Hardware……Page 110
Tuning Your Data Warehouse……Page 111
Monitoring Performance……Page 114
Upgrading Express Databases……Page 117
Support for Applications……Page 119
Localization Support……Page 121
Index……Page 123