Go to main content
1/18
Contents
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes in This Release for Oracle OLAP Java API Developer's Guide
Changes in Oracle Database 12
c
Release 1 (12.1)
Desupported Features
1
Introduction to the OLAP Java API
1.1
OLAP Java API Overview
1.1.1
What the OLAP Java API Can Do
1.1.2
Describing the Classes in the OLAP Java API
1.1.3
Describing the Dimensional Data Model
1.1.4
Implementing the Dimensional Data Model
1.1.5
Organizing the Data for OLAP
1.2
Accessing Data Through the OLAP Java API
1.2.1
Creating Queries
1.2.2
Specifying Dimension Members
1.2.3
Creating Cursors
1.3
Sample Schema for OLAP Java API Examples
1.4
Tasks That an OLAP Java API Application Performs
2
Understanding OLAP Java API Metadata
2.1
Overview of OLAP Java API Metadata Classes
2.2
Identifying, Describing, and Classifying Metadata Objects
2.2.1
Identifying Objects
2.2.1.1
Getting and Setting Names
2.2.1.2
Describing Unique Identifiers
2.2.1.3
Supporting Legacy Metadata Objects
2.2.1.3.1
Supporting Legacy Applications
2.2.1.3.2
Describing Namespaces
2.2.2
Using Descriptions
2.2.3
Using Classifications
2.3
Providing Metadata Objects
2.3.1
Describing Metadata Providers
2.3.1.1
Getting Metadata Objects by ID
2.3.1.2
Exporting and Importing Metadata as XML Templates
2.3.1.2.1
Exporting XML Templates
2.3.1.2.2
Importing XML Templates
2.3.1.2.3
Describing Bind Variables in XML Templates
2.3.2
Representing Schemas
2.3.2.1
Representing the Root Schema
2.3.2.2
Representing Database Schemas
2.3.2.3
Representing Organizational Schemas
2.4
Providing Access to Data Sources
2.4.1
Representing Cubes and Measures
2.4.1.1
Representing Cubes
2.4.1.2
Representing Measures
2.4.2
Representing Dimensions, Levels, and Hierarchies
2.4.2.1
Representing Dimensions
2.4.2.2
Representing Dimension Levels
2.4.2.3
Representing Hierarchies
2.4.2.3.1
Representing a Level-based Hierarchy
2.4.2.3.2
Representing a Value-based Hierarchy
2.4.2.4
Representing Hierarchy Levels
2.4.3
Representing Dimension Attributes
2.4.3.1
Describing the MdmAttribute Class
2.4.3.1.1
Describing Types of Attributes
2.4.3.1.2
Associating an Attribute with an MdmSubDimension
2.4.3.1.3
Getting MdmAttribute Objects
2.4.3.1.4
Specifying a Target Dimension
2.4.3.2
Describing the MdmBaseAttribute Class
2.4.3.2.1
Specifying a Data Type
2.4.3.2.2
Grouping Attributes
2.4.3.2.3
Creating an Index
2.4.3.2.4
Specifying a Language for an Attribute
2.4.3.2.5
Specifying Multilingual Attributes
2.4.3.2.6
Populating OLAP Views with Hierarchical Attribute Values
2.4.3.2.7
Preparing Attributes for Materialized Views
2.4.3.3
Describing the MdmDerivedAttribute Class
2.4.4
Using OLAP Views
2.4.4.1
Getting Cube View and View Column Names
2.4.4.2
Getting Dimension and Hierarchy View and View Column Names
2.4.4.3
Using OLAP View Columns
2.4.4.4
Using Source Objects
3
Discovering Metadata
3.1
Connecting to Oracle OLAP
3.1.1
Prerequisites for Connecting
3.1.2
Establishing a Connection
3.1.2.1
Creating a JDBC Connection
3.1.2.2
Creating a DataProvider and a UserSession
3.1.3
Closing the Connection and the DataProvider
3.2
Overview of the Procedure for Discovering Metadata
3.2.1
Purpose of Discovering the Metadata
3.2.2
Steps in Discovering the Metadata
3.3
Creating an MdmMetadataProvider
3.4
Getting the MdmSchema Objects
3.5
Getting the Contents of an MdmSchema
3.6
Getting the Objects Contained by an MdmPrimaryDimension
3.6.1
Getting the Hierarchies and Levels of an MdmPrimaryDimension
3.6.2
Getting the Attributes for an MdmPrimaryDimension
3.7
Getting the Source for a Metadata Object
4
Creating Metadata and Analytic Workspaces
4.1
Overview of Creating and Mapping Metadata
4.2
Creating an Analytic Workspace
4.3
Creating the Dimensions, Levels, and Hierarchies
4.3.1
Creating and Mapping Dimensions
4.3.2
Creating and Mapping Dimension Levels
4.3.3
Creating and Mapping Hierarchies
4.3.3.1
Creating and Mapping an MdmLevelHierarchy
4.3.3.2
Creating and Mapping an MdmValueHierarchy
4.4
Creating Attributes
4.5
Creating Cubes and Measures
4.5.1
Creating Cubes
4.5.2
Creating and Mapping Measures
4.6
Committing Transactions
4.7
Exporting and Importing XML Templates
4.8
Building an Analytic Workspace
5
Understanding Source Objects
5.1
Overview of Source Objects
5.2
Kinds of Source Objects
5.3
Characteristics of Source Objects
5.3.1
Elements and Values of a Source
5.3.2
Data Type of a Source
5.3.3
Type of a Source
5.3.4
Source Identification and SourceDefinition of a Source
5.4
Inputs and Outputs of a Source
5.4.1
Describing the join Method
5.4.1.1
Describing the joined Parameter
5.4.1.2
Describing the comparison Parameter
5.4.1.3
Describing the comparisonRule Parameter
5.4.1.4
Describing the visible Parameter
5.4.2
Outputs of a Source
5.4.2.1
Producing a Source with an Output
5.4.2.2
Using COMPARISON_RULE_SELECT
5.4.2.3
Using COMPARISON_RULE_REMOVE
5.4.2.4
Producing a Source with Two Outputs
5.4.2.5
Hiding an Output
5.4.3
Inputs of a Source
5.4.3.1
Primary Source Objects with Inputs
5.4.3.2
Deriving a Source with an Input
5.4.3.3
Type of Inputs
5.4.4
Matching a Source with an Input
5.4.4.1
Matching the Input of the Source for an MdmAttribute
5.4.4.2
Matching the Inputs of a Measure
5.4.4.3
Using the value Method to Derive a Source with an Input
5.4.4.4
Using the value Method to Select Values of a Source
5.4.4.5
Using the extract Method to Combine Elements of Source Objects
5.5
Describing Parameterized Source Objects
6
Making Queries Using Source Methods
6.1
Describing the Basic Source Methods
6.2
Using the Basic Methods
6.2.1
Using the alias Method
6.2.2
Using the distinct Method
6.2.3
Using the join Method
6.2.4
Using the position Method
6.2.5
Using the recursiveJoin Method
6.2.6
Using the value Method
6.2.6.1
Selecting Elements of a Source
6.2.6.2
Reversing a Relation
6.3
Using Other Source Methods
6.3.1
Using the extract Method
6.3.2
Creating a Cube and Pivoting Edges
6.3.3
Drilling Up and Down in a Hierarchy
6.3.4
Sorting Hierarchically by Measure Values
6.3.5
Using NumberSource Methods To Compute the Share of Units Sold
6.3.6
Selecting Based on Time Series Operations
6.3.7
Selecting a Set of Elements Using Parameterized Source Objects
7
Using a TransactionProvider
7.1
About Creating a Metadata Object or a Query in a Transaction
7.1.1
Types of Transaction Objects
7.1.2
Committing a Transaction
7.1.3
About Transaction and Template Objects
7.1.4
Beginning a Child Transaction
7.1.5
About Rolling Back a Transaction
7.1.6
Getting and Setting the Current Transaction
7.2
Using TransactionProvider Objects
8
Understanding Cursor Classes and Concepts
8.1
Overview of the OLAP Java API Cursor Objects
8.1.1
Creating a Cursor
8.1.2
Sources For Which You Cannot Create a Cursor
8.1.3
Cursor Objects and Transaction Objects
8.2
Cursor Classes
8.2.1
Structure of a Cursor
8.2.2
Specifying the Behavior of a Cursor
8.3
CursorInfoSpecification Classes
8.4
CursorManager Class
8.4.1
Updating the CursorInfoSpecification for a CursorManager
8.5
About Cursor Positions and Extent
8.5.1
Positions of a ValueCursor
8.5.2
Positions of a CompoundCursor
8.5.3
About the Parent Starting and Ending Positions in a Cursor
8.5.4
What is the Extent of a Cursor?
8.6
About Fetch Sizes
9
Retrieving Query Results
9.1
Retrieving the Results of a Query
9.1.1
Getting Values from a Cursor
9.2
Navigating a CompoundCursor for Different Displays of Data
9.3
Specifying the Behavior of a Cursor
9.4
Calculating Extent and Starting and Ending Positions of a Value
9.5
Specifying a Fetch Size
10
Creating Dynamic Queries
10.1
About Template Objects
10.1.1
About Creating a Dynamic Source
10.1.2
About Translating User Interface Elements into OLAP Java API Objects
10.2
Overview of Template and Related Classes
10.2.1
What Is the Relationship Between the Classes That Produce a Dynamic Source?
10.2.2
Template Class
10.2.3
MetadataState Interface
10.2.4
SourceGenerator Interface
10.2.5
DynamicDefinition Class
10.3
Designing and Implementing a Template
10.3.1
Implementing the Classes for a Template
10.3.2
Implementing an Application That Uses Templates
A
Setting Up the Development Environment
A.1
Overview
A.2
Required Class Libraries
A.3
Obtaining the Class Libraries
B
SingleSelectionTemplate Class
B.1
Code for the SingleSelectionTemplate Class
Index
Scripting on this page enhances content navigation, but does not change the content in any way.