Index

A B C D E F G H I J L M N O P Q R S T U V W X

A

AggregationCommand objects

example of creating, 4.5.1

alias method

description, 6.1

example of, 6.2.1

Analytic Workspace Manager, 1.1.2

analytic workspaces

building, 1.1.2

building, example of, 4.8

creating, 4.2

sample, 1.2

ancestors attribute

method for getting, 2.4.2.2

appendValues method

example of, 6.2.2

application, typical tasks performed by, 1.5

assigned values

specified by an Assignment, 5.6.1

Assignment objects

of a Model, 5.6.1

asymmetric result set, Cursor positions in an, 8.5.2

at method, example of, 6.3.3

AttributeMap objects

creating, 4.3.2

attributes

based on a database column, 2.5.3

creating, 4.4

definition, 1.1.1

example of mapping, 4.3.2

mapping, 4.4

MdmAttribute objects, 2.5.3

AW objects

creating, 4.2

AWCubeOrganization objects

example of creating, 4.5.1

AWM

see Analytic Workspace Manager

AWPrimaryDimensionOrganization objects

creating, 4.3.1

B

base Source

definition, 5.3.2, 6.1

BaseExample11g.java, 1.2

Boolean OLAP Java API data type, 2.6.1

BuildAW11g.java, 1.2

building analytic workspaces, 1.1.2

example of, 4.8

BuildItem objects

creating, 4.8

BuildProcess objects

creating, 4.8

C

class libraries, obtaining, A.3

ColumnExpression objects

creating, 4.3.2

committing transactions, 4.6

COMPARISON_RULE_ASCENDING

example of, 6.2.5, 6.3.4

COMPARISON_RULE_ASCENDING_NULLS_FIRST

example of, 6.2.5

COMPARISON_RULE_ASCENDING_NULLS_LAST

example of, 6.2.5

COMPARISON_RULE_DESCENDING

example of, 6.2.3

COMPARISON_RULE_DESCENDING_NULLS_LAST

example of, 6.2.5

COMPARISON_RULE_REMOVE

example of, 5.4.2, 5.4.2, 6.2.3, 6.2.4

COMPARISON_RULE_SELECT

example of, 5.4.2, 5.4.2

CompoundCursor objects

getting children of, example, 9.1.1

navigating for a crosstab view, example, 9.2, 9.2

navigating for a table view, example, 9.2

positions of, 8.5.2

Connection objects

example of closing, 3.1.3

example of creating, 3.1.2

connections

closing, 3.1.3

prerequisites for, 3.1.1

steps for establishing, 3.1.2

ConsistentSolveCommand objects

example of creating, 4.5.1

Context11g.java, 1.2

createListSource method

example of, 5.5, 6.3.1, 6.3.6, 6.3.6

createParameterizedSource method

example of, 5.5

createRangeSource method, example of, 6.2.4

createSource method, 5.5

example of, 5.5, 6.3.2, 6.3.7

createSQLCursorManager method, 8.4

crosstab view

example of, 6.2.1

navigating Cursor for, example, 9.2, 9.2

CubeDimensionalityMap objects

creating, 4.5.2

CubeMap objects

creating, 4.5.2

cubes

creating, 4.5.1

definition, 1.1.1

example of, 6.3.2

current position in a Cursor, definition, 8.5

Cursor objects

created in the current Transaction, 8.1.3

creating, example of, 6.3.2, 9.1

current position, definition, 8.5

CursorManager objects for creating, 8.4

extent calculation, example, 9.4

extent definition, 8.5.4

faster and slower varying components, 8.2.1

fetch size definition, 8.6

getting children of, example, 9.1.1

getting the values of, examples, 9.1.1

parent starting and ending position, 8.5.3

position, 8.5

Source objects for which you cannot create, 8.1.2

span, definition, 8.5.3

specifying fetch size for a table view, example, 9.5

specifying the behavior of, 8.2.2, 9.3

starting and ending positions of a value, example of calculating, 9.4

structure, 8.2.1

CursorInfoSpecification interface, 8.3

CursorManager class, 8.4

CursorManager objects

