Index

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

A

Active Catalog, 3, 22.3

ADVISE_CUBE procedure, 21.3, 21.3.2

ADVISE_REL procedure, 21.3, 21.3.2, 21.3.2

Aggregate Advisor, 21.3

aggregate cache

performance statistics, 6.5

aggregation

in analytic workspaces, 1.1.4, 1.6, 21.3.2, 21.3.2, 23.1, 23.1

operators, 1.6.2, 5.4, 6.3, 24.2

aggregation plans, 1.1.4, 3.10, 23.1

aggregation specifications, 1.1.4, 1.2, 1.3.3, 1.4.4

creating, 1.6.1, 23.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, 22.3

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.4

ALL_OLAP2_AW_ATTRIBUTES view, 3.5

ALL_OLAP2_AW_CUBE_AGG_LVL view, 3.7

ALL_OLAP2_AW_CUBE_AGG_MEAS view, 3.8

ALL_OLAP2_AW_CUBE_AGG_OP view, 3.9

ALL_OLAP2_AW_CUBE_AGG_SPECS view, 3.10

ALL_OLAP2_AW_CUBE_DIM_USES view, 3.11

ALL_OLAP2_AW_CUBE_MEASURES view, 3.12

ALL_OLAP2_AW_CUBES view, 3.6

ALL_OLAP2_AW_DIM_HIER_LVL_ORD view, 3.14

ALL_OLAP2_AW_DIM_LEVELS view, 3.15

ALL_OLAP2_AW_DIMENSIONS view, 3.13

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 view, 3.16

ALL_OLAP2_AW_PHYS_OBJ_PROP view, 3.17

ALL_OLAP2_AWS view, 3.4, 22.3

ALL_OLAP2_CATALOG_ENTITY_USES view, 5.6

ALL_OLAP2_CATALOGS view, 5.5

ALL_OLAP2_CUBE_DIM_USES view, 5.8

ALL_OLAP2_CUBE_MEAS_DIM_USES view, 5.11

ALL_OLAP2_CUBE_MEASURE_MAPS view, 5.10

ALL_OLAP2_CUBE_MEASURES view, 5.9

ALL_OLAP2_CUBES view, 5.7

ALL_OLAP2_DIM_ATTR_USES view, 5.14

ALL_OLAP2_DIM_ATTRIBUTES view, 5.13

ALL_OLAP2_DIM_HIER_LEVEL_USES view, 5.16

ALL_OLAP2_DIM_HIERARCHIES view, 5.15

ALL_OLAP2_DIM_LEVEL_ATTR_MAPS view, 5.19

ALL_OLAP2_DIM_LEVEL_ATTRIBUTES view, 5.18

ALL_OLAP2_DIM_LEVELS view, 5.17

ALL_OLAP2_DIMENSIONS view, 5.12

ALL_OLAP2_ENTITY_EXT_PARMS view, 5.21

ALL_OLAP2_ENTITY_PARAMETERS view, 5.22

ALL_OLAP2_FACT_LEVEL_USES view, 5.23

ALL_OLAP2_FACT_TABLE_GID view, 5.24

ALL_OLAP2_HIER_CUSTOM_SORT view, 5.25

ALL_OLAP2_JOIN_KEY_COLUMN_USES view, 5.26

allocation operators, 6.4

ALTER SESSION commands, 25.1

analytic workspace maintenance views, 4

analytic workspace management APIs, 23

Analytic Workspace Manager, 1, 1.7.3, 23

analytic workspace objects

obtaining names in SQL, 4.18

analytic workspaces

Active Catalog, 3

aggregation, 1.1.4, 1.6, 23.1, 23.1

creating with DBMS_AWM, 1.3, 1.7.9

dimensions, 1.5

enabling for SQL access, 23, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1

enabling for the OLAP API, 1.1.5, 1.7, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1

list of, 3.4

maintenance views, 4

obtain a list of, 22.3

