Oracle9i OLAP User's Guide -- Index

abstract data types

See object types

access rights, 5-5, 6-9

ADD_ALTER_SESSION procedure, 8-3

administration privileges, 5-4

ADT, 3-2

aggregate cache

performance statistics, 7-3

AGGREGATE command, 9-4

aggregation, 2-4, 9-3, 9-4, 9-9, A-6

ALL$OLAP2_AW_MAP_ATTR_USE view, 14-7

ALL$OLAP2_AW_MAP_DIM_USE view, 14-4

ALL$OLAP2_AW_MAP_HIER_USE view, 14-5

ALL$OLAP2_AW_MAP_LVL_USE view, 14-6

ALL$OLAP2_AW_MAP_MEAS_USE view, 14-4

ALL$OLAP2_AW_PHYS_OBJ view, 14-2

ALL$OLAP2_AW_PHYS_OBJ_EXT view, 14-3

ALL$OLAP2_AW_PHYS_OBJ_PROP view, 14-4

ALL$OLAP2_AW_PHYS_OBJ_REL_OBJ view, 14-3

ALL$OLAP2_CATALOGS view, 13-5

ALL$OLAP2_CUBE_DIM_USES view, 13-6

ALL$OLAP2_CUBE_MEAS_DIM_USES view, 13-6

ALL$OLAP2_CUBE_MEASURE_MAPS view, 13-7

ALL$OLAP2_CUBE_MEASURES view, 13-7

ALL$OLAP2_CUBES view, 13-8

ALL$OLAP2_DIM_ATTR_USES view, 13-8

ALL$OLAP2_DIM_ATTRIBUTES view, 13-9

ALL$OLAP2_DIM_HIER_LEVEL_USES view, 13-9

ALL$OLAP2_DIM_HIERARCHIES view, 13-10

ALL$OLAP2_DIM_LEVEL_ATTR_MAPS view, 13-10

ALL$OLAP2_DIM_LEVEL_ATTRIBUTES view, 13-11

ALL$OLAP2_DIM_LEVELS view, 13-12

ALL$OLAP2_DIMENSIONS view, 13-12

ALL$OLAP2_ENTITY_DESC_USES view, 13-13

ALL$OLAP2_FACT_LEVEL_USES view, 13-14

ALL$OLAP2_FACT_TABLE_GID view, 13-15

ALL$OLAP2_HIER_CUSTOM_SORT view, 13-15

ALL$OLAP2_JOIN_KEY_COLUMN_USES view, 13-16

ALL$OLAP2_LEVEL_KEY_COLUMN_USES view, 13-17

allocation, 2-4, A-6

ALTER SESSION commands, 6-4, 8-2

analytic workspaces, 5-5

accessing from SQL, 15-2

creating from relational tables, 9-1

creating from tables, 9-1

creating metadata for, 5-3, 25-1, 26-1

creating with DML, 9-4

data manipulation, 2-2

data refresh, 9-8

database storage, 6-11

defined, 1-6

metadata in OLAP Catalog, 14-1, 25-1

performance counters, 7-5

preparing for OLAP_TABLE, 11-3

preparing for SQL access, 15-3

applications

business analysis, 1-3

comparison, 1-8

components of SQL-based, 3-2

differences from Express, A-4

attributes, 12-8

See Also dimension attributes

See Also level attributes

creating, 5-9, 5-11, 18-2, 21-2

defined, 4-14

in analytic workspaces, 15-10

authentication, 6-9

AW$ tables, 6-12

BFILE security, 6-9

BI Beans

described, 1-7, 3-6, 3-7

thick-client configuration, 3-8

thin-client configuration, 3-9

caches

performance statistics, 7-3

use in iterative queries, 3-16

calculation engine, 5-5

defined, 1-6

calculations

runtime, 2-2

catalogs

defined, 4-15

character sets, A-3

CHARSET option, A-3

CLEAN_ALTER_SESSION procedure, 8-6

CMW2_OLAP_AW_ACCESS package

generated script example, 15-20

CNV_CWM.TO.ECM program, 3-3, 9-2 to 9-18

syntax, 9-6

composite dimensions, 15-4

configuration procedures, 6-2

conjoint dimensions, 15-4

CONNECT role, 6-9

CreateAWAccessStructures procedure, 9-3

syntax, 15-25

CreateAWAccessStructures_FR procedure

generated script example, 15-20

syntax, 15-24

CREATECUBELEVELTUPLE procedure, 30-12

CREATEDIMLEVTUPLE procedure, 30-11

