Index

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

A

abstract data types, 34.1.2

automatic, 34.1.4

predefining, 34.1.3

Active Catalog, 1.1.6.1, 3, 3.2, 19.2, 34.1

direct metadata access, 3.6, 3.7, 3.13, 3.14

ADD_DIMENSION_SOURCE procedure, 24.4.2

ADT

See abstract data types

ADVISE_CUBE procedure, 24.4.2, 24.4.2

ADVISE_DIMENSIONALITY function, 24.4.2

ADVISE_DIMENSIONALITY procedure, 24.4.2

ADVISE_REL procedure, 24.4.2, 24.4.2

ADVISE_SPARSITY procedure, 24.4.2

Aggregate Advisor, 24.4

aggregate cache

performance statistics, 6.5

aggregation

in analytic workspaces, 1.1.4, 1.6, 24.4, 26.1, 26.1

operators, 1.6, 5.5, 6.3

aggregation specifications, 1.1.4, 1.2, 1.3, 1.4, 3.11

creating, 1.6, 26.1

DBMS_AWM methods on, 1.2.5

ALL_AW_CUBE_AGG_LEVELS view, 4.4

ALL_AW_CUBE_AGG_MEASURES view, 4.5

ALL_AW_CUBE_AGG_PLANS view, 4.6

ALL_AW_CUBE_ENABLED_HIERCOMBO view, 4.7

ALL_AW_CUBE_ENABLED_VIEWS view, 4.8

ALL_AW_DIM_ENABLED_VIEWS view, 4.9

ALL_AW_LOAD_CUBE_DIMS view, 4.11

ALL_AW_LOAD_CUBE_FILTS view, 4.12

ALL_AW_LOAD_CUBE_MEASURES view, 4.13

ALL_AW_LOAD_CUBE_PARMS view, 4.14

ALL_AW_LOAD_CUBES view, 4.10

ALL_AW_LOAD_DIM_FILTERS view, 4.16

ALL_AW_LOAD_DIM_PARMS view, 4.17

ALL_AW_LOAD_DIMENSIONS view, 4.15

ALL_AW_OBJ view, 4.18

ALL_AW_PROP view, 4.19

ALL_OLAP2_AGGREGATION_USES view, 5.5

ALL_OLAP2_AW_ATTRIBUTES view, 3.6

ALL_OLAP2_AW_CUBE_AGG_LVL view, 3.8

ALL_OLAP2_AW_CUBE_AGG_MEAS view, 3.9

ALL_OLAP2_AW_CUBE_AGG_OP view, 3.10

ALL_OLAP2_AW_CUBE_AGG_SPECS view, 3.11

ALL_OLAP2_AW_CUBE_DIM_USES view, 3.12

ALL_OLAP2_AW_CUBE_MEASURES view, 3.13

ALL_OLAP2_AW_CUBES view, 3.7

ALL_OLAP2_AW_DIM_HIER_LVL_ORD view, 3.15

ALL_OLAP2_AW_DIM_LEVELS view, 3.16

ALL_OLAP2_AW_DIMENSIONS view, 3.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_AW_PHYS_OBJ_PROP view, 3.18

ALL_OLAP2_AWS view, 3.5

ALL_OLAP2_CATALOG_ENTITY_USES view, 5.7

ALL_OLAP2_CATALOGS view, 5.6

ALL_OLAP2_CUBE_DIM_USES view, 5.9

ALL_OLAP2_CUBE_MEAS_DIM_USES view, 5.12

ALL_OLAP2_CUBE_MEASURE_MAPS view, 5.11

ALL_OLAP2_CUBE_MEASURES view, 5.10

ALL_OLAP2_CUBES view, 5.8

ALL_OLAP2_DIM_ATTR_USES view, 5.15

ALL_OLAP2_DIM_ATTRIBUTES view, 5.14

ALL_OLAP2_DIM_HIER_LEVEL_USES view, 5.17

ALL_OLAP2_DIM_HIERARCHIES view, 5.16

ALL_OLAP2_DIM_LEVEL_ATTR_MAPS view, 5.20

ALL_OLAP2_DIM_LEVEL_ATTRIBUTES view, 5.19

ALL_OLAP2_DIM_LEVELS view, 5.18

