Index

A C D E F G I L M O P Q R S T V X

A

abstract data types, 11.1.2

automatic, 11.1.4

predefining, 11.1.3

Active Catalog, 1, 11.1

ADD_DIMENSION_SOURCE procedure, 3.4.2

ADT

See abstract data types

ADVISE_CUBE procedure, 3.4.2, 3.4.2

ADVISE_DIMENSIONALITY function, 3.4.2

ADVISE_DIMENSIONALITY procedure, 3.4.2

ADVISE_REL procedure, 3.4.2, 3.4.2

ADVISE_SPARSITY procedure, 3.4.2

Aggregate Advisor, 3.4

aggregate cache

performance statistics, 2.5

aggregation

in analytic workspaces, 3.4

operators, 2.3

aggregation specifications, 1.11

ALL_OLAP2_AW_ATTRIBUTES view, 1.4

ALL_OLAP2_AW_CUBE_AGG_LVL view, 1.8

ALL_OLAP2_AW_CUBE_AGG_MEAS view, 1.9

ALL_OLAP2_AW_CUBE_AGG_OP view, 1.10

ALL_OLAP2_AW_CUBE_AGG_SPECS view, 1.11

ALL_OLAP2_AW_CUBE_DIM_USES view, 1.12

ALL_OLAP2_AW_CUBE_MEASURES view, 1.13

ALL_OLAP2_AW_CUBES view, 1.7

ALL_OLAP2_AW_DIM_HIER_LVL_ORD view, 1.15

ALL_OLAP2_AW_DIM_LEVELS view, 1.16

ALL_OLAP2_AW_DIMENSIONS view, 1.14

ALL_OLAP2_AW_MAP_ATTR_USE view (obsolete)

See ALL_OLAP2_AW_ATTRIBUTES view

ALL_OLAP2_AW_MAP_DIM_USE view (obsolete)

See ALL_OLAP2_AW_DIMENSIONS view

ALL_OLAP2_AW_MAP_MEAS_USE view (obsolete)

See ALL_OLAP2_AW_CUBE_MEASURES view

ALL_OLAP2_AWS view, 1.3

allocation operators, 2.4

ALTER SESSION commands, 5.1

Analytic Workspace Manager, 11.1

analytic workspaces

accessing from SQL, 3

aggregation, 3.4

converting to 10g storage format, 1.3, 1.3, 3.1.1

creating from XML

importing from Oracle 9i, 3.1.1.1

list of, 1.3

performance counters, 2.7

C

caches

performance statistics, 2.5

composites (regular and compressed)

defined, 3.3.1

CONVERT procedure, 3.4.2

cubes

in analytic workspaces, 1.7

custom measures, 7.1.1, 9.1.1, 10.1.1

examples with OLAP_EXPRESSION, 7.2

D

data type conversions, 11.1.4

database cache, 2.5

database initialization, 5, 5.1

database standard form, 1.1, 3.2, 11.1

E

embedded-total dimension views, 11.2.1

embedded-total fact view, 11.2.2

EVAL_NUMBER function, 3.4.2

EVAL_TEXT function, 3.4.2

EXECUTE procedure, 3.4.2

F

FETCH command (OLAP DML), 11.2.4, 11.2.4

fixed views, 2.1

G

GETLOG function, 3.4.2

I

INFILE procedure, 3.4.2

initialization parameters, 5, 5.1

init.ora file, 5.1

INTERACTIONEXECUTE function

see DBMS_AW_XML package

INTERP function, 3.4.2

INTERP_SILENT procedure, 3.4.2

INTERPCLOB function, 3.4.2

L

levels

in analytic workspaces, 1.8, 1.16

limit maps, 11.1.1, 11.2.4, 11.2.4

order of processing, 11.2.4

syntax, 11.2.4

M

measures

in analytic workspaces, 1.9, 1.13

multidimensional data model

Active Catalog, 1

O

object types

automatic, 11.1.3

predefining, 11.1.3

syntax for creating, 11.1.2

OLADM, 3.4.2

OLAP Analytic Workspace Java API, 11.1

OLAP API, 11.1

optimization, 5

OLAP DML

executing in SQL, 3, 6, 7, 8, 9, 10

quotation marks in, 3.2.2

OLAP performance views, 2.1

OLAP_API_SESSION_INIT package, 5

OLAP_CONDITION function, 6, 11.2.4

OLAP_EXPRESSION function, 3.2.1, 7

OLAP_EXPRESSION_BOOL function, 8

OLAP_EXPRESSION_DATE function, 9

OLAP_EXPRESSION_TEXT function, 10

OLAP_ON function, 3.4.2, 3.4.2

OLAP_PAGE_POOL_SIZE parameter, 2.5

OLAP_TABLE function, 11

custom measures, 7.2

data map parameter, 11.2.4

data type conversions, 11.1.4

examples, 11.2

FETCH command, 11.2.4, 11.2.4

limit map, 11.1.1, 11.2.4, 11.2.4

retrieving session log, 3.4.2

specifying a ROW2CELL column, 11.2.4

specifying an OLAP DML command, 11.2.4, 11.2.4, 11.2.4, 11.2.4

specifying the analytic workspace, 11.2.4, 11.2.4

specifying the limit map, 11.2.4

specifying the logical table, 11.2.4, 11.2.4

with MODEL clause, 11.1.5

optimization

OLAP API, 5, 5.1

OLAP_TABLE, 11.1.5

OUTFILE command

affect on DBMS_AW.EXECUTE, 3.4.2

affect on DBMS_AW.RUN, 3.4.2

P

page pool

performance statistics, 2.5

performance counters, 2

PGA allocation, 2.5

print buffer, 3.4.2, 3.4.2

PRINTLOG procedure, 3.4.2

Q

quotation marks

in OLAP DML, 3.2.2

R

ROW2CELL column, 6.1.1, 6.2, 7.1.2, 8.1.2, 9.1.2, 11.2.4

RUN procedure, 3.4.2

S

SERVEROUTPUT option, 3.4.2, 3.4.2, 3.4.2

session

shutting down, 3.4.2

starting up, 3.4.2

session cache

performance statistics, 2.5

session counters, 2.8

session logs

printing, 3.4.2

retrieving, 3.4.2

session statistics, 2.7

SHUTDOWN procedure, 3.4.2

single-row functions, 7.1.1, 8.1.1, 9.1.1, 10.1.1

Sparsity Advisor, 3.3

SPARSITY_ADVICE_TABLE column descriptions, 3.4.2

SPARSITY_ADVICE_TABLE procedure, 3.4.2

SQL

embedding OLAP commands, 3, 6, 7, 8, 9, 10

managing analytic workspaces, 3

standard form

see database standard form

STARTUP procedure, 3.4.2

T

table type, 11.2.4, 11.2.4

automatic, 11.1.3

predefining, 11.1.3

syntax for creating, 11.1.2

transaction statistics, 2.8

tuples, 3.3.1

V

V$AW_AGGREGATE_OP view, 2.3

V$AW_ALLOCATE_OP view, 2.4

V$AW_CALC view, 2.5

V$AW_OLAP view, 2.7

V$AW_SESSION_INFO view, 2.8

views

Active Catalog, 1

creating embedded total dimensions, 11.2.1

creating embedded total measures, 11.2.2

creating rollup form, 11.2.3

objects in analytic workspaces, 1

template for creating with OLAP_TABLE, 11.1.3, 11.1.4

X

XML document

creating an analytic workspace