Oracle9i OLAP User's Guide -- Index

abstract data types

See object types

access rights, 5-3, 6-9

ADD_ALTER_SESSION procedure, 8-3

administration privileges, 5-3

ADT, 3-2, 9-2, 12-9, 12-10

aggregate cache

performance statistics, 7-3

aggregation, 2-4, 9-2, 10-2, A-5

ALL_OLAP2 views, 14-1 to 14-16, 24-2

allocation, 2-4, A-5

ALTER SESSION commands, 6-4, 8-2

analytic workspaces

creating from relational tables, 9-1 to 9-7

creating metadata for, 5-5, 9-1, 15-1

data manipulation, 2-2

database storage, 6-12

defined, 1-6

enabling for SQL access, 3-3, 9-4, 15-2, 15-3, 16-1, 16-6, 16-13, 25-2

performance counters, 7-5

applications

business analysis, 1-3

comparison, 1-8

components of SQL-based, 3-2

differences from Express, A-4

ATTRIBUTE subclause (limit maps), 12-18

attributes

See Also dimension attributes

See Also level attributes

creating, 5-8, 5-10

defined, 4-14

in an object type, 12-9

in analytic workspaces, 12-8

viewing, 14-10

authentication, 6-9

AW$ tables, 6-12

BFILE security, 6-10

BI Beans

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

thick-client configuration, 3-7

thin-client configuration, 3-9

caches

performance statistics, 7-3

use in iterative queries, 3-15

calculation engine

defined, 1-6

calculations

runtime, 2-2

catalogs

See measure folders

character sets, A-3

CHARSET option, A-3

CLEAN_ALTER_SESSION procedure, 8-6

composite dimensions, 12-3

configuration procedures, 6-2

conjoint dimensions, 12-3

CONNECT role, 6-9

CreateAWAccessStructures procedure, 15-18

CreateAWAccessStructures_FR procedure, 15-13, 15-17

CREATECUBELEVELTUPLE procedure, 30-12

CREATEDIMLEVTUPLE procedure, 30-11

CREATEDIMMV_GS procedure, 30-14

CREATEFACTMV_GS procedure, 30-13

crosstab bean, 3-11

Cube Viewer, 5-9

cubes

creating, 13-3, 17-1, 17-2

defined, 4-14, 5-8

in analytic workspaces, 9-1 to 9-7

materialized views, 10-5, 30-1 to 30-14, 31-1 to 31-11

viewing, 5-9, 14-5

cursors, 3-15

custom aggregates, 2-3

custom measures, 3-12

CWM_CLASSIFY package, 5-11, 28-1 to 28-18

subprograms, 28-3

CWM2, 5-4 to 5-5, 5-9

write APIs, 5-10, 13-1 to 13-12

CWM2_OLAP_AW_ACCESS package, 3-3, 5-5, 5-11, 15-1 to 15-18

subprograms, 15-16

CWM2_OLAP_AW_CREATE package, 3-3, 5-5, 9-2

CWM2_OLAP_CUBE package, 5-10, 17-1 to 17-13

subprograms, 17-2

CWM2_OLAP_DIMENSION package, 5-10, 18-1 to 18-11

subprograms, 16-2, 18-2, 24-3

CWM2_OLAP_DIMENSION_ATTRIBUTE package, 19-1 to 19-11

subprograms, 19-3

CWM2_OLAP_HIERARCHY package, 5-10, 20-1 to 20-12

subprograms, 20-2

CWM2_OLAP_LEVEL package, 5-10, 21-1 to 21-13

subprograms, 21-2

CWM2_OLAP_LEVEL_ATTRIBUTE package, 5-10, 22-1 to 22-13

subprograms, 22-3

CWM2_OLAP_MEASURE package, 5-10, 23-1 to 23-9

subprograms, 23-2

CWM2_OLAP_METADATA_REFRESH package, 24-1

CWM2_OLAP_PC_TRANSFORM package, 5-5, 5-11, 25-1 to 25-8

CWM2_OLAP_TABLE_MAP package, 26-1 to 26-22

CWM2_OLAP_VALIDATE package, 5-11

data exchange commands, 2-5

data formatting, 3-10

data selection commands, 2-5

data storage, 4-7

data striping, 6-6

database cache, 7-3

database configuration, 6-2

database initialization, 8-1, 8-2

database security, 6-9

DB_CACHE_SIZE parameter, 6-3, 6-4

DBMS_AW package, 2-9, 3-4, 5-5

EXECUTE procedure, 11-3

GETLOG function, 11-5

INTERP function, 11-8

INTERP_SILENT function, 11-6

INTERPCLOB function, 11-10

overview, 11-1 to 11-2

PRINTLOG procedure, 11-16

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

subprograms, 30-11

DELETE_ALTER_SESSION procedure, 8-5

demand planning systems, 1-4

derived data, 4-4

dimension alias, 14-6

dimension attributes

creating, 19-1

defined, 4-14

viewing, 14-9

DIMENSION clause (limit maps), 12-16

dimension hierarchies

See hierarchies

dimension tables, 4-4, 5-7, 13-4

dimension views

