Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Hardware and Software Requirements

• Supported Platforms
  • Oracle Linux Notes
• Hardware Requirements
• Software Requirements
  • Oracle Database Requirements
  • Oracle Business Intelligence Suite Enterprise Edition
• Platform Specific Requirements
  • AIX Platform Requirements: Database and Configuration Parameters

2 Introduction to Oracle Retail Data Model Installation

• Types of Installations Provided for Oracle Retail Data Model
  • Retail Data Model Installation
  • Sample Reports Installation
• Oracle Retail Data Model Home Directory Structure
• Overview of the Installation Process

3 Installation of Oracle Retail Data Model

• Pre-installation Tasks
  • Ensuring that Required Software is Installed
    • Confirming that Oracle Data Mining and OLAP Options are Installed
    • Confirming that Oracle Business Intelligence Suite Enterprise Edition is Installed
  • Ensuring that Required Software Patches are Installed
    • Install OLAP C PATCH FOR 11.2.0.3.0
  • Changing the Default Value for the Maximum Processes Initialization Parameter
  • Changing the Maximum Data Files Option
  • Disabling the Data Vault Option on the Database
  • Ensuring That a Value is Set for the Service Name
• Installer Execution
• Silent Installation
  • Selecting a Response File
  • Editing the Response File
  • Specifying a Response File and Starting the Installation
  • Silent Installation Log Files
  • Security Tips for Silent Installations
  • Error Handling
• Post-Installation Tasks
  • Unlocking the ORDM_SYS Account
  • Unlocking the ORDM_SAMPLE Account
  • Recompiling OLAP Views
  • Limiting User Privileges for Sample Reports
  • Running OLAP Builds to Load Data into Analytical Workspace
  • Re-Enabling the Vault Option on the Database
  • Ensuring That Oracle Retail Data Model Objects Are Valid
  • Ensuring That PGA_AGGREGATE_TARGET is Set to the Proper Value
  • Installing OBIEE Suite Catalog for Oracle Retail Data Model
  • Installing RPD and WebCat for OBIEE

4 Installation of Additional Components

• Installing and Configuring Workflow
  • Installing Oracle Warehouse Builder and Integrating with Oracle Workflow
  • Installing Oracle Warehouse Builder OWBSYS Schema
  • Creating Oracle Warehouse Builder Workspace for Oracle Retail Data Model
  • Importing Oracle Retail Data Model Intra-ETL into Workflow
  • Configuring Oracle Warehouse Builder Workflow
• Creating an Oracle Business Intelligence Suite Enterprise Edition Catalog
• Installing Analytic Workspace Manager

5 Backup, Recovery, and Deinstallation of Oracle Retail Data Model

• Backing Up and Recovering Oracle Retail Data Model
  • Exporting Oracle Retail Data Model
  • Importing Oracle Retail Data Model
• Overview: Deinstalling Oracle Retail Data Model
• Pre-Deinstallation Tasks
• Deinstallation Script Execution

A Configuration Steps for OBIEE 11g

• Setting Up Users, Groups and Application Roles for ORDM OLAP in OBIEE 11g

B License Information

Index