Skip Headers
Oracle® OLAP Java API Developer's Guide
11g Release 1 (11.1)

B28127-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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
connections
closing, 3.1.3
creating, 3.1.2.1
prerequisites for, 3.1.1
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.2
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
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
creating connections, 3.1.2.1
libraries required, A.2
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
OracleConnection objects
creating, 3.1.2.1
OracleDataSource objects
creating, 3.1.2.1
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.2
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.1
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.2

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