ALL_OLAP2_DIMENSIONS view, 5.13

ALL_OLAP2_ENTITY_EXT_PARMS view, 5.22

ALL_OLAP2_ENTITY_PARAMETERS view, 5.23

ALL_OLAP2_FACT_LEVEL_USES view, 5.24

ALL_OLAP2_FACT_TABLE_GID view, 5.25

ALL_OLAP2_HIER_CUSTOM_SORT view, 5.26

ALL_OLAP2_JOIN_KEY_COLUMN_USES view, 5.27

allocation operators, 6.4

ALTER SESSION commands, 28.1

analytic workspace maintenance views, 1.1.6.2, 4

analytic workspace management APIs, 25.1, 26

Analytic Workspace Manager, 1, 1.8.3, 26, 34.1

analytic workspace objects

defining in XML, 25.1

obtaining names in SQL, 4.18

analytic workspaces

accessing from SQL, 24

Active Catalog, 3

aggregation, 1.1.4, 1.6, 24.4, 26.1, 26.1

converting to 10g storage format, 1.7, 3.5, 3.5, 24.1.1

creating with DBMS_AWM, 1.3

creating with OLAP Analytic Workspace Java API, 25.1

creating with XML, 25.1

dimensions, 1.5

enabling for SQL access, 26, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1

enabling for the OLAP API, 1.7

importing from Oracle 9i, 24.1.1.1

list of, 3.5

maintenance views, 4

performance counters, 6.7

refreshing, 1.2.1, 1.2.2, 1.3, 1.3, 1.4, 1.4, 1.6, 1.8.5, 1.8.5, 1.8.6, 1.8.6, 26.1, 26.1

C

caches

performance statistics, 6.5

composite specifications, 1.2, 4.1, 4.3, 4.11, 26.1

DBMS_AWM methods on, 1.2.6

composites, 1.5, 26.1

composites (regular and compressed)

defined, 24.3.1

CONVERT procedure, 24.4.2

cube load specifications, 1.1.3, 1.2, 4.10, 4.10, 26.1

DBMS_AWM methods on, 1.2.4

cubes, 1.2

creating, 2.4.1, 7.1, 9, 9.1

creating in analytic workspaces, 1.1.3, 26.1

DBMS_AWM methods on, 1.2.2

in analytic workspaces, 3.7

naming in analytic workspaces, 26.1

populating in analytic workspaces, 26.1

source, 26.1

target, 26.1

valid, 22.1.1.1

viewing, 5.8

custom measures, 30.1.1, 32.1.1, 33.1.1

creating with OLAP Analytic Workspace Java API, 25.1

examples with OLAP_EXPRESSION, 30.2

CWM2, 1.1.1, 2

directing output, 2.8

read APIs, 2.9

write APIs, 2

CWM2_OLAP_CATALOG package, 7

CWM2_OLAP_CLASSIFY package, 8

CWM2_OLAP_CUBE package, 9

CWM2_OLAP_DELETE package, 10

CWM2_OLAP_DIMENSION package, 11

CWM2_OLAP_DIMENSION_ATTRIBUTE package, 12

CWM2_OLAP_EXPORT package, 13

CWM2_OLAP_HIERARCHY package, 14

CWM2_OLAP_LEVEL package, 15

CWM2_OLAP_LEVEL_ATTRIBUTE package, 16

CWM2_OLAP_MANAGER package, 1.3, 1.4, 2.6.1, 2.8, 17

CWM2_OLAP_MEASURE package, 18

CWM2_OLAP_METADATA_REFRESH package, 19

CWM2_OLAP_PC_TRANSFORM package, 20

CWM2_OLAP_TABLE_MAP package, 21

CWM2_OLAP_VALIDATE package, 22

CWM2_OLAP_VERIFY_ACCESS package, 23

D

data type conversions, 1.4, 34.1.4

database cache, 6.5

database initialization, 28, 28.1

database standard form, 3.1, 24.2, 26.1, 34.1

E

embedded-total cubes, 22.1.3

embedded-total dimension views, 1.8, 1.8.7, 34.2.1

embedded-total fact tables, 2.5.2

embedded-total fact view, 1.8, 34.2.2

embedded-total key, 2.5.2, 22.1.3

enabling for relational access, 1.1.5, 1.8