performance counters, 6.7

refreshing, 1.2.1, 1.2.2, 1.3, 1.3.1, 1.4.1, 1.4.2, 1.6.2, 1.7.4, 1.7.4, 23.1, 23.1

views of, 1.7.6, 1.7.7, 23.1, 23.1, 23.1, 23.1

ATTRIBUTE subclause (limit maps), 26

attributes

viewing, 5.14

AW_ATTACH procedure, 21.3.2

AW_COPY procedure, 21.3.2

AW_CREATE procedure, 21.3.2

AW_DELETE procedure, 21.3.2

AW_DETACH procedure, 21.3.2

AW_RENAME procedure, 21.3.2

AW_UPDATE procedure, 21.3.2

C

caches

performance statistics, 6.5

composite specifications, 1.2, 4.1, 4.3, 4.11, 23.1

DBMS_AWM methods on, 1.2.6

composites, 1.5, 23.1

cube load specifications, 1.1.3, 1.2, 4.10, 4.10, 23.1

DBMS_AWM methods on, 1.2.4

cubes, 1.2

creating, 2.3.1, 7.1, 9, 9.1

creating and refreshing in analytic workspaces, 1.1.3

creating in analytic workspaces, 23.1

DBMS_AWM methods on, 1.2.2

in analytic workspaces, 3.6

naming in analytic workspaces, 23.1

populating in analytic workspaces, 23.1

source, 23.1

target, 23.1

viewing, 5.7

custom measures, 21.3.2, 21.3.2, 21.3.2, 21.3.2, 22

creating, 22.3, 22.3

deleting, 22.3

querying, 22.2

updating, 22.3

CWM2, 1.1.1, 2.2.2

directing output, 2.7

write APIs, 2

CWM2$_AW_PERM_CUST_MEAS_MAP table, 22.2.1

CWM2$_AW_TEMP_CUST_MEAS_MAP table, 22.2.2

CWM2_OLAP_CATALOG package, 7

CWM2_OLAP_CLASSIFY package, 8

CWM2_OLAP_CUBE package, 9

CWM2_OLAP_DIMENSION package, 10

CWM2_OLAP_DIMENSION_ATTRIBUTE package, 11

CWM2_OLAP_HIERARCHY package, 12

CWM2_OLAP_LEVEL package, 13

CWM2_OLAP_LEVEL_ATTRIBUTE package, 14

CWM2_OLAP_MANAGER package, 1.3, 1.4, 2.5.1, 2.7

CWM2_OLAP_MEASURE package, 15

CWM2_OLAP_METADATA_REFRESH package, 16

CWM2_OLAP_PC_TRANSFORM package, 17

CWM2_OLAP_TABLE_MAP package, 18

CWM2_OLAP_VALIDATE package, 19

CWM2_OLAP_VERIFY_ACCESS package, 20

D

data types

OLAP_TABLE, 26

database cache, 6.5

database initialization, 25, 25.1

database standard form, 23.1, 23.1

viewing objects, 3

DBMS_AW package

ADVISE_CUBE procedure, 21.3.2

ADVISE_REL procedure, 21.3.2

AW_ATTACH procedure, 21.3.2

AW_COPY procedure, 21.3.2

AW_CREATE procedure, 21.3.2

AW_DELETE procedure, 21.3.2

AW_DETACH procedure, 21.3.2

AW_RENAME procedure, 21.3.2

AW_UPDATE procedure, 21.3.2

custom measures, 21.3.2, 21.3.2, 21.3.2, 21.3.2

EXECUTE procedure, 21.3.2

GETLOG function, 21.3.2, 21.3.2

INTERP function, 21.3.2

INTERP_SILENT function, 21.3.2

INTERPCLOB function, 21.3.2

OLAP_EXPRESSION function, 21.3.2

OLAP_EXPRESSION_BOOL function, 21.3.2

OLAP_EXPRESSION_DATE function, 21.3.2