closing before rolling back a Transaction, 7.2

creating, example of, 6.3.2, 9.1

updating the CursorManagerSpecification, 8.4.1

CursorPrintWriter.java, 1.2

CursorSpecification class, 8.3

CursorSpecification objects

getting from a CursorManagerSpecification, example, 9.3

CustomModel class, 5.6.1

CustomModel objects

example of, 5.6.2

inputs of, 5.6.1

outputs of, 5.6.1

parent Model objects of, 5.6.1

D

data store

definition, 1.1.2

exploring, 3.2.1

gaining access to data in, 3.2

scope of, 3.2

data type

of MDM metadata objects, 2.6.1

of Source objects, 5.3.1, 5.3.1

OLAP Java API, 2.6.1

data warehouse, 1.1.2

DataProvider objects

creating, 3.1.2.3

needed to create MdmMetadataProvider, 3.3

Date OLAP Java API data type, 2.6.1

derived Source objects

definition, 5.2

dimension levels

mapping, 4.3.2

dimensioned Source

definition, 5.4.1

dimensions

creating, 4.3

definition, 1.1.1

dimensioning measures, 2.4

MdmDimension classes, 2.4

MdmDimension objects, 4.3

value formatting, 1.3.3

distinct method

description, 6.1

example of, 6.2.2

div method, example of, 6.3.5

DML

Model object, 5.6.1, 5.6.1

Double OLAP Java API data type, 2.6.1

drilling in a hierarchy, example of, 6.3.3

DriverManager objects, 3.1.2.2

dynamic queries, 10.1

dynamic Source objects

definition, 5.2

example of getting, 10.3.2

produced by a Template, 10.1.1

DynamicDefinition class, 10.2.5

E

edges of a cube

creating, 4.3

definition, 1.1.1

pivoting, example of, 6.3.2

elements

of an MdmMeasure, 2.5.2

Empty OLAP Java API data type, 2.6.1

empty Source objects

definition, 5.2

ETT tool, 1.1.2

example programs

analytic workspace, 1.2

examples.zip, 1.2

sample schema for, 1.2

examples.zip, 1.2

executing a BuildProcess, 4.8

exportFullXML method

example of, 4.7

exporting XML templates, 4.7

Expression objects

creating, 4.3.2

example of, 4.5.2

ExpressSQLCursorManager class, 1.5.4

ExpressTransactionProvider class, 7.2

extent of a Cursor

definition, 8.5.4

example of calculating, 9.4

use of, 8.5.4

extract method, 5.4.1

description, 6.3.1

example of, 5.5, 6.3.1, 6.3.6, 6.3.6

implemented as a CustomModel, 5.6.2

extraction input

definition, 5.4.1

F

faster varying Cursor components, 8.2.1

fetch size of a Cursor

definition, 8.6

example of specifying, 9.5

reasons for specifying, 8.6

findOrCreateAttributeMap method, 4.3.2

findOrCreateBaseAttribute method, 4.4

findOrCreateDimensionLevel method, 4.3.2

findOrCreateMemberListMap method, 4.3.2

Float OLAP Java API data type, 2.6.1

font conventions

OLAP Java API data types, 2.6.1

fromSyntax method, Preface, 4.3.2

fundamental Source objects

definition, 5.2

FundamentalMetadataObject class, 2.6.1

FundamentalMetadataProvider class, 2.6.1

G

generated SQL, getting, 8.1

getAncestorsAttribute method

of an MdmHierarchy, 2.4.2.2

getDefaultMetadataProvider method

example of, 3.3

getEmptySource method, 5.2

example of, 5.4.2, 5.4.2, 5.4.3

getID method

of a Source, 5.3.3

getID method, example of, 5.5

getInputs method, 5.4.1

getLevelAttribute method, example of, 6.2.4

getOutputs method

of a Source, 5.4.2

getParentAttribute method

of an MdmHierarchy, 2.4.2.2

getSource method

example of, 3.7, 6.2.4, 6.3.3

for getting Source produced by a Template, example, 10.3.2

in DynamicDefinition class, 10.1.1, 10.2.5