F

fact tables, 2.5, 5.24

defining OLAP Catalog metadata for, 2.4

joining with dimension tables, 2.5.2

supported configurations, 2.5.2

fact views

defining from workspace objects, 1.8.8, 26.1, 26.1, 26.1, 26.1, 26.1

FETCH command (OLAP DML), 34.2.4, 34.2.4

fixed views, 6.1

G

GETLOG function, 24.4.2

grouping IDs, 1.8.7, 1.8.7.2, 2.5.2, 5.25, 12.1, 16.1, 20.4.1, 22.1.3

parent, 1.8.7

H

hierarchies

creating, 14

custom sorting, 5.26, 21.3

defined, 14.1

viewing, 5.16, 5.17, 5.27

I

INFILE procedure, 24.4.2

initialization parameters, 28, 28.1

init.ora file, 28.1

INTERACTIONEXECUTE function

see DBMS_AW_XML package

INTERP function, 24.4.2

INTERP_SILENT procedure, 24.4.2

INTERPCLOB function, 24.4.2

J

Java API

Analytic Workspace, 25.1

L

level attributes

creating, 16

defined, 16.1

reserved, 16.1

viewing, 5.19, 5.20

levels

creating, 15

in analytic workspaces, 3.8, 3.16

viewing, 5.18

limit maps, 34.1.1, 34.2.4, 34.2.4

order of processing, 34.2.4

syntax, 34.2.4

Long Description, 12.1, 16.1

M

materialized views

for OLAP API, 27

measure folders

creating, 7

defined, 5.6, 7.1

viewing, 5.7

measures

creating, 18

defined, 18.1

in analytic workspaces, 3.9, 3.13

viewing, 5.10

metadata descriptors, 8

Metadata Reader tables

refreshing, 2.6, 2.6.3, 2.9

metadata upgrade, 26.1

MR_REFRESH procedure, 19.2

MRV_OLAP views, 2.6.3, 2.9, 19.1, 19.2

multidimensional data

enabling for SQL access, 1.7, 26, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1

multidimensional data model

Active Catalog, 3

database standard form, 3

multidimensional target cube, 1.1

O

object types

automatic, 34.1.3

predefining, 34.1.3

syntax for creating, 34.1.2

OLADM, 24.4.2

OLAP Analytic Workspace Java API, 2.1, 3, 4.18, 4.19, 34.1

OLAP API, 34.1

Metadata Reader tables, 2.6.3, 2.9

optimization, 28

OLAP Catalog, 2.6.3, 19.1

exporting, 13

metadata entities, 2.2

metadata entity size, 2.2

metadata entity size limitations, 2.7.2

overview, 2.1, 3.1

preprocessors, 20

read APIs, 2.9, 4, 5, 19

viewing, 2.9, 5, 19

write APIs, 2

OLAP Catalog metadata

committing, 2.6

creating for a dimension table, 2.3.2

creating for a fact table, 2.4.2

creating for DBMS_AWM, 1.1.1, 2.1

creating for the OLAP API, 2.1

deleting, 10

exporting, 13

mapping, 2.3.2, 2.3.4, 2.5, 5.11, 5.20, 5.28, 21.1, 22.1.2

mapping to embedded-total tables, 2.1, 2.5.2

mapping to star and snowflake schemas, 2.1, 2.5.2

validating, 2.6, 22, 23

OLAP DML

executing in SQL, 24, 29, 30, 31, 32, 33

quotation marks in, 24.2.2

OLAP performance views, 6.1

OLAP XML schema, 25.2

OLAP_API_SESSION_INIT package, 28

OLAP_CONDITION function, 29, 34.2.4

OLAP_EXPRESSION function, 24.2.1, 30

OLAP_EXPRESSION_BOOL function, 31

OLAP_EXPRESSION_DATE function, 32

OLAP_EXPRESSION_TEXT function, 33

OLAP_ON function, 24.4.2, 24.4.2

OLAP_PAGE_POOL_SIZE parameter, 6.5

OLAP_TABLE function, 34

custom measures, 30.2

data map parameter, 34.2.4

data type conversions, 34.1.4

examples, 34.2

FETCH command, 34.2.4, 34.2.4

limit map, 34.1.1, 34.2.4, 34.2.4