CREATEDIMMV_GS procedure, 30-14

CREATEFACTMV_GS procedure, 30-13

crosstab bean, 3-12

Cube Viewer, 5-10

cubes, 12-7

creating, 22-3

defined, 4-14, 5-9, 22-2

fact table requirements, 22-2

materialized views, 28-6, 30-1 to 30-14, 31-1 to 31-11

viewing, 5-10

cursors, 3-16

custom aggregates, 2-3

custom measures, 3-13

CWM, 5-2, 5-5, 27-2

See Also OLAP Catalog

CWM Lite

See CWM

CWM_CLASSIFY package, 27-1 to 27-17

subprograms, 27-3

CWM2, 5-2 to 5-3, 5-5, 5-11

See Also OLAP Catalog

views, 13-1

write APIs, 5-11

CWM2_OLAP_AW_ACCESS package, 3-3, 5-3, 15-1 to 15-25

subprograms, 15-23

CWM2_OLAP_AW_MAP package, 5-12, 26-1 to 26-15

subprograms, 26-2

CWM2_OLAP_AW_OBJECT package, 5-4, 5-11, 25-1 to 25-9

subprograms, 25-2

CWM2_OLAP_CUBE package, 5-11, 22-1 to 22-15

subprograms, 22-4

CWM2_OLAP_DIMENSION package, 5-11, 17-1 to 17-13

subprograms, 17-5

CWM2_OLAP_DIMENSION_ATTRIBUTE package, 5-11, 18-1 to 18-11

subprograms, 18-4

CWM2_OLAP_HIERARCHY package, 5-11, 19-1 to 19-12

subprograms, 19-3

CWM2_OLAP_LEVEL package, 5-11, 20-1 to 20-14

subprograms, 20-3

CWM2_OLAP_LEVEL_ATTRIBUTE package, 5-11, 21-1 to 21-13

subprograms, 21-3

CWM2_OLAP_MEASURE package, 5-11, 23-1 to 23-11

subprograms, 23-4

CWM2_OLAP_PC_TRANSFORM package, 5-3, 16-1 to 16-4, 17-2

CWM2_OLAP_TABLE_MAP package, 5-12, 24-1 to 24-23

subprograms, 24-4

data exchange commands, 2-5

data formatting, 3-11

data selection commands, 2-5

data storage, 4-7

data striping, 6-5

database cache, 7-3

database configuration, 6-2

database initialization, 8-1, 8-2

database security, 6-9

DB_CACHE_SIZE parameter, 6-3

DBMS_AW package, 2-9, 3-4

EXECUTE procedure, 10-3, 10-5

GETLOG function, 10-10

INTERP function, 10-6

INTERPCLOB function, 10-8

overview, 10-1, 10-2

PRINTLOG procedure, 10-11

DBMS_ODM package, 28-3, 29-2, 30-1 to 30-14

subprograms, 30-11

DEFINE command, 9-4

DELETE_ALTER_SESSION procedure, 8-5

demand planning systems, 1-4

derived data, 4-4

dimension alias, 12-5

dimension attributes, 12-9, 17-4

creating, 18-2

defined, 4-14, 18-2

dimension hierarchies

See hierarchies

dimension tables, 4-4, 5-8, 12-14, 17-2, 24-2

joining with fact tables, 24-2

dimension views

defining for workspace objects, 15-11

dimensions, 12-13

analytic workspace, 15-4

creating, 5-8, 5-9, 17-3

defined, 4-10, 17-2

embedded-total, 16-2

exposing in views, 15-4

materialized views, 28-4, 29-1 to 29-11

parent/child, 5-3, 16-1

time, 4-11, 5-9, 17-2, 17-3

valid, 17-4

directory aliases, 6-9

drilling

described, 3-11

dynamic performance tables, 6-13

dynamic performance views, 7-1 to 7-6

ECM catalogs, 9-12

end-date attribute, 4-11, 17-3

ETL process, 2-2

ETT tool, 4-2

Express Common Metadata, A-2, A-5

Express Connection Utility (obsolete), A-5

Express databases, A-7

Express Relational Access Administrator, A-3

Express Relational Access Manager, A-3

Express Web Agent support, A-5

fact tables, 4-4, 4-10, 5-9, 12-14, 22-2, 24-2

joining with dimension tables, 24-2

supported configurations, 24-2

fact views

defining from workspace objects, 15-15

file read/write commands, 2-5

files

allowing access, 6-9

financial applications, 1-3

financial operations, 2-6

fixed views, 7-2

forecasting commands, 2-6

formatting

data, 3-11