of an MdmSource, 2.3

getType method

of a Source, 5.3.2

of an MdmSource, example of, 2.6.4

getVoidSource method, 5.2

Global schema for example programs, 1.2

GLOBAL_AWJ sample analytic workspace, 1.2

H

hierarchical sorting, example of, 6.3.4

hierarchies

creating, 4.3.3

definition, 1.1.1

I

identification

of a Source, 5.3.3

importing XML templates, 4.7

inputs

of a CustomModel, 5.6.1

of a Model, 5.6.1

of a Source

definition, 5.4.1

matching to a Source, 5.4.2, 5.4.3

obtaining, 5.4.1

producing, 5.4.1

Integer OLAP Java API data type, 2.6.1

interval method, example of, 6.3.7

isSubType method, example of, 5.3.2

J

Java archive (jar) files, required, 3.1, A.2

Java Development Kit, version required, A.2

JDBC

Connection objects, 3.1.2.2

DriverManager objects, 3.1.2.2

libraries required, A.2

loading drivers, 3.1.2.1

join method

description, 6.1

examples of, 6.2

examples of using different comparison rules, 6.2.3

rules governing matching a Source to an input, 5.4.3

L

lag method, example of, 6.3.6

levels

creating, 4.3.3

definition, 1.1.1

MdmDimensionLevel objects, 2.4.2.1

MdmHierarchyLevel objects, 2.4.2.5

list Source objects

definition, 5.2

local dimension value, 1.3.3

M

mapping

dimension levels, 4.3.2

hierarchy levels, 4.3.3

measures, 4.5.2

matching a Source to an input

example of, 5.4.2, 5.4.3, 5.4.3, 5.4.3

rules governing, 5.4.3

MDM. See multidimensional metadata model

MdmAttribute objects

creating, 4.4

description, 2.5.3

MdmAttributeModel class

subclass of MdmDimensionedObject, 2.7.2

MdmAttributeModel objects

not having parent Model objects, 5.6.1

MdmBaseAttribute objects

creating, 4.4

example of mapping, 4.3.2

mapping, 4.4

MdmBaseMeasure objects

creating, 4.5.2

MdmCube class

description, 2.5.1

MdmCube objects

example of creating, 4.5.1

MdmDatabaseSchema objects

creating, 4.2

definition, 2.2.2

MdmDimension classes

description, 2.4

MdmDimension objects

creating, 4.3

example of getting related objects, 3.6.1, 3.6.2

introduction, 1.3.2

related MdmAttribute objects, 2.4

MdmDimensionCalculationModel class, 2.7.2, 2.7.2

MdmDimensionCalculationModel objects

not having parent Model objects, 5.6.1

MdmDimensionedObject class

description, 2.5

MdmDimensionedObject object, 2.7.2

MdmDimensionedObjectModel class, 2.7.2

MdmDimensionLevel objects

creating, 4.3.2

description, 2.4.2.1

MdmHierarchy class, 2.4.2.2

MdmHierarchy objects

creating, 4.3.3

MdmHierarchyLevel objects

creating, 4.3.3

description, 2.4.2.5

mapping, 4.3.3

MdmLevelHierarchy objects

creating, 4.3.3

description, 2.4.2.3

MdmMeasure objects

creating, 4.5.2

description, 2.5.2

elements, 2.5.2

introduction, 1.3.2

kinds of values, 2.5.2

MdmMeasureModel

subclass of MdmDimensionedObject, 2.7.2

MdmMeasureModel objects

parent Model objects of, 5.6.1

MdmMetadataProvider objects

creating, 3.3

description, 3.3

introduction, 1.3.1

MdmModel class, 2.7.2

MdmObject class, 2.1

MdmOrganizationalSchema objects

definition, 2.2.3

introduction, 1.3.1

MdmPrimaryDimension objects

creating, 4.3.1

description, 2.4.1, 2.4.1, 2.4.2.4

MdmRootSchema objects

description, 2.2.1

MdmSchema objects

description, 2.2

getting contents of, 3.5

MdmSource objects, 2.3

MdmStandardDimension objects

creating, 4.3.1

