Skip Headers


Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Copyright © 2006, Oracle. All rights reserved.


Installing the Common Schema

These instructions guide you through the installation of a sample data set (known as the "common schema"). This common schema includes both relational and multidimensional (OLAP) data structures. The data in this schema is the basis for the samples and tutorials delivered with Oracle Business Intelligence Discoverer (OracleBI Discoverer), Oracle Business Intelligence Beans (OracleBI Beans), and the Oracle Business Intelligence Spreadsheet Add-in (OracleBI Spreadsheet Add-In).

Contents

What the install program does

The samples included in this installation shall not work the Oracle Database 9i Release 2.
This installation program lets you install the common schema for relational as well as OLAP data.
If you need to install these samples on an earlier supported version of the Oracle Database please use this link instead. The installation program performs the following tasks:

For relational data:

  1. It will modify certain tables in the existing 'SH' common schema to include additional data to support the tutorials.

For OLAP data:

  1. Creates a user that owns the analytic workspace. The user ID and password are the same: SH_OLAP. Note that if the SH_OLAP account exists, the account and all associated metadata will be first dropped and then recreated.
  2. Creates two analytic workspaces:
  3. Enables the analytic workspace for use by applications that leverage the Oracle OLAP API. OracleBI Beans is an example of such a technology.
  4. Creates nine new folders: three for Electronics analysis, three for Customer Analytics, and three for Brand Analytics.
  5. Moves the measures and dimensions that were enabled in the step above into these folders.
  6. Note: The SH_OLAP schema is fully specified in the 10.2 standard form and has been built using Oracle Analytic Workspace Manager (AWM). It is thus completely compatible with custom member functionality and single or multi user writeback with the Oracle Spreadsheet Add-In (SSA). It does not support the forecasting applications built with BI Beans (the Executive Insight demo). This is not supported because of limitations with the current release of the AWM with supporting fine-grain control on limiting dimensions necessary for forecasting.

Downloading the latest samples version

Before you install the common schema, you need to download the extract the latest version of the samples to the machine where you will install the samples.

  1. Create a new directory (referred to as <SAMPLE_HOME>) on the computer where Oracle Business Intelligence is installed.
  2. Download the latest version of the samples from the Oracle Technology Network (OTN) to <SAMPLE_HOME> and unzip the file.
    Note: On Windows NT/2000/XP, do not unzip the script files into a directory using long names or names that contain spaces.

Installing the schema

Installation Options

You can install the relational and OLAP common schema data separately, if you so want.

Pre-installation checklist

The following are required:

Pre-installation tasks

  1. Change to the <SAMPLE_HOME>/samples/common_schema directory.
  2. Set your ORACLE_HOME environment variable to the your Oracle database home. This is the database where you will be installing the common schema. You can use the echo command to verify that the environment variables have been set correctly.
  3. Set the ORACLE_SID environment variable to the SID for the target database instance. For example on Windows platforms:

Installation steps - relational

If you only want to install the relational samples, perform these steps, only after downloading the samples as described above.

  1. Navigate to the <SAMPLE_HOME>/common_schema folder.
  2. Run install_rel.bat (on Unix you need to run install_rel.sh).
  3. For example:
                   c:\samples\common_schema> install_rel

    Note: The install file to be run is under the samples\common_schema folder. Do not run any file in the 'disco' or 'olap' sub-folders.
              This script does not take any parameters.

Installation steps - OLAP

If you only want to install the OLAP samples, perform these steps only after downloading the samples as described above.

  1. Install the relational samples first, as described above in the 'Installation Steps - Relational' section.
  2. Navigate to the <SAMPLE_HOME>/common_schema folder.
  3. Run install_olap.bat (on Unix you need to run install_olap.sh) using the following two parameters:

For example:
c:\samples\common_schema> install_olap c:\orahome1\oradata\myservice c:\samples\common_schema
Note: The install file to be run is under the samples\common_schema folder. Do not run any file in the 'disco' or 'olap' sub-folders.

Installation steps - complete

If you want to install both the relational and OLAP schemas, you should run the complete installation script. This script runs the relational installation followed by the OLAP installation. Perform these steps only after downloading the samples as described above.

  1. Run install_all.bat (on Unix install_all.sh) using the following two parameters:

For example:
c:\samples\common_schema> install_all c:\orahome1\oradata\myservice c:\samples\common_schema
Note: The install file to be run is under the samples\common_schema folder. Do not run any file in the 'disco' or 'olap' sub-folders.

Errors during installation

It is normal to have errors displayed during the installation process. This is because the script drops common schema objects that may already be existing. If these do not exist there will be error messages displayed.

Uninstalling the schema

Note: The uninstall script must run on the same machine as the database.

Uninstall steps

  1. Go to the <SAMPLE_HOME>/common_schema/olap directory.
  2. Run uninstall.bat using the same parameters as the install script: (run uninstall.sh on Unix)

  3. For example:
    uninstall c:\orahome1\oradata\myservice c:\samples\common_schema

The uninstall script removes the following:

The script creates a log file named drop.log.


Copyright © 2006 Oracle Corporation
All Rights Reserved