OracIe9i OLAP Services Concepts and Administration Guide for Windows

The Oraclc9i OLAP Services Concepts and Administration Guide for Windows describes how to use Oracle OLAP Services (hereinafter referred to as “OLAP Services”) for business analysis. It introduces the concepts under lying analytical applications and multidimensional querying, and the tools used for application development and system administration.This guide provides some information that is specific to Windows platforms. If you are using OLAP Services on a Unix system, refer to the 0raclc9i OLAP Services Concepts and Administration Guide (Part Niunber A88755-01). It is located on the Oracle9i documentation CD.This manual is intended for application developers and database administrators who are responsible for providing analytical services.

---

Table of contents :
Contents……Page 3
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
Granting Access Rights to Users……Page 59
Configuring Instance Manager……Page 60
Configuring OLAP Services Agent……Page 61
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 79
Defining Measure Folders……Page 81
Modifying the Metadata……Page 83
Creating Materialized Views……Page 85
Introduction……Page 89
About Oracle Globalization Technology……Page 90
Understanding Encoding Schemes……Page 91
Introduction to Character Sets……Page 93
Choosing an Instance Character Set……Page 94
Identifying the Locale……Page 96
Supported Languages and Territories……Page 97
Supported Character Sets……Page 99
Evaluating Your Installation……Page 107
Setting the Server Mode……Page 108
Configuring the Hardware……Page 109
Tuning Your Data Warehouse……Page 110
Monitoring Performance……Page 113
Upgrading Express Databases……Page 115
Support for Applications……Page 117
Localization Support……Page 119
Index……Page 121