description, 2.4.1

MdmSubDimension class, 2.4.2

MdmTable objects

creating, 4.5.2

MdmTimeDimension objects

creating, 4.3.1

description, 2.4.1

MeasureMap objects

creating, 4.5.2

measures

based on a database column, 2.5.2

creating, 4.5.2

definition, 1.1.1

dimensioned by dimensions, 1.1.1, 2.4

MdmMeasure objects, 2.5.2

MemberListMap objects

creating, 4.3.2

members

of an MdmDimension, 2.4

of an MdmDimensionLevel, 2.4.2.1

metadata

creating, 4.1

creating a provider, 3.3

definition, 1.1.2

discovering, 3.2

distinguished from data, 1.3

mapping, 4.1

top-level objects, 2.2.2

MetadataState class, 10.2.3

example of implementation, 10.3.1

Model interface, 2.7.2, 5.6.1

description, 5.6.1

movingTotal method, example of, 6.3.6

multidimensional metadata model (MDM)

description, 2.1

introduction, 1.3.1

N

nested outputs

getting values from a Cursor with, example, 9.1.1

of a Source, definition, 9.1.1

null Source objects

definition, 5.2

nullSource method, 5.2

Number OLAP Java API data type, 2.6.1

NumberParameter objects

example of, 6.3.7

O

ojdbc5.jar file, 3.1, A.3

OLAP Java API

definition, 1.1

required class libraries, A.2

sample schema for examples, 1.2

software components, 1.4

OLAP Java API data types

font conventions, 2.6.1

for MDM metadata objects, 2.6.1

OLAP metadata, 1.1.2

OLAP metadata objects, 1.3

olap_api_doc.jar file, A.3

olap_api.jar file, A.3

Oracle OLAP Java API Reference

location in installation, A.3

Oracle Technology Network (OTN), 1.2

ORACLE_HOME environment variable, A.3

outputs

getting from a CompoundCursor, example, 9.1.1

getting from a CompoundCursorSpecification, example, 9.3

getting nested, example, 9.1.1

in a CompoundCursor, 8.2.1, 8.5.4

positions of, 8.5.2

of a CustomModel, 5.6.1

of a Source

definition, 5.4.2

obtaining, 5.4.2

order of, 5.4.3, 6.2.1

producing, 5.4.2

P

package MdmAttribute, 2.5.3

Parameter objects

description, 5.5

example of, 5.5, 6.3.2, 6.3.7

parameterized Source objects

definition, 5.2

description, 5.5

example of, 5.5, 6.3.2, 6.3.7

parent attribute

method for getting, 2.4.2.2

parent Model objects

of a CustomModel, 5.6.1

of a Model, 5.6.1

parent-child relationships

in hierarchies, 2.4.2.2

in levels, 2.4.2.1, 2.4.2.5

pivoting cube edges, example of, 6.3.2

placeholder Source objects

definition, 5.2

position method, 5.4.1

description, 6.1

example of, 6.2.4

positions

CompoundCursor, 8.5.2

Cursor, 8.5

parent starting and ending, 8.5.3

ValueCursor, 8.5.1

precedence

of an Assignment, 5.6.1

primary Source objects

definition, 5.2

from MdmSource objects, 2.3

result of getSource method, 3.7

Q

Qualification objects

of an Assignment, 5.6.1

queries

creating using Source methods, 6

definition, 1.1.1

dynamic, 10.1

Source objects that are not, 8.1.2

steps in retrieving results of, 9.1

Query class, 1.1.1

Query objects

creating, 4.5.2

R

range Source objects

definition, 5.2

read Transaction object, 7.1.1

recursiveJoin method

description, 6.1

example of, 6.2.5, 6.3.4

regular input

definition, 5.4.1

relational

schema, 1.1.2, 2.2.2

rotating cube edges, example of, 6.3.2

S

sample analytic workspace, 1.2

sample schema

used by examples, 1.2

schemas

getting MdmDatabaseSchema for, 4.2

represented by MdmDatabaseSchema objects, 2.2.2

star, 1.1.2

selecting

by position, 6.3.7

