Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle OLAP User's Guide
- 1 Overview
- 2 Getting Started with Oracle OLAP
-
3
Creating Dimensions and Cubes
- 3.1 Designing a Dimensional Model for Your Data
- 3.2 Introduction to Analytic Workspace Manager
- 3.3 Creating a Dimensional Data Store Using Analytic Workspace Manager
-
3.4
Creating Dimensions
- 3.4.1 Requirements of a Dimension
- 3.4.2 Creating a Dimension
- 3.4.3 Creating Levels
- 3.4.4 Creating Hierarchies
- 3.4.5 Creating Attributes
- 3.4.6 Creating Measure Dimensions
- 3.4.7 Mapping Dimensions
- 3.4.8 Loading Data Into Dimensions
- 3.4.9 Displaying the Dimension View
- 3.4.10 Displaying the Default Hierarchy
- 3.5 Creating Cubes
- 3.6 Choosing a Data Maintenance Method
- 3.7 Supporting Multiple Languages
- 3.8 Defining Measure Folders
- 3.9 Saving and Re-Creating Dimensional Objects with Object Definitions
- 3.10 Copying and Pasting Dimensional Objects
-
4
Querying Dimensional Objects
- 4.1 Exploring the OLAP Views
- 4.2 Creating Basic Queries
- 4.3 Creating Hierarchical Queries
- 4.4 Using Calculations in Queries
- 4.5 Using Attributes for Aggregation
- 4.6 Joining Cubes to Tables and Views
- 4.7 Viewing Execution Plans
- 4.8 Querying the Data Dictionary
- 5 Enhancing Your Database with Analytic Content
-
6
Developing Reports and Dashboards
- 6.1 Developing OLAP Applications
- 6.2 Developing a Report Using BI Publisher
- 6.3 Developing a Dashboard Using Application Express
-
7
Administering Oracle OLAP
- 7.1 Setting Database Initialization Parameters
- 7.2 Storage Management
- 7.3 Dictionary Views and System Tables
- 7.4 Partitioned Cubes and Parallelism
- 7.5 Analyzing Cubes and Dimensions
- 7.6 Monitoring Analytic Workspaces
- 7.7 About Backing Up and Recovering Analytic Workspaces
- 7.8 About Copying Analytic Workspaces
- 7.9 About Saving Dimensional Object Definitions
- 7.10 Cube Materialized Views
- 8 Security
- 9 Advanced Aggregations
- A Designing a Dimensional Model
- B Keyboard Shortcuts
- Glossary
- Index