Index

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

A

access rights, 12.3.3

active catalogs, 7.1.3

aggmap see also aggregation maps, 8.8.2

AGGREGATE function

in formulas, 9.3.2

aggregating data

on-the-fly, 6.6.1

precomputing, 6.6.1

aggregation commands

OLAP DML, 7.2.2.8

aggregation maps

database standard form, 8.8.2

aggregation operators

in analytic workspaces, 6.6.4.2

aggregation plans

creating, 6.6.4

described, 6.6.3

ALL_ATTRIBUTES dimension, 8.6.2.1, A.5.1.6

ALL_ATTRTYPES dimension, A.5.2.3

ALL_CUBES dimension, 8.8.4.1, A.5.1.1

ALL_DESCRIPTIONS variable, 8.3.2.2, 8.4.5.2, 8.5.4.2, 8.6.2.2, 8.7.3.2, 8.8.4.2, 9.3.3.2, A.6.1

ALL_DESCTYPES dimension, A.5.2.2

ALL_DIMENSIONS dimension, 8.3.2.1, A.5.1.3

ALL_HIERARCHIES dimension, 8.4.5.1, A.5.1.4

ALL_LANGUAGES dimension, 8.6.1, A.5.2.5

ALL_LEVELS dimension, 8.5.4.1, A.5.1.5

ALL_MEASURES dimension, 8.7.3.1, 9.3.3.1, A.5.1.2

ALL_OBJECTS dimension, A.5.1.7

ALL_OBJTYPES dimension, A.5.2.1

ALL_OLAP2_AW views, 7.1.3

allocation, B.3

allocation commands

OLAP DML, 7.2.2.7

ALTER SESSION commands, 12.5

Analytic Workspace Java API, 5.1.1.3

Analytic Workspace Manager, 6

analytic workspaces

aggregation plans, 6.6.4

basic process overview, 1.6

basic steps for creating, 6.3.5

common uses, 1.4

database storage, 12.7.1

defined, 1.5.2

enabling for Discoverer, 6.8.1, 6.8.3

enabling for OLAP API, 6.8.1

maintaining, 6.9

object relationships, 2.3.2

standard form, 6.3

applications

differences from Express, B.2.1

assignment statements, 9.3.3.2.3

ATTR_INHIER variable

database standard form, A.6.2

ATTRDEF object, A.4.3.7

attributes

See Also dimension attributes

See Also level attributes

analytic workspace, 2.3.4.2

creating logical, 5.4.2.3, 5.6.1

database standard form, 8.6

logical, 2.1.5

authentication, 12.3

AW$ tables, 12.7.2

AW$CLASS property, A.3.2

AW$CREATEDBY property, A.3.2

AW$LASTMODIFIED property, A.3.2

AW$LOADPRGS property, 6.9.2

AW$ROLE property, A.3.3

AW$STATE property, A.3.2

AW_COMPSPECS variable, A.5.4.2

AW_LOOPSPECS variable, A.5.4.3

AW_NAMES variable, 8.3.2.3, 8.6.2.3, 8.7.3.3, 8.8.4.3, 9.3.3.3, A.5.4.1

AW_ROLES dimension, A.5.2.4

AWXML package, 5.1.1.3

B

batch window for aggregation, 6.6.1

BFILE security, 12.6

BI Beans

described, 4.1.2, 4.2

enabling analytic workspaces, 6.8.2

relational data source, 4.4

relational data sources

See also OLAP API

build options

for analytic workspaces, 6.3.3

C

caches

use in iterative queries, 4.3.3

calculation engine

defined, 1.5.1

catalogs

AWCREATE, 8.11

database standard form, 8.9

OLAP API enabler, 8.10

catalogs class

database standard form, A.5

CHANNEL_DIM table

described, 3.2.4

character sets, B.1.4

CHARSET option, B.1.4

classes

database standard form, A.1.4

COMMIT command, B.3.3

composites

database standard form, 8.8.3

defining, 6.3.2.1

COMSPEC object, A.4.2.2

configuration procedures, 12.1

conjoints, B.3.2

CONNECT role, 12.3.3

connect string

for Analytic Workspace Manager, 6.2.4

CREATE_DB_STDFORM program, B.4.1

crosstab bean, 4.2.5