by time series, 6.3.6

selectValue method

example of, 6.2.2, 6.3.1

selectValues method

example of, 6.2.6, 6.3.2

sessions

creating a UserSession object, 3.1.2.3

setExpression method, 4.3.2

setKeyExpression method, 4.3.2

setQuery method, 4.3.2

setSQLDataType method, 4.4

setValue method

example of, 5.5, 6.3.2, 6.3.7

setValueDescriptionAttribute method, 4.4

Short OLAP Java API data type, 2.6.1

SID (system identifier), 3.1.2.2

SingleSelectionTemplate class, 7.1.5, 7.2, 10.3.2, B.1

slower varying Cursor components, 8.2.1, 8.5.2

sorting hierarchically, example of, 6.3.4

Source class

basic methods, 6.1

Source objects

active in a Transaction object, 8.1.3

data type

definition, 5.3.1

getting, 5.3.1

dimensioned, 5.4.1

getting a modifiable Source from a DynamicDefinition, 10.2.5

identification String

obtaining, 5.3.3

inputs of

definition, 5.4.1

matching to a Source, 5.4.2, 5.4.3

obtaining, 5.4.1

producing, 5.4.1

kinds of, 5.2

methods of getting, 5.2

modifiable, 10.1

outputs of

definition, 5.4.2

obtaining, 5.4.2

producing, 5.4.2

parameterized, 5.5

SourceDefinition for, 5.3.3

specifying value of an Assignment, 5.6.1

subtype

definition, 5.3.2

obtaining, 5.3.2

type

definition, 5.3.2

obtaining, 5.3.2

SourceDefinition, 5.3.3

SourceGenerator class, 10.2.4

example of implementation, 10.3.1

span of a value in a Cursor

definition, 8.5.3, 9.4

SQL

getting generated, 8.1

Model clause, 5.6.1, 5.6.1

SQLCursorManager class, 1.5.4, 8.4

SQLDataType objects

example of, 4.5.2

example of creating, 4.4

star schema, 1.1.2

String OLAP Java API data type, 2.6.1

StringParameter objects

example of, 5.5, 6.3.2

subtype of an Source object

definition, 5.3.2

obtaining, 5.3.2

T

table view

navigating Cursor for, example, 9.2

Template class, 10.2.2

designing, 10.3

example of implementation, 10.3.1

Template objects

classes used to create, 10.2

for creating modifiable Source objects, 10.1

relationship of classes producing a dynamic Source, 10.2.1

Transaction objects used in, 7.1.3

templates

exporting XML, 4.7

importing XML, 4.7

time series, selecting based on, 6.3.6

times method, example of, 6.3.5

TopBottomTemplate class, 7.1.5, 7.2, 10.3.1

top-level metadata objects, 2.2.2

Transaction objects

child read and write, 7.1.1

committing, 4.6, 7.1.2

creating a Cursor in the current, 8.1.3

current, 7.1

example of using child, 7.2

getting the current, 7.1.6

preparing, 7.1.2

read, 7.1.1

rolling back, 7.1.5

setting the current, 7.1.6

using in Template classes, 7.1.3

write, 7.1.1

TransactionProvider interface, 7.2

tuple

definition, 2.5.2

in a Cursor, example, 9.1.1

specifying a measure value, 8.5.2

type of an MDM object

definition, 2.6.3

obtaining, 2.6.4

type of an Source object

definition, 5.3.2

obtaining, 5.3.2

U

unique dimension value, 1.3.3

UserSession objects

creating, 3.1.2.3

V

value method, 5.4.1

description, 6.1

example of, 6.2.6, 6.3.3

Value OLAP Java API data type, 2.6.1

value separation string, 1.3.3

ValueCursor objects

getting from a parent CompoundCursor, example, 9.1.1

getting values from, example, 9.1.1, 9.1.1

position, 8.5.1

virtual Cursor

definition, 8.6

Void OLAP Java API data type, 2.6.1

void Source objects

definition, 5.2

W

write Transaction object, 7.1.1

X

XML templates

exporting, 4.7

importing, 4.7

xmlparserv2.jar file, A.3