OLAP_EXPRESSION_TEXT function, 21.3.2

overview, 21

PRINTLOG procedure, 21.3.2

DBMS_AWM package, 1, 1.7.9, 23

DBMS_ODM package, 24.2.1, 24.2.2

dimension alias, 5.8

dimension attributes

creating, 11

reserved, 11.1

viewing, 5.13

DIMENSION clause (limit maps), 26

dimension load specifications, 1.1.2, 1.2, 23.1, 23.1

DBMS_AWM methods on, 1.2.3

dimension tables, 2.4

defining OLAP metadata for, 2.2

dimension views

defining for workspace objects, 1.7.8, 23.1

dimensions, 1.2

creating, 2.2, 10

creating and refreshing in analytic workspaces, 1.1.2

creating in analytic workspaces, 23.1

DBMS_AWM methods on, 1.2.1

embedded-total, 17.4.2

in analytic workspaces, 3.11, 3.13, 3.14

naming in analytic workspaces, 23.1

ordering in analytic workspaces, 1.1.3, 1.5.1

parent-child, 17

populating in analytic workspaces, 23.1

valid, 19.1.1.2

viewing, 5.12

directory object, 1.7.1, 2.7, 17.1, 17.4.2, 23.1, 23.1, 23.1, 23.1, 24.2.1, 24.3, 24.3, 24.3

DISPLAY_NAME, 4.17, 23.1

dynamic performance views, 6

E

embedded-total cubes, 19.1.3

embedded-total dimension views, 1.7

creating, 1.7.8

embedded-total fact tables, 2.4.2

embedded-total fact view, 1.7

embedded-total key, 2.4.2, 19.1.3

enabling for relational access, 1.1.5, 1.7

F

fact tables, 2.4, 5.23

defining OLAP metadata for, 2.3

joining with dimension tables, 2.4.2

supported configurations, 2.4.2

fact views

defining from workspace objects, 1.7.9, 23.1, 23.1, 23.1, 23.1, 23.1

FAMILYREL subclause (limit maps), 26

FETCH command (DML), 26

fixed views, 6.1

G

GETLOG function, 21.3.2

GID subclause (limit maps), 26

grouping IDs, 1.7.8, 1.7.8.2, 2.4.2, 5.24, 11.1, 14.1, 17.4.1, 19.1.3

parent, 1.7.8

H

hierarchies

creating, 12

custom sorting, 5.25, 18.3

defined, 12.1

viewing, 5.15, 5.16, 5.26

HIERARCHY subclause (limit maps), 26

I

INHIERARCHY subclause (limit maps), 26

initialization parameters, 25, 25.1

init.ora file, 25.1

L

level attributes

creating, 14

defined, 14.1

reserved, 14.1

viewing, 5.18, 5.19

levels

creating, 13

in analytic workspaces, 3.7, 3.15

viewing, 5.17

limit maps, 26

syntax, 26

Long Description, 11.1, 14.1

LOOP clause (limit maps), 26

M

materialized views

CWM2, 24.2.1, 24.2.2

for OLAP API, 24

grouping sets, 24.2.1, 24.2.2

MEASURE clause (limit maps), 26

measure folders

creating, 7

defined, 5.5, 7.1

viewing, 5.6

measures

creating, 15

defined, 15.1

in analytic workspaces, 3.8, 3.12

viewing, 5.9

metadata descriptors, 8

Metadata Reader tables

refreshing, 2.5, 2.5.3, 2.8

MR_REFRESH procedure, 16.2

MRV_OLAP views, 2.5.3, 2.8, 16.1, 16.2

multidimensional data

enabling for SQL access, 1.7, 22.3, 23, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1

multidimensional data model

Active Catalog, 3

database standard form, 3

multidimensional target cube, 1.1

O

object types

syntax for creating, 26

OLAP Analytic Workspace Java API, 1.7.1, 1.7.4, 4.18, 4.19, 23.1, 23.1

OLAP API

