Index

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

---

A

AbstractCursorManager class methods, 10-18

aggregation functions

creating, 7-11

aggregation methods

explanation of, 7-7

list of, 7-7

using, 7-8, 7-9

alias method

description, 5-6

example, 6-15, 6-16

analytic workspace, 1-7, 3-2

ancestors attributes

example of getting, 4-7

for MdmHierarchy objects, 2-12

for MdmLevel objects, 2-11

application

configurations, 1-10

deployment, 1-16, A-4

development steps, 1-13

tasks performed by, 1-17

asymmetric result set, Cursor positions in an, 10-26

attributes

ancestors, 2-11, 2-12

definition, 1-2

in Oracle Enterprise Manager, 2-3

MdmAttribute objects, 2-22

parent, 2-11, 2-12

region, 2-12

Source objects for, 5-4

---

B

Boolean OLAP API data type, 5-10

BooleanSource objects, 5-2

---

C

Common Object Request Broker Architecture

naming service, 3-8, B-1

obtaining CORBA stub for connecting, 3-7, B-2

software provided, A-2

used in OLAP API, 1-10

CompoundCursor class, 10-4

methods, 10-9

CompoundCursor objects

getting children of, example, 9-5

navigating for a crosstab view, example, 9-11, 9-13

navigating for a table view, example, 9-9

positions of, 10-23

CompoundCursorSpecification class, 10-12

methods, 10-14

configuration

three-tier application, 1-11

two-tier application, 1-11

connect method

example of calling, 3-10

example of preparing first parameter, 3-7, B-2

example of preparing second parameter, 3-9

introduction, 3-4

overview of parameters, 3-7

Connection objects

description, 3-5

example of closing, 3-11

example of creating, 3-10

ConnectionManager objects

description, 3-4

example of initializing, 3-10

ConnectionParameterInfo objects

description, 3-6

example of using, 3-10

connections

classes for, 3-4

closing, 3-11

interrupting, 3-11

overview, 3-2

prerequisites, 3-2

steps for establishing, 3-7

summary of steps for establishing, 3-3

constant Source objects

definition, 5-2

example, 5-12

CORBA. See Common Object Request Broker Architecture

crosstab view

navigating Cursor for, example, 9-11, 9-13

current position in a Cursor, definition, 10-22

Cursor class

architecture, advantages of, 10-2

hierarchy, 10-5

methods, 10-9

Cursor objects

created in the current Transaction, 10-3

creating, example, 9-2

current position, definition, 10-22

extent calculation, example, 9-20

extent definition, 10-30

faster and slower varying components, 10-6

fetch block definition, 10-32

fetch size definition, 10-32

getting children of, example, 9-5

getting the values of, examples, 9-3

parent starting and ending position, 10-28

position, 10-22

Source objects for which you cannot create, 10-3

span of a value, example of calculating, 9-21

span, definition, 10-28

specifying fetch size for a crosstab view, example, 9-24

specifying fetch size for a table view, example, 9-24

specifying the behavior of, 9-17, 10-8

starting and ending positions of a value, example of calculating, 9-20

structure, 10-5

CursorManager class, 10-15

hierarchy, 10-16

methods, 10-18

CursorManager objects

closing before rolling back a Transaction, 8-11

creating, example, 9-2

updating the CursorManagerSpecification, 10-15

CursorManagerSpecification class, 10-10

creating object, example, 9-2

methods, 10-11

CursorManagerUpdateEvent class, 10-21

fields, 10-21

methods, 10-21

CursorManagerUpdateListener class, 10-20

methods, 10-20

CursorSpecification class, 10-11

methods, 10-13

CursorSpecification objects

getting from a CursorManagerSpecification, example, 9-18

---

D

data store

connecting to, 3-2

definition, 1-3

exploring, 4-2

organized in folders, 1-7

scope of, 4-2

data types

OLAP API, 5-10

data warehouse

definition, 1-3

Database objects

creating, 4-4

needed to create MdmMetadataProvider, 4-3

DataProvider objects

creating, 4-4

needed to create MdmMetadataProvider, 4-3

Date OLAP API data type, 5-10

DateSource objects, 5-2

default hierarchy

example of getting, 4-7

retrieving, 6-13

derived Source objects

creating, 6-1 to 7-13

definition, 5-2

description, 5-5

introduced, 5-5

dimensions

definition, 1-2

in Oracle Enterprise Manager, 2-3

MdmDimension objects, 2-8

Source objects for, 5-3

distinct method

description, 5-6

drilling down a hierarchy, 6-15

dynamic queries, 11-1

DynamicDefinition class, 11-7

---

E

elements

finding position of, 6-7 to 6-10

of a level MdmHierarchy, 2-14

of a union MdmHierarchy, 2-16

of an MdmAttribute, 2-23

of an MdmLevel, 2-11

of an MdmListDimension, 2-18

of an MdmMeasure, 2-19

ranking, 6-10 to 6-12

selecting by value, 6-5 to 6-6

sorting, 6-10 to 6-12

ExpressSpecifiedCursorManager class methods, 10-19

ExpressTransactionProvider class, 8-10