cube dimensions

described, 8.8.1

cube refresh

basic steps, 6.9.2

CUBE_MEASURES valueset, 8.7.3.4, 8.8.4.4, 9.3.3.4, A.5.3.1

CUBEDEF dimension, A.1.3.1, A.4.1.1

cubes

database standard form, 8.8

defined, 5.4.3

logical, 2.3.1

cursors, 4.3.3

CUST_MEAS columns, 7.3

custom measures

BI Beans support, 4.2.8

managing, 7.2

syntax for DBMS_AW_UTILITIES, 7.3

views of mappings, 7.3

CUSTOMER_DIM table

described, 3.2.2

CWM2

described, 1.5.5

write APIs, 5.6.1

CWM2_OLAP_CATALOG package, 5.6.5

CWM2_OLAP_CUBE package, 5.6.2

CWM2_OLAP_DIMENSION package, 5.6.1

CWM2_OLAP_HIERARCHY package, 5.6.1

CWM2_OLAP_LEVEL package, 5.6.1

CWM2_OLAP_LEVEL_ATTRIBUTE package, 5.6.1

CWM2_OLAP_MEASURE package, 5.6.2

CWM2_OLAP_PC_TRANSFORM package, 5.6.4

CWM2_OLAP_VALIDATE package, 5.6.5

D

data dictionary

see active catalogs

data formatting, 4.2.3

data models, 2.1

data refreshes, 6.9.1

data striping, 12.2

database configuration, 12.1

database security, 12.3

database standard form

basics, 9.1

creating new measures, 9.3

described, 8.1.1

extensions, 8.1.3

specification, A

DB_CACHE_SIZE parameter, 12.4

DBMS_AW package

described, 1.5.5, 7.1.1

EXECUTE procedure, 9.2.3

executing OLAP DML commands, 9.2

managing custom measures, 7.2.1

DBMS_AW_UTILITIES package

described, 1.5.5, 7.1.1

managing custom measures, 7.2.1

DBMS_AWM package

described, 1.5.5, 7.1.1

DEFAULT_HIER relation, 8.4.5.4, A.6.3

demand planning systems, 1.3

DIM_ATTRIBUTES valueset, A.5.3.4

DIM_HIERARCHIES valueset, 8.4.5.3, A.5.3.2

DIM_LEVELS valueset, 8.3.2.4, 8.5.4.3, A.5.3.3

DIMDEF dimension, A.1.3.3, A.4.3.1

dimension hierarchies

See hierarchies

dimension members

selecting, 9.3.3.2.1

dimension order

basic rules, 6.3.2.2

dimension tables

defining metadata, 5.4.2.1

described, 2.2.1

dimensions

analytic workspace, 2.3.3

creating logical, 5.4.2.3

database standard form, 8.3

logical, 2.1.3, 5.4.2.1

relational, 2.2.1

time, 5.4.2.2

directories

database, 12.6

Discoverer

enabling analytic workspaces, 6.8.3

drilling, 4.2.2

dynamic performance tables, 12.8

E

EDDE.HIERMNT program (obsolete), B.4.4

EDDE.MSG program (obsolete), B.4.4

EEX file

generating for analytic workspaces, 6.8.3

EIF files, B.4

enablement

analytic workspace, 6.8.1

creating OLAP Catalog metadata, 6.8.2.2

creating views for the OLAP API, 6.8.2.1

End User Layer (EUL)

creating for analytic workspaces, 6.8.3

Express Connection Utility (obsolete), B.2.1

Express databases

converting to standard form, B.4

Express Relational Access Administrator (obsolete), B.1.3

Express Relational Access Manager (obsolete), B.1.3

EXTCALL (obsolete), B.3.2

extensions class

database standard form, A.7

F

fact tables

defining metadata, 5.4.3

described, 2.2.2

familyrel relation

database standard form, 8.5.3

fastest varying dimension, 6.3.2.1

features class

database standard form, A.6

files

allowing access, 12.6

financial applications, 1.3

financial operations

OLAP DML, 7.2.2.3

forecasting commands

OLAP DML, 7.2.2.1, 10.1

formatting

data, 4.2.3

formulas

analytic workspace, 2.3.5

defining, 9.3.2

G

Global star schema

described, 3.2

