Contents

List of Examples

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New

• What's New in 11.1

1 Introduction to the OLAP Java API

• OLAP Java API Overview
  • Multidimensional Concepts and the OLAP Java API
  • What Type of Data Can an Application Access Through the OLAP Java API?
  • What Can an Application Do with the OLAP Java API?
  • Context for OLAP Java API Development
• Sample Schema for OLAP Java API Examples
• Access to Data and Metadata Through the OLAP Java API
  • MDM Model in the OLAP Java API
  • Access to Data Through the OLAP Java API
  • Unique and Local Dimension Values
  • User Connection Requirements
• OLAP Java API Client Software
  • Requirements for Using the OLAP Java API Client Software
• Tasks That an OLAP Java API Application Performs
  • Task 1: Connect to the Data Store
  • Task 2: Create or Discover Metadata Objects
  • Task 3: Select and Calculate Data Through Queries
  • Task 4: Retrieve Query Results

2 Understanding OLAP Java API Metadata

• Overview of the OLAP Java API Metadata
• MdmSchema Classes
  • MdmRootSchema Class
  • MdmDatabaseSchema Class
  • MdmOrganizationalSchema Class
• MdmSource Classes
• MdmDimension Classes
  • MdmPrimaryDimension Classes
  • MdmSubDimension Classes
    • MdmDimensionLevel Class
    • MdmHierarchy Class
    • MdmLevelHierarchy Class
    • MdmValueHierarchy Class
    • MdmHierarchyLevel Class
• MdmDimensionedObject Classes
  • MdmCube Class
  • MdmMeasure Class
  • MdmAttribute Class
• Data Type and Type of MDM Metadata Objects
  • Data Type of MDM Metadata Objects
  • Getting the Data Type of an MdmSource
  • Type of MDM Metadata Objects
  • Getting the Type of an MdmSource
• Other MDM Metadata Objects
  • MdmDescriptionType Class
  • MdmModel Class

3 Discovering Metadata

• Connecting to Oracle OLAP
  • Prerequisites for Connecting
  • Establishing a Connection
    • Loading the JDBC Driver
    • Getting a Connection from the DriverManager
    • Creating a DataProvider and a UserSession
  • Closing the Connection and the DataProvider
• Overview of the Procedure for Discovering Metadata
  • Purpose of Discovering the Metadata
  • Steps in Discovering the Metadata
• Creating an MdmMetadataProvider
• Getting the MdmSchema Objects
• Getting the Contents of an MdmSchema
• Getting the Objects Owned by an MdmPrimaryDimension
  • Getting the Hierarchies and Levels of an MdmPrimaryDimension
  • Getting the Attributes for an MdmPrimaryDimension
• Getting the Source for a Metadata Object

4 Creating Metadata and Analytic Workspaces

• Overview of Creating and Mapping Metadata
• Creating an Analytic Workspace
• Creating the Dimensions, Levels, and Hierarchies
  • Creating Dimensions
  • Creating and Mapping Dimension Levels
  • Creating and Mapping Hierarchies
• Creating Attributes
• Creating Cubes and Measures
  • Creating Cubes
  • Creating and Mapping Measures
• Committing Transactions
• Exporting and Importing XML Templates
• Building an Analytic Workspace

5 Understanding Source Objects

• Overview of Source Objects
• Kinds of Source Objects
• Characteristics of Source Objects
  • Data Type of a Source
  • Type of a Source
  • Source Identification and SourceDefinition of a Source
• Inputs and Outputs of a Source
  • Inputs of a Source
  • Outputs of a Source
  • Matching a Source To an Input
• Describing Parameterized Source Objects
• Model Objects and Source Objects
  • Describing the Model for a Source
  • Creating a CustomModel - Example

6 Making Queries Using Source Methods

• Describing the Basic Source Methods
• Using the Basic Methods
  • Using the alias Method
  • Using the distinct Method
  • Using the join Method
  • Using the position Method
  • Using the recursiveJoin Method
  • Using the value Method
• Using Other Source Methods
  • Using the extract Method
  • Creating a Cube and Pivoting Edges
  • Drilling Up and Down in a Hierarchy
  • Sorting Hierarchically by Measure Values
  • Using NumberSource Methods To Compute the Share of Units Sold
  • Selecting Based on Time Series Operations
  • Selecting a Set of Elements Using Parameterized Source Objects

7 Using a TransactionProvider

• About Creating a Query in a Transaction
  • Types of Transaction Objects
  • Committing a Transaction
  • About Transaction and Template Objects
  • Beginning a Child Transaction
  • About Rolling Back a Transaction
  • Getting and Setting the Current Transaction
• Using TransactionProvider Objects

8 Understanding Cursor Classes and Concepts

• Overview of the OLAP Java API Cursor Objects
  • Creating a Cursor
  • Sources For Which You Cannot Create a Cursor
  • Cursor Objects and Transaction Objects
• Cursor Classes
  • Structure of a Cursor
  • Specifying the Behavior of a Cursor
• CursorInfoSpecification Classes
• CursorManager Class
  • Updating the CursorInfoSpecification for a CursorManager
• About Cursor Positions and Extent
  • Positions of a ValueCursor
  • Positions of a CompoundCursor
  • About the Parent Starting and Ending Positions in a Cursor
  • What is the Extent of a Cursor?
• About Fetch Sizes

9 Retrieving Query Results

• Retrieving the Results of a Query
  • Getting Values from a Cursor
• Navigating a CompoundCursor for Different Displays of Data
• Specifying the Behavior of a Cursor
• Calculating Extent and Starting and Ending Positions of a Value
• Specifying a Fetch Size

10 Creating Dynamic Queries

• About Template Objects
  • About Creating a Dynamic Source
  • About Translating User Interface Elements into OLAP Java API Objects
• Overview of Template and Related Classes
  • What Is the Relationship Between the Classes That Produce a Dynamic Source?
  • Template Class
  • MetadataState Interface
  • SourceGenerator Interface
  • DynamicDefinition Class
• Designing and Implementing a Template
  • Implementing the Classes for a Template
  • Implementing an Application That Uses Templates

A Setting Up the Development Environment

• Overview
• Required Class Libraries
• Obtaining the Class Libraries

B SingleSelectionTemplate Class

• Code for the SingleSelectionTemplate Class

Index