GENSQLOBJS program, 9-10

gid

See grouping IDs

globalization, A-3

Globalization Technology . See NLS

graph bean, 3-11

grouping IDs, 12-16

parent, 15-8

GROUPINGID command, 11-3, 11-8, 11-11, 15-7

hierarchical dimensions, 15-4

hierarchies, 12-10, 12-17, 17-2, 17-4

creating, 5-9, 19-2

custom sorting, 12-16, 24-8

defined, 4-13, 19-2

hierarchy dimension

defined, 15-4

HIERHEIGHT command, 11-3, 11-11, 15-5, 15-9

historical data, 4-3

IDE

defined, 3-6

in hierarchy variables, 15-6

initialization parameters, 8-1, 8-2

init.ora file, 6-3, 8-2

Instance Manager (obsolete), A-2

Java

described, 3-4

sandbox security, 3-5

Java Database Connectivity, A-5

JDBC communications, A-5

JDeveloper, 3-6

language support, A-3

level attributes, 12-11, 12-12, 17-4

creating, 21-2

defined, 4-14, 21-2

level dimensions, 15-5

levels, 12-12, 17-4

creating, 5-9, 20-2

defined, 4-13, 20-2

defining an integer dimension for, 11-3, 15-5

limit maps

OLAP_TABLE function, 11-7 to 11-10

LISTNAMES VARIABLE command, 9-12

localization, A-3

login names, 6-9

lookup tables

See dimension tables

materialized views, 4-4

asymmetric materialization, 28-8

concatenated rollup, 28-3, 28-7, 31-1 to 31-11

cubes, 30-1 to 30-14, 31-1 to 31-11

CWM2, 30-2

defined, 28-2

dimensions, 29-1 to 29-11

for OLAP API, 28-1 to 28-9

grouping sets, 28-3, 28-7, 30-2 to 30-14, 30-2 to 30-14

MDI

defined, 3-6

measure folders, 12-4, 13-4, 27-2

defined, 4-15, 12-4

measures, 12-7

analytic workspace, 15-3

creating, 23-2

custom, 3-13

defined, 4-9, 22-2, 23-2

exposing in a view, 15-3

metadata

defined, 4-4, 4-8

modeling commands, 2-7

modeling support, A-6

multibyte character sets

Express equivalents, A-4

NLS_LANG configuration parameter, A-3

n-pass functions, 3-16

number formatting, 3-11

numeric computation, 2-7

object types, 3-2

object-oriented programming, 3-13

OCI communications, A-5

ODBC support (obsolete), A-3

oescmd program (obsolete), A-2

oesmgr program (obsolete), A-2

OLADM, 10-3, 10-6, 10-8

OLAP

defined, 1-2

OLAP 1 Catalog

See CWM

OLAP 2 Catalog

See CWM2

OLAP API, 5-5

defined, 1-7

described, 3-6, 3-13

OLAP API optimization, 8-1, 8-2

OLAP beans, 3-7, 3-12

OLAP Catalog, 5-2

classification system, 12-5, 12-14, 13-4, 27-2

CWM, 5-2, 5-7

CWM and CWM2, 5-4, 5-5, 27-2

CWM2 views, 13-3

defined, 1-8, 5-5

metadata model tables, 5-6

preprocessors, 5-6, 16-1, 17-2

read APIs, 5-6, 12-1, 13-1, 14-1

union views, 12-1

write APIs, 5-6

OLAP commands

executing in SQL, 10-3, 10-5, 10-8, 10-10

OLAP DML

defined, 1-6

described, 2-1 to 2-9, 25-2

executing commands, 2-9

OLAP Management tool, 5-7

OLAP metadata

creating for a dimension table, 5-12

creating for a fact table, 5-15

logical steps for creating, 5-6

mapping, 5-14 to 5-16, 12-6, 12-11, 12-18, 17-4, 24-2, 26-2

materialized views, 28-3

tools for creating, 5-2

OLAP performance views, 7-2

OLAP Summary Advisor, 28-3, 29-2, 31-1 to 31-11

OLAP Worksheet, 2-9, A-5

OLAP_API_SESSION_INIT package, 8-1 to 8-7

OLAP_DBA role, 5-4

OLAP_TABLE function, 9-4

example, 11-11

limit map, 11-7 to 11-10

preparing analytic workspace for, 11-3

retrieving session log, 10-10

syntax, 11-5

type definitions, 11-4 to 11-5

use in SELECT statement, 11-2

uses, 3-4

OLAP2_CATALOG_ENTITY_USES view, 12-4