defining for workspace objects, 9-5, 15-5

dimensions

analytic workspace, 12-3

creating, 5-7, 5-8, 13-2, 18-1

defined, 4-10

embedded-total, 25-5

exposing in views, 12-3

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

parent-child, 25-1

time, 4-10, 5-7

valid, 13-6

viewing, 14-7

directory aliases, 6-10

drilling, 3-10

dynamic performance tables, 6-13

dynamic performance views, 7-1 to 7-6

embedded total dimension views

creating, 9-5, 12-20, 15-5

end-date attribute, 4-11

ETL process, 2-2

ETT tool, 4-2

EXECUTE procedure, 11-3

Express Connection Utility (obsolete), A-5

Express databases, A-6

Express Relational Access Administrator (obsolete), A-3

Express Relational Access Manager (obsolete), A-3

fact tables, 4-4, 4-9, 5-4, 5-8, 13-4, 14-16

joining with dimension tables, 13-5

supported configurations, 13-5

fact views

defining from workspace objects, 9-6, 15-8

FAMILYREL subclause (limit maps), 12-17

FETCH command (DML), 12-14

file read/write commands, 2-5

files

allowing access, 6-10

financial applications, 1-3

financial operations, 2-6

fixed views, 7-2

forecasting commands, 2-6

formatting

data, 3-10

GETLOG function, 11-5

GID

See grouping IDs

GID subclause (limit maps), 12-17

globalization, A-3

Globalization Technology . See NLS

graph bean, 3-11

grouping IDs, 9-5, 9-6, 12-6, 14-15, 15-6, 15-12, 25-5

parent, 9-5, 12-7, 15-6

GROUPINGID command, 12-6

hierarchical dimensions, 12-3

hierarchies

creating, 5-8, 20-1

custom sorting, 14-14, 26-6

defined, 4-13, 20-2

viewing, 14-8, 14-10, 14-14

hierarchy dimension

defined, 12-4

HIERARCHY subclause (limit maps), 12-16

HIERHEIGHT command, 12-7

historical data, 4-3

IDE

defined, 3-6

INHIERARCHY subclause (limit maps), 12-17

inhierarchy variables, 12-5

initialization parameters, ?? to ?? to 6-5, 8-1, 8-2

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

INTERP function, 11-8

INTERP_SILENT function, 11-6

INTERPCLOB function, 11-10

Java

described, 3-4

sandbox security, 3-5

JDeveloper, 3-6

language support, A-3

level attributes

creating, 22-1

defined, 4-14, 22-2

viewing, 14-9, 14-12

level dimensions, 12-5

levels

creating, 5-8, 21-1

defined, 4-13

viewing, 14-8

limit maps, 12-14 to 12-18

syntax, 12-14

localization, A-3

login names, 6-9

lookup tables

See dimension tables

LOOP clause (limit maps), 12-18

materialized views, 4-4

asymmetric materialization, 10-7

concatenated rollup, 10-3, 10-6, 31-1 to 31-11

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

CWM2, 30-2

defined, 10-2

dimensions, 29-1 to 29-11

for OLAP API, 10-1 to 10-7

grouping sets, 10-3, 10-6, 30-2 to 30-14

MDI

defined, 3-6

MEASURE clause (limit maps), 12-15

measure folders, 28-2

creating, 28-1

defined, 14-11

viewing, 14-11

measures

analytic workspace, 12-3

creating, 23-1

custom, 3-12

defined, 4-9, 23-2

exposing in a view, 12-3

viewing, 14-5

metadata

defined, 4-4, 4-8

modeling commands, 2-7

modeling support, A-5

MR_REFRESH Procedure, 24-3

MRV_OLAP views, 24-2

multibyte character sets

Express equivalents, A-4

multidimensional data

enabling for SQL access, 9-1, 9-4, 15-1, 16-1, 16-6, 16-13

NLS_LANG configuration parameter, A-3

n-pass functions, 3-15

number formatting, 3-10

numeric computation, 2-7

object types, 3-2, 9-2, 12-9, 12-10

object-oriented programming, 3-12

ODBC support (obsolete), A-3

oescmd program (obsolete), A-2

oesmgr program (obsolete), A-2

OLAP

defined, 1-2

OLAP API

defined, 1-7

described, 3-6, 3-12

OLAP API optimization, 8-1, 8-2

OLAP beans, 3-7, 3-12

OLAP Catalog

accessing, 5-3

classification system, 14-11

defined, 1-8, 5-2

metadata entities, 13-2

metadata model tables, 5-2

preprocessors, 25-1

read APIs, 5-3, 13-8, 14-1, 24-1

refreshing views for OLAP API, 24-1

viewing, 13-8, 14-1, 24-1

write APIs, 5-3, 13-1 to 13-12

OLAP commands

executing in SQL, 11-3, 11-6, 11-8, 11-10, 11-16

OLAP DML

defined, 1-6

described, 2-1 to 2-9

executing commands, 2-9

OLAP Instance Manager (obsolete), A-2

OLAP Management tool, 5-6

OLAP metadata

creating for a dimension table, 13-8

creating for a fact table, 13-11

