This page gets you straight to the software so you can be up and running with Oracle OLAP Option as quickly as possible.


To get started with Oracle OLAP Option follow these five simple steps:

1) Decide which database version you want to work with 10g Release 2 or 11g Release 1 (for a feature review of both versions, click here) and then download and install the 10g Release 2 or 11g Release 1 Enterprise Edition database for your platform, and the relevant Client CD if using a non-Windows platform.
2) Download and install a design client:

• Analytic Workspace Manager and/or
• Warehouse Builder

3) Install the Global demo sample schema for 10g Release 2 or 11g Release 1
4) Use the Oracle OLAP Training Material
5) Review recommended additional reading material

Stage 1 - Download Database Software

Installation Guides
Once you have downloaded the correct software image(s) for your platform please refer to the

10g Release 2
Quick Installation Guide for Linux x86 is here.
Quick Installation Guide for Microsoft Windows (32 Bit) is here.
For other platforms the complete 11g documentation Library is here.

11g Release 1
Quick Installation Guide for Linux x86 is here.
Quick Installation Guide for Microsoft Windows (32 Bit) is here.
For other platforms the complete 11g documentation Library is here.

The various software patches are accompanied by a README.HTML file that documents how to prepare and install the patch as well as how to uninstall the patch if required. Please Note : The OLAP Option is only supported as part of the Enterprise Edition version of the database. It will not work with Standard Edition or Express.