OLAP2_CATALOGS view, 12-4

OLAP2_CUBE_DIM_USES view, 12-5

OLAP2_CUBE_MEAS_DIM_USES view, 12-6

OLAP2_CUBE_MEASURE_MAPS view, 12-6

OLAP2_CUBE_MEASURES view, 12-7

OLAP2_CUBES view, 12-7

OLAP2_DIM_ATTR_USES view, 12-8

OLAP2_DIM_ATTRIBUTES view, 12-9

OLAP2_DIM_HIER_LEVEL_USES view, 12-10

OLAP2_DIM_HIERARCHIES view, 12-10

OLAP2_DIM_LEVEL_ATTR_MAPS view, 12-11

OLAP2_DIM_LEVEL_ATTRIBUTES view, 12-12

OLAP2_DIM_LEVELS view, 12-12

OLAP2_DIMENSIONS view, 12-13

OLAP2_FACT_LEVEL_USES view, 12-14

OLAP2_FACT_TABLE_GID view, 12-16

OLAP2_HIER_CUSTOM_SORT view, 12-16

OLAP2_JOIN_KEY_COLUMN_USES view, 12-17

OLAP2_LEVEL_KEY_COLUMN_USES view, 12-18

OLAPSYS user, 5-4

OLTP

defined, 1-2

optimization

OLAP API, 8-1, 8-2

optimization techniques, 6-5

Oracle Call Interface, A-5

Oracle Globalization Support. See also NLS, xxxv

Oracle Instance Manager (obsolete), A-2

page pool

performance statistics, 7-3

paging

described, 3-11

parallel_max_servers parameter, 6-3

parameter file, 6-3

parent-child relation

defined, 15-5

parent-child relations, 15-5

performance counters, 6-13, 7-1 to 7-6

Personal Express (obsolete), A-5

pfile settings, 6-3

PGA allocation, 7-3

pivoting

described, 3-11

predictive analytsis applications, 1-3

Presentation Beans, 3-7

PS$ tables, 6-12

query builder, 3-13

QUERY REWRITE system privilege, 6-9

querying methods, 1-9

rank formatting, 3-11

referential integrity, 2-3

regressions, 2-6

Relational Access Administrator (obsolete), A-3

Relational Access Manager (obsolete), A-3

reporting applications, 1-3

repository

application runtime, 3-10

result sets, 3-16

roles, 6-9

schemas

star, snowflake defined, 4-6

star,snowflake, 5-2, 5-7

SELECT privilege, 6-9

SELECT statements

using OLAP_TABLE function, 11-2

server parameter file, 6-3

session cache

performance statistics, 7-3

session counters, 7-6

session logs

printing, 10-11

retrieving, 10-10

session sharing, A-5

session statistics, 7-5

sessions parameter, 6-3

simultaneous equations, 2-7

SNAPI communications (obsolete), A-5

SNAPI support (obsolete), A-5

SPLExecutor class, 2-9

SQL

embedding OLAP commands, 10-3, 10-5, 10-8, 10-10

SQL command (OLAP DML), A-3

SQL FETCH command, 2-5, 9-4

SQL IMPORT command, 9-4

SQL-99 extensions, 1-5

SQL-based applications

components, 3-2

star schema

materialized views, 28-2

statistical operations, 2-8

stoplight formatting, 3-11

striping, 6-5

summary management

See materialized views

summary tables

See materialized views

table bean, 3-12

table functions

defined, 1-7, 3-2

tablespaces

for analytic workspaces, 6-5

text manipulation, 2-8

thick-client applications

defined, 3-5

illustrated, 3-8

thin-client applications

defined, 3-5

illustrated, 3-9

tiers, 3-8, 3-9

time dimensions, 4-11, 5-9, 17-2, 17-3

time periods

regular, irregular defined, 4-11

time series functions, 2-8

time-span attributes, 4-11

transaction statistics, 7-6

translation tables, A-3

type definitions

for OLAP_TABLE, 11-4 to 11-5

Unicode, A-4

union views, 12-2

user access rights, 6-9

user names, 6-9

utl_file_dir parameter, 6-3, 15-2

V$AW_CALC view, 7-3

V$AW_OLAP view, 7-5

V$AW_SESSION_INFO view, 7-6

views

analytic workspace metadata objects, 14-1

creating for analytic workspaces, 11-2, 15-1, 15-2

CWM and CWM2, 12-1, 12-2

CWM2, 13-1

wizards

Beans, 3-12

workspaces

See Also analytic workspaces, 9-1

XCA support, A-5