GLOBAL_AW user

defining, 6.4.1

globalization, B.1.4

Globalization Technology See NLS

GLOBALX tables, C.2

graph bean, 4.2.4

H

HIER_LEVELS valueset, A.4.3.6

hierarchies

analytic workspace, 2.3.3.1

creating logical, 5.4.2.3

database standard form, 8.4

logical, 2.1.4

hierarchy dimension

see also hierlist dimension

HIERLEVELS valueset, A.1.3.3

HIERLIST dimension, A.1.3.3, A.4.3.2

database standard form, 8.4.1

for attributes, 8.6

I

IDE

defined, 4.1.3

implementation class

database standard form, A.4

inhier variables

database standard form, 8.4.4

in-hierarchy variables

see also inhier variables

initialization parameters, 12.5

init.ora file, 12.4, 12.4

J

Java

described, 4.1

sandbox security, 4.1.1

JDeveloper, 4.1.3

L

LAG function

OLAP DML, 7.8.1

language support, B.1.4

level dimension

see also levellist dimension

level relation see also levelrel relation

level relations

described, 2.3.6

LEVELLIST dimension, A.1.3.3, A.4.3.3

database standard form, 8.5.1

LEVELREL relation, 8.5.2, A.1.3.3, A.4.3.4

levels

analytic workspace, 2.3.3.1

creating logical, 5.4.2.3

database standard form, 8.5

logical, 2.1.4

LIMIT command, 9.3.3.2.1

load programs, 6.9.2

editing, 6.9.3

localization, B.1.4

log files

generating in Analytic Workspace Manager, 6.3.5

LOOPSPEC composite, A.4.1.2

M

materialized views

CWM2, 13.5

described, 2.2.3

grouping sets, 13.5

MDI

defined, 4.1.3

MEASUREDEF object, A.1.3.2, A.4.2.1

measures

analytic workspace, 2.3.4.1

custom, 4.2.8

database standard form, 8.7

logical, 2.1.2

relational, 2.2.2

MEMBER_CREATEDBY variable, A.6.6

MEMBER_FAMILYREL relation, A.6.7

MEMBER_INHIER variable, A.6.5

MODEL clause (SELECT), 7.7.4

modeling commands

OLAP DML, 7.2.2.9

modeling support, B.3

MR_REFRESH procedure, 7.8.4

multibyte character sets

Express equivalents, B.1.4

N

naming conventions

database standard form, A.2

naming restrictions

for analytic workspaces, 6.3.1

NLS_LANG configuration parameter, B.1.4

n-pass functions, 4.3.2

number formatting, 4.2.3

numeric functions

OLAP DML, 7.2.2.5

O

object-oriented programming, 4.3

ODBC (obsolete), B.3.2

ODBC support (obsolete), B.1.3

oescmd program (obsolete), B.1.1

oesmgr program (obsolete), B.1.1

OLAP

defined, 1.2

OLAP API

described, 1.5.9, 4.1.2, 4.3

enabling analytic workspaces, 6.8.2

relational data source, 4.4

See also BI Beans

OLAP Beans, 4.2, 4.2.7

OLAP Catalog

CWM2 sample scripts, 7.8.4

described, 1.5

metadata model tables, 5.2.1

read APIs, 5.2.1

sample scripts, C.3

uses for analytic workspaces, 5.2

uses for relational tables, 5.2

write APIs, 5.2.1

OLAP DML

described, 1.5.6

editing programs, 9.2.2.2

executing commands, 9.2

executing in OLAP Worksheet, 9.2.2

special symbols, 9.4.3

SQL interface, 7.1.1

using in OLAP Worksheet, 6.2.2

OLAP Instance Manager (obsolete), B.1.1, B.1.1

OLAP Management tool, 5.4

OLAP metadata

creating in Enterprise Manager, 5.4

creating with CWM2 APIs, 5.6

materialized views, 13.2.2

steps for creating, 5.2.2

viewing in Analytic Workspace Manager, 6.2.1

OLAP Worksheet, B.2.2

described, 6.2.3

opening in Analytic Workspace Manager, 6.2.2

session sharing, 6.2

OLAP_PAGE_POOL_SIZE, 12.4.2

OLAP_TABLE

optimization, 7.7.4