extent of a Cursor

definition, 10-30

example of calculating, 9-20

use of, 10-31

extract method

description, 5-6

---

F

faster varying Cursor components, 10-6

fetch block of a Cursor

definition, 10-32

determining shape of, 10-33

sharing, 10-34

fetch size of a Cursor

definition, 10-32

example of specifying, 9-24

reasons for specifying, 10-32

specifying, 10-32

Float OLAP API data type, 5-10

fundamental Source objects, 5-9

creating, 5-11, 5-12

definition, 5-2

---

G

getSource method

example, 5-3, 5-4

for creating primary Source objects, 5-3 to 5-5

for getting Source produced by a Template, example, 11-14

in DynamicDefinition class, 11-2, 11-7

in MdmSource class, 2-8

simple example, 4-8

---

H

hierarchies

creating Source objects for, 6-12

definition, 1-2

drilling down, 6-15

in Oracle Enterprise Manager, 2-3

MdmHierarchy objects, 2-12

node and leaf terminology, 2-16

retrieving default, 4-7, 6-13

---

I

input-output order

determining, 6-3, 6-5

effect on Source structure, 6-3, 6-5

inputs

changing to outputs, 6-2 to 6-5

defined, 6-1

turning into outputs, 6-2

installation for application development, A-1

Integer OLAP API data type, 5-10

---

J

Java Development Kit, version required, A-2

join method

changing inputs to outputs, 6-2

example, 5-8, 6-3 to 6-5, 6-7, 6-15, 6-16

result, 5-8

syntax, 5-7

to change inputs to outputs, 6-2 to 6-5

---

K

keys

determining order of, 6-2 to 6-5

inputs, 6-1

kinds, 6-1

outputs, 6-1

specifying values for, 6-2

---

L

leaf in a hierarchy, 2-16

level MdmHierarchy, 2-13

levels

definition, 1-2

in Oracle Enterprise Manager, 2-3

MdmLevel objects, 2-11

list Source objects, 5-2

Long OLAP API data type, 5-10

---

M

MDM. See multidimensional metadata model

MdmAttribute objects

creating Source objects for, 5-4

description, 2-22

elements, 2-23

example of getting, 4-7

MdmDimension objects

creating Source objects for, 5-3

description, 2-8

example of getting related objects, 4-7

introduction, 1-6

regions, 2-10

related MdmAttribute objects, 2-9

related MdmDimensionDefinition objects, 2-10

related MdmDimensionMemberType objects, 2-10

MdmDimensionDefinition objects

description, 2-10

example of getting, 4-7

MdmDimensionMemberType objects

description, 2-10

example of getting, 4-7

MdmHierarchy objects

creating Source objects for, 6-12

description, 2-12

elements of a level MdmHierarchy, 2-14

elements of a union MdmHierarchy, 2-16

level type description, 2-13

union type description, 2-13

MdmLevel objects

description, 2-11

elements, 2-11

MdmListDimension objects

description, 2-18

elements, 2-18

MdmMeasure objects

creating Source objects for, 5-4

description, 2-19

elements, 2-19

example of getting their dimensions, 4-7

introduction, 1-6

kinds of values, 2-20

MdmMetadataProvider objects

creating, 4-4

description, 4-3

introduction, 1-5

MdmObject class, 2-5

MdmSchema objects

description, 2-7

getting contents of, 4-6

getting the root, 4-6

introduction, 1-5

root, 2-7, 4-4

MdmSource objects, 2-8

measure folders

in Oracle Enterprise Manager, 2-4

mapped to MdmSchema objects, 2-7

measure MdmDimension objects, 4-7

measures

definition, 1-2

in Oracle Enterprise Manager, 2-4

MdmMeasure objects, 2-19

Source objects for, 5-4

metadata

definition, 1-3

discovering, 4-1

distinguished from data, 1-4

mapping OEM to MDM, 2-6

preparation for OLAP API, 1-3, 2-2

sample code for discovering, 4-9 to 4-25

MetadataState class, 11-6

example of implementation, 11-12

multidimensional metadata model (MDM)

description, 2-2

introduction, 1-5

---

N

nested outputs

getting values from a Cursor with, example, 9-6

of a Source, definition, 9-3

node in a hierarchy, 2-16

Number OLAP API data type, 5-10

NumberSource objects, 5-2

numeric comparisons

performing, 7-4 to 7-5

numeric functions

creating, 7-10

methods representing, 7-6

numeric methods

using, 7-5 to 7-11

numeric operations

example, 7-2, 7-3

list of methods for, 7-2, 7-5

performing, 7-1 to 7-4

---

O

OLAP API

definition, 1-1

deploying an application, A-4

installing for application development, A-1

software components, 1-8

types, 5-9

OLAP API data types

listed, 5-10

objects that represent, 5-10

retrieving, 5-10

OLAP management tool, 2-2

OLAP Services

OLAP API connection, 1-8

Oracle Enterprise Manager

OLAP management feature, 2-2

outputs

changing from inputs, 6-2 to 6-5

defined, 6-1

getting from a CompoundCursor, example, 9-5

getting from a CompoundCursorSpecification, example, 9-18