Metadata Reader tables, 2.5.3, 2.8

optimization, 25

OLAP API Enabler, 1.1.5, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1, 23.1

OLAP Catalog

metadata entities, 2.1

metadata entity size, 2.1

metadata entity size limitations, 2.6.2

preprocessors, 17

read APIs, 2.8, 4, 5, 16

refreshing views for OLAP API, 16

viewing, 2.8, 5, 16

write APIs, 2

OLAP DML

executing in SQL, 21

OLAP metadata

commiting, 2.5

creating for a dimension table, 2.2.2

creating for a fact table, 2.3.2

creating for DBMS_AWM, 1.1.1

mapping, 2.2.2, 2.2.4, 2.4, 5.10, 5.19, 5.27, 19.1.2

validating, 2.5, 19, 20

OLAP performance views, 6.1

OLAP_API_SESSION_INIT package, 25

OLAP_EXPRESSION function, 21.3.2

OLAP_EXPRESSION_BOOL function, 21.3.2

OLAP_EXPRESSION_DATE function, 21.3.2

OLAP_EXPRESSION_TEXT function, 21.3.2

OLAP_PAGE_POOL_SIZE parameter, 6.5

OLAP_TABLE

data type conversions, 26

OLAP_TABLE function

about, 26

custom measures, 21.3.2, 21.3.2, 21.3.2, 21.3.2

retrieving session log, 21.3.2

syntax, 26

optimization

OLAP API, 25, 25.1

Oracle Enterprise Manager, 1.1.1

Oracle Warehouse Builder, 1.1.1

OUTFILE command

affect on DBMS_AW procedure, 21.3.2

P

P_DISPLAY_NAME, 4.17, 23.1

page pool

performance statistics, 6.5

Parent ET Key, 11.1, 14.1

Parent Grouping ID, 11.1, 14.1

PARENTGID subclause (limit maps), 26

performance counters, 6

PGA allocation, 6.5

POSTDMLCMD clause (limit maps), 26

PREDMLCMD clause (limit maps), 26

print buffer, 21.3.2

Prior Period, 11.1, 14.1

properties

obtaining in SQL, 4.19

Q

quotation marks

in OLAP DML, 21.1.2

R

relational source cube, 1.1

relational target cube, 1.1

reserved dimension attributes, 11.1

reserved level attributes, 14.1

rollup form

defined, 26

ROW2CELL clause (limit maps), 26

S

segwidth, 23.1

SERVEROUTPUT option, 1.3, 1.4, 2.5.1, 2.7, 2.7, 21.3.2, 21.3.2

session cache

performance statistics, 6.5

session counters, 6.8

session logs

printing, 21.3.2

retrieving, 21.3.2, 21.3.2

session statistics, 6.7

Short Description, 11.1, 14.1

snowflake schema, 2.4.1.1

solved data, 1.1, 1.7, 1.7.8, 1.7.9, 2.4.2

solved_code, 2.4.2

sparse data, 1.5, 23.1

SQL

embedding OLAP commands, 21

star schema, 2.4.1.1

T

table type

syntax for creating, 26

time dimensions

creating, 2.2.3

Time Span, 11.1, 14.1

time-span attribute, 19.1.3

transaction statistics, 6.8

U

UNIQUE_RDBMS_KEY, 4.17, 23.1

unsolved data, 1.1, 2.4.2

UTL_FILE_DIR parameter, 1.7.1, 2.7, 17.1, 17.4.2, 23.1, 23.1, 23.1, 23.1, 24.2.1, 24.3, 24.3, 24.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 metadata, 2.5

views

Active Catalog, 3

analytic workspace maintenance information, 4

creating embedded total dimensions, 1.7.8

creating for analytic workspaces, 1.7

objects in analytic workspaces, 3

OLAP Catalog metadata, 5

W

workspace objects

obtaining names in SQL, 4.18

Y

Year Ago Period, 11.1, 14.1