OLAP_TABLE function, 7.7

described, 7.1.2

OLTP

defined, 1.2

operating system commands (obsolete in OLAP DML), B.3.2

operators

OLAP DML, 7.2.2

optimization techniques, 12.2

P

page pool

for ORACLE OLAP, 12.4.2

paging, 4.2.2

PARALLEL_MAX_SERVERS parameter, 12.4

parameter file, 12.4

parent relations

described, 2.3.6

see also parentrel relations

parent-child relations

described, 2.1.4

PARENTREL relation, A.1.3.3, A.4.3.5

parentrel relations

database standard form, 8.4.2

partitioning, 12.7.1

performance counters, 12.8

Personal Express (obsolete), B.2.1

pfile settings, 12.4

PGA allocation, 12.4.2

PGA_AGGREGATE_TARGET parameter, 12.4

pivoting, 4.2.2

predictive analysis applications, 1.3

Presentation Beans, 4.2

PRICE_AND_COST_HISTORY_FACT table

described, 3.2.6

mapping to workspace objects, 3.3.3

PRICE_AND_COST_UPDATE_FACT table

described, 3.2.6

PRODUCT_DIM table

described, 3.2.3

mapping to workspace objects, 3.3.1

programs

editing OLAP DML, 9.2.3.2

executing OLAP DML, 9.2.2.2

PS$ tables, 12.7.2

Q

qualified data references (QDRs), 9.3.3.2.2

query builder, 4.2.8

QUERY REWRITE system privilege, 12.3.3

R

rank formatting, 4.2.3

referential integrity, 2.3.3

refresh process

analytic workspace data, 6.9.2

regressions

OLAP DML, 7.2.2.1, 10.1

Relational Access Administrator (obsolete), B.1.3

Relational Access Manager (obsolete), B.1.3

relational data sources, 4.4

relations

analytic workspace, 2.3.6

result sets, 4.3.3

roles, 12.3.3

ROLLUP command, B.3.2, B.4.1.1

run-time aggregation, 6.6.1

S

schemas

star, snowflake, 5.4

segment size

basic rules, 6.3.2.3

SEGWIDTH

see segment size

SELECT privilege, 12.3.3

SELECT statement

MODEL clause, 7.7.4

server parameter file, 12.4

session sharing, B.2.2

SESSIONS parameter, 12.4

simultaneous equations, 7.2.2.9

slowest varying dimension, 6.3.2.1

SNAPI (obsolete), B.3.2

SNAPI communications (obsolete), B.2.2

sparsity characteristics, 6.4.2, 6.5.3

SPLExecutor class

executing OLAP DML commands, 9.2

SQL command (OLAP DML), B.1.3

SQL interface, 1.5.5

SQL*Plus session settings, 7.8.4

standard form

see database standard form

star schema

described, 2.2

startup parameters

database, 6.5.1

statistical operations

OLAP DML, 7.2.2.4

stoplight formatting, 4.2.3

string functions

OLAP DML, 7.2.2.6

striping, 12.2

system properties

database standard form, A.3.2

T

table bean, 4.2.6

tablespaces

defining, 6.5.2, C.1

for analytic workspaces, 12.2

text manipulation

OLAP DML, 7.2.2.6

Time attributes

creating for converted Express databases, B.4.3

time dimensions, 5.4.2.2

time series functions

OLAP DML, 7.2.2.2

TIME_DIM table

described, 3.2.1

mapping to workspace objects, 3.3.2

translation tables, B.1.4

tuples

in composites, 6.3.2.1

U

Unicode, B.1.4

UNITS_HISTORY_FACT table

described, 3.2.5

UNITS_UPDATE_FACT table

described, 3.2.5

UPDATE command, B.3.3

user access

sample scripts, C.1

user access rights, 12.3.3

user names, 12.3

V

variables

analytic workspace, 2.3.4

targeting cells, 9.3.3.2.2

views

creating for Discoverer, 6.8.4.1

template for creating, 7.7.3

VISIBLE variable, A.6.4

W

wizards

Analytic Workspace Manager, 6.3.5

BI Beans, 4.2.8

X

XCA (obsolete), B.3.2

XCA (unsupported), B.2.2

XML metadata, 5.1.1.3

XPDDDATA database (obsolete), B.4.4