Skip Headers
Oracle® OLAP Reference
10
g
Release 2 (10.2.0.3)
Part Number B14350-02
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
List of Examples
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Active Catalog Views
Understanding the Active Catalog
Summary of Active Catalog Views
ALL_OLAP2_AWS
ALL_OLAP2_AW_ATTRIBUTES
ALL_OLAP2_AW_CATALOGS
ALL_OLAP2_AW_CATALOG_MEASURES
ALL_OLAP2_AW_CUBES
ALL_OLAP2_AW_CUBE_AGG_LVL
ALL_OLAP2_AW_CUBE_AGG_MEAS
ALL_OLAP2_AW_CUBE_AGG_OP
ALL_OLAP2_AW_CUBE_AGG_SPECS
ALL_OLAP2_AW_CUBE_DIM_USES
ALL_OLAP2_AW_CUBE_MEASURES
ALL_OLAP2_AW_DIMENSIONS
ALL_OLAP2_AW_DIM_HIER_LVL_ORD
ALL_OLAP2_AW_DIM_LEVELS
ALL_OLAP2_AW_PHYS_OBJ
ALL_OLAP2_AW_PHYS_OBJ_PROP
2
OLAP Dynamic Performance Views
V$ Tables for OLAP
Summary of OLAP Dynamic Performance Views
V$AW_AGGREGATE_OP
V$AW_ALLOCATE_OP
V$AW_CALC
V$AW_LONGOPS
V$AW_OLAP
V$AW_SESSION_INFO
3
DBMS_AW
Managing Analytic Workspaces
Converting an Analytic Workspace to Oracle 10
g
Storage Format
Procedure: Convert an Analytic Workspace to the Latest Storage Format
Procedure: Import a workspace from a 9
i
Database into a 10
g
Database
Embedding OLAP DML in SQL Statements
Methods for Executing OLAP DML Commands
Guidelines for Using Quotation Marks in OLAP DML Commands
Using the Sparsity Advisor
Data Storage Options in Analytic Workspaces
Selecting the Best Data Storage Method
Using the Sparsity Advisor
Example: Evaluating Sparsity in the GLOBAL Schema
Advice from Sample Program
Information Stored in AW_SPARSITY_ADVICE Table
Using the Aggregate Advisor
Aggregation Facilities within the Workspace
Example: Using the ADVISE_REL Procedure
Summary of DBMS_AW Subprograms
ADD_DIMENSION_SOURCE Procedure
ADVISE_CUBE Procedure
ADVISE_DIMENSIONALITY Function
ADVISE_DIMENSIONALITY Procedure
ADVISE_PARTITIONING_DIMENSION Function
ADVISE_PARTITIONING_LEVEL Function
ADVISE_REL Procedure
ADVISE_SPARSITY Procedure
AW_ATTACH Procedure
AW_COPY Procedure
AW_CREATE Procedure
AW_DELETE
AW_DETACH Procedure
AW_RENAME Procedure
AW_TABLESPACE Function
AW_UPDATE Procedure
CONVERT Procedure
EVAL_NUMBER Function
EVAL_TEXT Function
EXECUTE Procedure
GETLOG Function
INFILE Procedure
INTERP Function
INTERPCLOB Function
INTERP_SILENT Procedure
OLAP_ON Function
OLAP_RUNNING Function
PRINTLOG Procedure
RUN Procedure
SHUTDOWN Procedure
SPARSITY_ADVICE_TABLE Procedure
STARTUP Procedure
4
DBMS_AW_XML
Analytic Workspace Java API Overview
Oracle OLAP XML Schema
Summary of DBMS_AW_XML Subprograms
EXECUTE Function
EXECUTEFILE Function
5
OLAP_API_SESSION_INIT
Initialization Parameters for the OLAP API
Viewing the Configuration Table
ALL_OLAP_ALTER_SESSION View
Summary of OLAP_API_SESSION_INIT Subprograms
ADD_ALTER_SESSION Procedure
CLEAN_ALTER_SESSION Procedure
DELETE_ALTER_SESSION Procedure
6
OLAP_CONDITION
OLAP_CONDITION Overview
Entry Points in the Limit Map
Dynamically Modifying a Workspace during a Query
OLAP_CONDITION Examples
OLAP_CONDITION Syntax
7
OLAP_EXPRESSION
OLAP_EXPRESSION Overview
Single-Row Functions
OLAP_EXPRESSION and OLAP_TABLE
OLAP_EXPRESSION Examples
OLAP_EXPRESSION Syntax
8
OLAP_EXPRESSION_BOOL
OLAP_EXPRESSION_BOOL Overview
Single-Row Functions
OLAP_EXPRESSION_BOOL and OLAP_TABLE
OLAP_EXPRESSION_BOOL Example
OLAP_EXPRESSION_BOOL Syntax
9
OLAP_EXPRESSION_DATE
OLAP_EXPRESSION_DATE Overview
Single-Row Functions
OLAP_EXPRESSION_DATE and OLAP_TABLE
OLAP_EXPRESSION_DATE Syntax
10
OLAP_EXPRESSION_TEXT
OLAP_EXPRESSION_TEXT Overview
Single-Row Functions
OLAP_EXPRESSION_TEXT and OLAP_TABLE
OLAP_EXPRESSION_TEXT Syntax
11
OLAP_TABLE
OLAP_TABLE Overview
Limit Maps
Logical Tables
Using OLAP_TABLE With Predefined ADTs
Using OLAP_TABLE With Automatic ADTs
Using a MODEL Clause
OLAP_TABLE Examples
Example: Creating Views of Embedded Total Dimensions
Example: Creating Views of Embedded Total Measures
Example: Creating Views in Rollup Form
Using OLAP_TABLE with the FETCH Command
OLAP_TABLE Syntax
Analytic Workspace Parameter
Table Object Parameter
OLAP Command Parameter
Limit Map Parameter
Order of Processing in OLAP_TABLE
Index