Oracle OLAP 11g Sample Schema

Sample Schema Installation Instructions

Date: 23-Dec-2009

Introduction

This document explains how to install the sample schema that is used for Oracle OLAP 11g collateral: Oracle by Examples, samples, etc. The installation must take place on the same computer that contains Oracle Database 11g. The user performing the installation must have DBA privileges.

There are two parts to the installation:

  1. Install the base "OLAPTRAIN" schema that contains the source data for the cube
  2. Create the cubes that are derived from the source data

You will always need to perform step 1 - which installs the base schema. Only perform step 2 if you are not interested in learning how to build cubes (e.g. you do not plan to do the Oracle by Example that shows how to create cubes using Analytic Workspace Manager).

Software Requirements
  • Oracle Database 11g (patch 11.1.0.7 or higher) with Oracle OLAP Option enabled

Installation Instructions

T he installation routine(s) performs the following tasks:

  1. Creates two tablespaces: dm and dm_archive
  2. Creates the OLAPTRAIN user (and drops the user if it already exists)
  3. Uses Oracle Data Pump to import the information found in the included dump file
  4. (Optional) Creates the SALESTRACK analytic workspace containing the sales and forecast cube in the OLAPTRAIN schema (and drops the analytic workspace if it already exists). The data will be loaded and aggregated.

Installing the base OLAPTRAIN schema

  1. Create a directory on the computer where Oracle Database 11g is installed. This directory will be referred to as [install_home]
  2. Download and unzip olaptrain_install.zip into this directory
  3. Change to the [install_home]/olaptrain_install directory
  4. Log in to SQL*Plus as a dba user
  5. Ensure that there are no existing OLAPTRAIN users connected to the database. Otherwise, the attempt to drop the user will fail.
  6. At the SQL*Plus prompt, run @install_olaptrain. Follow the directions at the SQL*Plus prompts

For example:

> cd [install_home]/olaptrain_install
> sqlplus / as sysdba

SQL> @install_olaptrain

This procedure installs the OLAPTRAIN schema for the Oracle OLAP 11g
training class, samples and Oracle by Examples.

1. You should be logged on as a DBA to execute this procedure.
2. Ensure any existing OLAPTRAIN user sessions are disconnected before proceding
with the installation (this install will recreate the user if it exists)

Example:
c:\download\olaptrain_install or /home/oracle/olaptrain_install


Directory: [install_home]/olaptrain_install

Specify a password for the OLAPTRAIN user.
Password: password

Installing the SALESTRACK analytic workspace in the OLAPTRAIN schema

  1. Ensure no user has an existing SALESTRACK analytic workspace open in the OLAPTRAIN schema (it will be recreated).
  2. Change to the [install_home]/olaptrain_install directory
  3. Log in to SQL*Plus as a dba user
  4. At the SQL*Plus prompt, run @create_olaptrain_cubes. Follow the directions at the SQL*Plus prompts

The cubes and dimensions are now available for query.

For example:

> cd [install_home]/olaptrain_install
> sqlplus / as sysdba

SQL> @create_olaptrain_cubes

Specify file system directory containing this installation program.

Example:
c:\download\olaptrain_install or /home/oracle/olaptrain_install

Directory: [install_home]/olaptrain_install

Specify a password for the OLAPTRAIN user.
Password: password

Left Curve
Popular Downloads
Right Curve
Untitled Document
Left Curve
More Database Downloads
Right Curve