Oracle OLAP 10g Release 2 Enterprise Edition Software
10g Database Enterprise Edition can be downloaded from here, and you will only need to download the image for the database (and if you want to run AWM on a non-Windows platform you will also need the Client image as well) and this can be accessed from here, (http://www.oracle.com/technology/software/products/database/index.html):

Windows Required Patches
10.2.0.3 patch for Windows can be downloaded from Metalink. The patch number is 5337014
10.2.0.3 OLAP A Patch for Windows can be download fromMetalink. The patch number is 5948242

Linux Required Patches
10.2.0.3 patch for Linux can be downloaded from Metalink. The patch number is 5337014
10.2.0.3 OLAP A Patch for Linux can be download fromMetalink. The patch number is 5948242

Other platforms are also provided. For more information see the OLAP Platform Certification Matrix which is available here.

Oracle OLAP 11g Release 1 Enterprise Edition Software
11g Database Enterprise Edition can be downloaded from here, and you will only need to download the image for the database and client and these can be accessed from here, (http://www.oracle.com/technology/software/products/database/index.html):

Windows Required Patches
11.0.6 OLAP A Patch for Windows can be download from Metalink. The patch number is6459753

Linux Required Patches
11.0.6 OLAP A Patch for Windows can be download from Metalink. The patch number is6459753

Stage 2 - Design Tools to Support Oracle OLAP

Analytic Workspaces are the storage object used by Oracle OLAP. The two most popluarways to design and build an analytic workspace are:

• Analytic Workspace Manager
• Warehouse Builder

This section will provide details on how to download and install Analytic Workspace Manager. For more information on Oracle Warehouse Builder please goto the Warehouse Builder Wiki page which can be accessed from here.

Analytic Workspace Manager (AWM)
AWM is a simple tool that allows you to quickly and easily design and build an AW. AWM is provided free with the Oracle database and does not require additional licences beyond those for the OLAP Option. AWM uses a “design-time at run-time” approach so as you create objects they are automatically visible within the AW. This contrasts with the approach used by Warehouse Builder, which requires a deployment phase to create objects within the database.

For more information on AWM click here and see the entry marked Analytic Workspace Manager

AWM 10g (10.2.0.3A) Software Download
Windows :Analytic Workspace Manager 10.2.0.3 A (Windows only client) can be downloaded from here. The associated readme for the installation process is here.
Other Platforms :For all other platforms Analytic Workspace Manager 10.2.0.3 is installed from the Database Client CD.

AWM 11g Software Download
Windows :Analytic Workspace Manager 11.0.6 (Windows only client) can be downloaded from here. The associated readme for the installation process is here.
Other Platforms :For all other platforms Analytic Workspace Manager 10.2.0.3 is installed from the Database Client CD.

Stage 3 - Install GLOBAL Demo Sample Schema

10g Release 2
Sample schema, GLOBAL, can be downloaded from here. and the readme for the installation process is here

11g Release 1
Sample schema, GLOBAL, can be downloaded from here. and the readme for the installation process is here

Stage 4 - Oracle OLAP Training Material

Using Analytic Worspace Manager 10.2.0.3
This is a viewlet that demonstrates how to use Analytic Workspace Manager. The viewlet should work in most browsers. Click here to launch the viewlet.


Oracle By Example : Populating Your OLAP Analytic Workspace Using Analytic Workspace Manager
In this tutorial, you create a 10g Release 2 analytic workspace usingwith logical dimensions and cube objects using Analytic Workspace Manager (AWM). The tutorial takes approximately 45 minutes and consists of the following topics

• Overview
• Scenario
• Prerequisites
• Setup
• Creating an Analytic Workspace
• Defining Dimensions
• Defining Levels
• Defining Hierarchies
• Reviewing Your Attributes
• Using Templates
• Defining Cubes
• Creating Measures
• Mapping to Relational Sources
• Loading Data in the Analytic Workspace
• Summary

You can access this tutorial by clicking here.

Oracle By Example : Querying OLAP Data Using Oracle BI Enterprise Edition Answers
Oracle Business Intelligence Suite Enterprise Edition 10g, Release 3 (BI EE 10g) delivers significant new product enhancements to further enable enterprise-wide BI, including integration with Oracle OLAP. In this release, Oracle's native multidimensional data model -- the analytic workspace (AW) -- is made accessible to BI EE 10gby creating the required metadata in Oracle BI Administration Tool. The AW data is exposed to the BI EE 10gproduct stack, and the OLAP engine is leveraged for analysis of that data.
Access of Oracle OLAP data is enabled by performing a 3-step process. Each step in the process is covered by a lesson in this section of the Oracle by Example series. You learn how to: prepare an AW for access by BI EE 10g; create the required metadata using Oracle BI Adminstration Tool; and create analytic reports of AW data using Oracle BI Answers.
These lessons are designed for completion in the order that is shown below. Each subsequent lesson depends on the completion of the previous lesson. Click on any of the links below to begin.

Lesson 1: Preparing an Analytic Workspace for Access by Oracle BI EE 10g
Lesson 2: Creating BI EE 10g Metadata for the Analytic Workspace
Lesson 3: Querying OLAP Data Using Oracle BI Answers

Stage 5 -Recommended Reading Material

Documentation Links
10g Release 2 Documentation

Documentation Title	Target Audience	HTML Link	PDF Link
OLAP Developer's Guide to the OLAP API	Developer	Click here	Click here
OLAP Java API Reference (Javadoc)	Developer	Click here
OLAP Application Developer's Guide	Developer/DBA	Click here	Click here
OLAP Analytic Workspace Java API Reference (Javadoc)	Developer	Click here
OLAP DML Reference	Developer/DBA	Click here	Click here
OLAP Reference	DBA	Click here	Click here

11g Release 1 Documentation

Documentation Title	Target Audience	HTML Link	PDF Link
OLAP Users Guide	Developer/DBA	Click here	Click here
OLAP DML Reference	Developer/DBA	Click here	Click here
OLAP API Developer's Guide	Developer	Click here	Click here
OLAP Java API Reference (JavaDoc)	Developer	Click here

Product and General Feature Information
Improve SQL Based Business Intelligence Tools with Oracle OLAP 11g
This technical white paper provides an overview of the features and benefits of using Oracle OLAP Option 11g to improve the performance of SQL query based business intelligence products such as Business Objects, Microstategy, Cognos and Oracle BI EE.

Oracle OLAP 11g Datasheet
Explains the features and benefits companies can gain from using the OLAP Option 11g.

Developing Analytic Workspace Manager Plug-ins 10.2.0.3
This technical note describes how to create a Java plug-in for use with Oracle Analytic Workspace Manager, Version 10.2.0.3.0. With a plug-in, a Java developer can extend the functionality of Analytic Workspace Manager (AWM).

New Features and Performance Advances in Oracle OLAP 10g Release 2
This white paper explains the features and benefits of Oracle OLAP 10g Release 2

Analytic Workspace Manager 10g
Analytic Workspace Manager is a tool in which the dimensional model can be defined, implemented, and managed throughout its lifecycle. It is designed to be accessible by the full range of possible users, from application developers and IT professionals, to departmental DBAs and line-of-business power users.
Oracle OLAP 10g Datasheet

Leveraging Business Intelligence Tools
There are two sections to this paper. This first reviews the architecture and capabilities of the OLAP option to the Oracle10g Database. It will focus on the multidimensional engine and data types, and how applications can with them. The first section will also discuss the problem information fragmentation in more detail. The second part of the paper demonstrates how several different types of tools commonly used in a business intelligence system can use a single database instance containing a single copy of the data and the business rules.

Oracle Warehouse Builder 10gR2 and Oracle OLAP
The aim of this whitepaper is to review how Oracle Warehouse Builder 10gR2 can help companies successfully implement new projects and extend existing projects to include OLAP (multi-dimensional) data models.


Oracle OLAP Blog
The aim of the Oracle OLAP blog is to try and feature anything and everything related to Oracle's database OLAP Option. Our aim is to provide information for both novice and advanced OLAP users. Below are a list of workshops that have been posted to the blog.

OLAP Workshop 1 : Basic OLAP ConceptsOLAP Workshop 2 : Understanding OLAP TechnologyOLAP Workshop 3 : Building an Analytic WorkspaceOLAP Workshop 4 : Managing Different Types of HierarchiesOLAP Workshop 5 : Building CubesOLAP Workshop 6 : Advanced Cube DesignOLAP Workshop 7 : Creating Calculated Measures