creating for CWM2_OLAP_AW_CREATE, 9-3

creating in Enterprise Manager, 5-6

creating with CWM2 APIs, 5-9

logical steps for creating, 5-3

mapping, 13-4, 13-10 to 13-12, 14-12, 14-13

materialized views, 10-4

tools for creating, 5-2

validating, 13-5, 27-1

warehouse requirements, 5-4

OLAP performance views, 7-2

OLAP Summary Advisor, 10-4, 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-3

OLAP_PAGE_POOL_SIZE, 6-4

OLAP_TABLE function

about, 12-1 to 12-23

in SELECT statement, 12-10

retrieving session log, 11-5

syntax, 12-12

uses, 3-4

OLAP2_CATALOG_ENTITY_USES view, 14-11

OLAP2_CATALOGS view, 14-11

OLAP2_CUBE_DIM_USES view, 14-6

OLAP2_CUBE_MEAS_DIM_USES view, 14-6

OLAP2_CUBE_MEASURE_MAPS view, 14-12

OLAP2_CUBE_MEASURES view, 14-5

OLAP2_CUBES view, 14-5

OLAP2_DIM_ATTR_USES view, 14-10

OLAP2_DIM_ATTRIBUTES view, 14-9

OLAP2_DIM_HIER_LEVEL_USES view, 14-10

OLAP2_DIM_HIERARCHIES view, 14-8

OLAP2_DIM_LEVEL_ATTR_MAPS view, 14-12

OLAP2_DIM_LEVEL_ATTRIBUTES view, 14-9

OLAP2_DIM_LEVELS view, 14-8

OLAP2_DIMENSIONS view, 14-7

OLAP2_FACT_LEVEL_USES view, 14-16

OLAP2_FACT_TABLE_GID view, 14-15

OLAP2_HIER_CUSTOM_SORT view, 14-14

OLAP2_JOIN_KEY_COLUMN_USES view, 14-14

OLAP2_LEVEL_KEY_COLUMN_USES view, 14-13

OLAPSYS user, 5-3

OLTP

defined, 1-2

optimization

OLAP API, 8-1, 8-2

optimization techniques, 6-5

Oracle Globalization Support

See also NLS, i-xxxv

OUTFILE command

affect on DBMS_AW procedure, 11-4

page pool

for ORACLE OLAP, 6-4

performance statistics, 7-3

paging

described, 3-10

parallel_max_servers parameter, 6-3

parameter file, 6-3

parent-child relations, 12-4

defined, 12-4

PARENTGID subclause (limit maps), 12-17

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

Personal Express (obsolete), A-5

pfile settings, 6-3

PGA allocation, 6-4, 7-3

pivoting

described, 3-10

POSTDMLCMD clause (limit maps), 12-18

predictive analytsis applications, 1-3

PREDMLCMD clause (limit maps), 12-18

Presentation Beans, 3-7

print buffer, 11-3

PRINTLOG procedure, 11-16

PS$ tables, 6-12

query builder, 3-12

QUERY REWRITE system privilege, 6-9

querying methods, 1-9

quotation marks

in OLAP DML, 11-3

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-15

roles, 6-9

rollup form

defined, 12-17

row

defining, 12-9

ROW2CELL clause (limit maps), 12-18

schemas

star, snowflake defined, 4-6

star,snowflake, 5-4, 5-6

SELECT privilege, 6-9

server parameter file, 6-3

SERVEROUTPUT option, 11-3, 11-16

session cache

performance statistics, 7-3

session counters, 7-6

session logs

printing, 11-16

retrieving, 11-5

session sharing, A-5

session statistics, 7-5

sessions parameter, 6-3

simultaneous equations, 2-7

SNAPI communications (obsolete), A-5

SPLExecutor class, 2-9

SQL

embedding OLAP commands, 11-3, 11-6, 11-8, 11-10, 11-16

SQL command (OLAP DML), A-3

SQL FETCH command, 2-5

SQL-99 extensions, 1-5

SQL-based applications

components, 3-2

star schema

materialized views, 10-2

statistical operations, 2-8

stoplight formatting, 3-11

striping, 6-6

summary management

See analytic workspaces

See materialized views

summary tables

See materialized views

table

creating from object types, 12-10

table bean, 3-11

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

thin-client applications

defined, 3-5

illustrated, 3-9

tiers, 3-7, 3-9

time dimensions, 4-10, 5-7

time periods

regular, irregular defined, 4-10

time series functions, 2-8

time-span attributes, 4-11

transaction statistics, 7-6

translation tables, A-3

type

creating, 12-10

Unicode, A-4

user access rights, 6-9

user names, 6-9

utl_file_dir parameter, 6-3, 15-2, 25-2

V$AW_CALC view, 7-3

V$AW_OLAP view, 7-5

V$AW_SESSION_INFO view, 7-6

views

creating embedded total dimensions, 9-5, 12-20, 15-5

creating embedded total measures, 12-21

creating for analytic workspaces, 9-4, 15-1, 15-2, 25-2

creating rollup form, 12-23

template for creating, 12-19

wizards

Beans, 3-12

workspaces

See analytic workspaces

XCA support, A-5