getting nested, example, 9-6

in a CompoundCursor, 10-5, 10-28, 10-30

positions of, 10-23

---

P

parameterized selections

creating, 7-10

parameters

creating, 7-10

parent attributes

example of getting, 4-7

for MdmHierarchy objects, 2-12

for MdmLevel objects, 2-11

parent-child relationships

creating Source objects for, 6-14

position

parent starting and ending, 10-28

position method

described, 6-7

description, 5-6

example, 6-8 to 6-10

shortcuts, 6-7

positions

CompoundCursor, 10-23

Cursor, 10-22

of elements, 6-7 to 6-10

ValueCursor, 10-22

primary Source objects

definition, 5-2

for parent-child relationship, 6-14

from MdmDimension object, 5-3

from MdmHierarchy objects, 6-12

from MdmMeasure objects, 5-4

from MdmSource objects, 2-8

getting, 5-3 to 5-5

result of getSource method, 4-8

structure, 5-3, 5-4, 5-5

primitive methods, 5-6

---

Q

queries

dynamic, 11-1

Source objects that are not, 10-3

specifications for, 5-1

steps in retrieving results of, 9-1

---

R

range Source objects, 5-2

ranking elements, 6-10 to 6-12

read Transaction object, 8-2

region attributes

example of getting, 4-7

for MdmHierarchy objects, 2-12

regions

example of getting, 4-7

of an MdmDimension, 2-10

relationships

Source objects for, 6-14

retrieving OLAP API data types, 5-10

root MdmSchema

description, 2-7

function of, 4-4

obtaining, 4-6

---

S

Sales History schema

accessing through sample programs, A-4

list of metadata objects in, 4-16

metadata discovery program, 4-9

sample programs, A-4

selecting data, 6-1 to 6-17

selecting elements

based on element values, 6-5 to 6-7

based on hierarchical position, 6-12 to 6-17

based on key values, 6-1 to 6-5

based on rank, 6-7 to 6-12

selectValue method

example, 6-7

self-relation

Source object for, 6-15, 6-16

Short OLAP API data type, 5-10

slower varying Cursor components, 10-6, 10-25

sorting elements, 6-10 to 6-12

Source class

convenience methods, 5-6

methods, 5-5

primitive methods, 5-6

shortcut methods, 5-6

subclasses, 5-2

Source methods

alias, 5-6

distinct, 5-6

extract, 5-6

for numeric functions, 7-6

join, 5-7, 5-8

position, 5-6

string, 7-11 to 7-13

value, 5-6

Source objects

active in a Transaction object, 8-2, 10-3

constant, 5-2

definition, 5-1

derived, 5-2

for attributes, 5-4

for dimensions, 5-3

for measures, 5-4

for relationships, 6-14

for self-relation, 6-15, 6-16

fundamental, 5-2

getting, 5-3 to 5-5

getting a modifiable Source from a DynamicDefinition, 11-7

list, 5-2

modifiable, 11-1

OLAP API data type, 5-10

primary, 5-2, 5-3

range, 5-2

structure, 5-3, 5-4

SourceGenerator class, 11-7

example of implementation, 11-13

span of a value in a Cursor

definition, 9-19, 10-28

example of calculating, 9-21

SpecifiedCursorManager class methods, 10-19

SpecifiedCursorManager objects

closing, 10-15

returned by the createCursorManager method, 10-15

string methods, 7-11 to 7-13

String OLAP API data type, 5-10

StringSource objects, 5-2

subschemas

description, 4-4

getting contents, 4-7

---

T

table view

navigating Cursor for, example, 9-9

Template class, 11-6

designing, 11-8

example of implementation, 11-9

methods, 11-6

Template objects

benefits of using, 1-14

classes used to create, 11-3

for creating modifiable Source objects, 11-1

introductory example, 1-15

relationship of classes producing a dynamic Source, 11-3

Transaction objects used in, 8-4

Transaction objects

child read and write, 8-2

committing, 8-3

creating a Cursor in the current, 10-3

current, 8-2

example of using child, 8-11

getting the current, 8-9

preparing, 8-3

read, 8-2

rolling back, 8-8

setting the current, 8-9

using in Template classes, 8-4

write, 8-2

TransactionProvider interface, 8-10

methods, 8-10

TransactionProvider objects

creating, 4-4

needed to create MdmMetadataProvider, 4-3

tuple

definition, 10-23

in a Cursor, example, 9-7

type

definition, 5-9

OLAP API data, 5-10

---

U

union MdmHierarchy, 2-13

---

V

value method

description, 5-6

Value OLAP API data type, 5-10

ValueCursor class, 10-4

methods, 10-9

ValueCursor objects

getting from a parent CompoundCursor, example, 9-5

getting values from, example, 9-3, 9-4

position, 10-22

ValueCursorSpecification class, 10-12

methods, 10-14

virtual Cursor

definition, 10-32

VisiBroker Smart Agent

example of getting CORBA stub, B-2

finding out if needed, B-2

---

W

what-if analysis, 8-2, 8-4

workspace, 1-7, 3-2

write Transaction object, 8-2