retrieving session log, 24.4.2

specifying a ROW2CELL column, 34.2.4

specifying an OLAP DML command, 34.2.4, 34.2.4, 34.2.4, 34.2.4

specifying the analytic workspace, 34.2.4, 34.2.4

specifying the limit map, 34.2.4

specifying the logical table, 34.2.4, 34.2.4

with MODEL clause, 34.1.5

optimization

OLAP API, 28, 28.1

OLAP_TABLE, 34.1.5

Oracle Enterprise Manager, 1.1.1

Oracle Warehouse Builder, 1.1.1

OUTFILE command

affect on DBMS_AW.EXECUTE, 24.4.2

affect on DBMS_AW.RUN, 24.4.2

P

P_DISPLAY_NAME, 4.17, 26.1

page pool

performance statistics, 6.5

Parent ET Key, 12.1, 16.1

Parent Grouping ID, 12.1, 16.1

performance counters, 6

PGA allocation, 6.5

print buffer, 24.4.2, 24.4.2

PRINTLOG procedure, 24.4.2

Prior Period, 12.1, 16.1

properties

obtaining in SQL, 4.19

Q

quotation marks

in OLAP DML, 24.2.2

R

refreshing the cache, 2.6.3, 3.2, 19.1, 19.2

relational source cube, 1.1

relational target cube, 1.1

reserved dimension attributes, 12.1

reserved level attributes, 16.1

ROW2CELL column, 29.1.1, 29.2, 30.1.2, 31.1.2, 32.1.2, 34.2.4

RUN procedure, 24.4.2

S

segwidth, 26.1

SERVEROUTPUT option, 1.3, 1.4, 2.6.1, 2.8, 2.8, 17.1, 24.4.2, 24.4.2, 24.4.2

session

shutting down, 24.4.2

starting up, 24.4.2

session cache

performance statistics, 6.5

session counters, 6.8

session logs

printing, 24.4.2

retrieving, 24.4.2

session statistics, 6.7

Short Description, 12.1, 16.1

SHUTDOWN procedure, 24.4.2

single-row functions, 30.1.1, 31.1.1, 32.1.1, 33.1.1

snowflake schema, 2.5.1.1

solved data, 1.1, 1.8.7, 1.8.8, 2.5.2

solved_code, 2.5.2, 5.16, 14.2

sparse data, 1.5, 26.1

Sparsity Advisor, 24.3

SPARSITY_ADVICE_TABLE column descriptions, 24.4.2

SPARSITY_ADVICE_TABLE procedure, 24.4.2

SQL

embedding OLAP commands, 24, 29, 30, 31, 32, 33

managing analytic workspaces, 24

standard form

see database standard form

star schema, 2.5.1.1

STARTUP procedure, 24.4.2

T

table type, 34.2.4, 34.2.4

automatic, 34.1.3

predefining, 34.1.3

syntax for creating, 34.1.2

time dimensions

creating, 2.3.3

Time Span, 12.1, 16.1

time-span attribute, 22.1.3

transaction statistics, 6.8

tuples, 24.3.1

U

UNIQUE_RDBMS_KEY, 4.17, 26.1

unsolved data, 1.1, 2.5.2

upgrading, 26.1

UTL_FILE_DIR parameter, 1.8.1, 2.8, 17.2, 20.1, 20.4.2, 26.1, 26.1, 26.1, 26.1, 27.3, 27.3, 27.3

V

V$AW_AGGREGATE_OP view, 6.3

V$AW_ALLOCATE_OP view, 6.4

V$AW_CALC view, 6.5

V$AW_OLAP view, 6.7

V$AW_SESSION_INFO view, 6.8

validating OLAP Catalog metadata, 2.6

views

Active Catalog, 3

analytic workspace maintenance information, 4

creating embedded total dimensions, 1.8.7, 34.2.1

creating embedded total measures, 34.2.2

creating for analytic workspaces, 1.8

creating rollup form, 34.2.3

objects in analytic workspaces, 3

OLAP Catalog metadata, 5

template for creating with OLAP_TABLE, 34.1.3, 34.1.4

W

workspace objects

obtaining names in SQL, 4.18

X

XML document

example, 25.2

Y

Year Ago Period, 12.1, 16.1