Index

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

Symbols

$AGGMAP property, 5.3

$AGGREGATE_FORCECALC property, 5.3

$AGGREGATE_FORCEORDER property, 5.3, 5.3

$AGGREGATE_FROM property, 5.3, 9.3

$AGGREGATE_FROMVAR property, 5.3

$ALLOCMAP property, 5.3

$COUNTVAR property, 5.3

$DEFAULT_LANGUAGE property, 5.3

$GID_DEPTH property, 5.3

$GID_LIST property, 5.3

$GID_TYPE property, 5.3

$LOOP_AGGMAP property, 5.3

$LOOP_DENSE property, 5.3

$LOOP_VAR property, 5.3, 5.3

$NATRIGGER property

calling recursively, 6.3

executing simultaneously, 6.3

$STORETRIGGERVAL property, 5.3

$VARCACHE property, 5.3

% wildcard, 2.3.8.6.1

& operator, 2.3.10

= command, 10

event, 10, 10, 10

trigger, 10, 10, 10

_ wildcard, 2.3.8.6.1

Numerics

20th century, 9.3

21st century, 9.3

A

ABS function, 7.3

abstract data types, A.1.2, A.2.2

automatic, A.1.2.2, A.2.2

predefining, A.1.2.1, A.2.2

ACQUIRE command, 9.3

ACROSS command, 9.3

ACROSS keyword, 10

$AGGREGATE_FROMVAR property, 5.3, 5.3

= command, 10

FETCH command, 9.3

FILEREAD command, 9.3, 9.3, 10

FILEVIEW command, 9.3

HEADING command, 10

models, 3.3.4.2

REPORT command, 10

ROW command, 10

SQL FETCH command, 10

SQL SELECT command, 10

AD datetime format element, 9.3, 9.3

ADD_DIMENSION_SOURCE procedure (PL/SQL), B.5.2

ADD_MONTHS command, 7.3

ADT

See abstract data types

ADVISE_CUBE procedure (PL/SQL), B.5.2, B.5.2

ADVISE_DIMENSIONALITY function (PL/SQL), B.5.2

ADVISE_DIMENSIONALITY procedure (PL/SQL), B.5.2

ADVISE_REL procedure, B.5.2

ADVISE_REL procedure (PL/SQL), B.5.2

ADVISE_SPARSITY procedure (PL/SQL), B.5.2

Aggcount variables, 7.3, 8, 9.3, 9.3, 9.3, 9.3

AGGINDEX statement, 9.3

AGGMAP ADD model command, 9.3

AGGMAP command, 9.3

aggmap objects

identifying changes, 7.3

AGGMAP REMOVE model command, 9.3

AGGMAP SET command, 9.3

AGGMAPINFO command, 7.3

aggmaps

compiling, 3.4.3, 9.3

defining, 9.3

deleting, 9.3

in formulas, 8

list of, 7.3

See also aggregation specifications, allocation specifications

Aggregate Advisor, 3.4.4, 9.3, 9.3, 9.3, 9.3, B.5

AGGREGATE command, 9.3

AGGREGATE function, 7.3

aggregating data

caching, 6.3

formulas for, 7.3

on-the-fly, 3.4.4

partitioned variables, 8

precomputing, 3.4.4

specifying a relation for, 9.3

using an Aggcount variable, 7.3

using an aggmap object, 3.4.1

using TCONVERT, 8

B

BACK function, 7.3, 7.3, 7.3

BADLINE option, 4.5.2, 6.3

base dimensions

finding values of, 7.3, 7.3

identifying, 7.3

setting status list of, 10

BASEDIM function, 7.3

BASEVAL function, 7.3

BC datetime format element, 9.3, 9.3

BEGINDATE, 7.3

BIN_TO_NUM function, 7.3

binary data, 2.1.6, 2.1.6

BITAND function, 7.3

bits, adding, 7.3

BLANK command, 9.3

blank lines in reports, 9.3

BLANKSTRIP function, 7.3

BMARGIN option, 6.3

Boolean

data type, 2.1.5

expressions, 2.3.8

operators, 2.2.2

values, 6.3, 6.3

branching in programs, 9.3, 9.3, 9.3, 10, 10, 10

BREAK command, 9.3

bucket numbers, retrieving, 8

build number of Oracle OLAP, 7.3

bytes

used by expression, 8

bytes strings, 2.1.6, 2.1.6

C

CACHE statement, 9.3, 9.3, 9.3, 9.3, 9.3

caches

See OLAP session cache

caching, 9.3

calculated members

adding to dimension, 10

identifying, 7.3

calculating a linear regression, 10

CALENDARWEEK option, 6.3

CALL command, 9.3

CALLTYPE function, 7.3

case statement in programs, 10

CATEGORIZE function, 7.3

CDA command, 9.3

CEIL function, 7.3

CHANGEBYTES function, 7.3

CHANGECHARS function, 7.3

CHANGEDRELATIONS function, 7.3

CHANGEDVALIES function, 7.3

character sets, 8, 8

characters

converting, 7.3

representing as decimals, 2.1.2.2

representing as hexadecimals, 2.1.2.2

representing as Unicode, 2.1.2.2

special, 2.1.2.2

CHARLIST function, 7.3

CHGDFN command, 9.3

CHGDIMS function, 7.3

CHILDLOCK statement, 9.3

CHR function, 7.3

CLEANUP command

See SQL command in OLAP DML

CLEAR command, 9.3

CLOSE command

See SQL command in OLAP DML

COALESCE function, 7.3

code comments, 2.1.2.1

columns

default width in reports, 6.3, 6.3

getting value from a report column, 7.3

headings in a report, 10

in reports, 6.3

multiline text, 7.3

COLVAL function, 7.3

COLWIDTH function, 6.3

COMMAS option, 6.3

comments

code, 2.1.2.1

comments in programs, 4.3

COMMIT command, 9.3

comparing

dates, 2.3.8.5

values, 2.3.8.2, 2.3.8.6

comparison operators, 2.2.2

compilable objects, 6.3

COMPILE command, 9.3

COMPILEMESSAGE option, 6.3

COMPILEWARN option, 6.3

compiling, 6.3

aggmaps, 3.4.3

aggregation specifications, 3.4.3

models, 3.3.3

programs, 4.4

SQL statements, 10

suppressing error messages, 6.3

composites, 2.3.2.4

base dimension values, 7.3

changing to conjoint dimensions, 9.3

defining, 1.5.1.2, 1.5.1.2, 9.3, 9.3

deleting, 9.3, 9.3, 9.3, 9.3

deleting values of, 10

index algorithm, 6.3, 6.3

index type (determining), 8

listing associated objects, 10

maintaining, 10

reporting, 10, 10

showing a value, 10

specifying values for, 2.3.2.3.1

specifying values of, 2.3.2.3.1, 2.3.2.3.2

testing for a value, 7.3

unnamed, 9.3

D

data

binary, 2.1.6, 2.1.6

data fetches (SQL), 10

data type conversions, A.2.2

data types

Boolean, 2.1.5

converting, 2.1.8

creating a report, 10, 10

DATE, 2.1.3

date, 2.1.4, 2.1.4, 2.1.4.4

DATETIME, 2.1.4

determining data type of an object, 8

DSINTERVAL, 2.1.4.9

for variables, 9.3

numeric, 2.1.1

of expressions, 2.3.1.1

of numeric expressions, 2.3.4.1

of user-defined function, 4.3.1

qualifying data for expressions, 8

RAW, 2.1.6, 2.1.6

restricting access, 10

ROWID, 2.1.7.1

showing a single value, 10

text, 2.1.2

TIMESTAMP, 2.1.4.5

TIMESTAMP_LTZ, 2.1.4.7

TIMESTAMP_TZ, 2.1.4.6

transferring from one format to another, 8

UROWID, 2.1.7.2

YMINTERVAL, 2.1.4.8

DATABASE command

name change, Preface

See AW command

DATABASE function

name change, Preface

See AW function

database initialization, C, C.1

DATE data types, 2.1.3

date data types, 2.1.4, 2.1.4, 2.1.4.4

date format models, 9.3

long, 9.3

punctuation in, 9.3

short, 9.3

text in, 9.3

DATE_FORMAT, 9.3

DATEFORMAT option, 6.3

DATEORDER option, 6.3

dates, 8, 8

arithmetic, 2.3.6.3

comparing, 2.3.8.5, 2.3.8.5

current, 8, 8

in arithmetic expressions, 2.3.7

in text expressions, 2.3.5.2

datetime arithmetic, 2.3.6.3

datetime data

format of, 9.3

DATETIME data type, 2.3.5.2

DATETIME data types, 2.1.4

datetime expressions, 2.3.6.1

datetime format elements

and Globalization Support, 9.3

capitalization, 9.3

ISO standard, 9.3

RR, 9.3

suffixes, 9.3

datetime values

truncating, 8

DAY datetime format element, 9.3

DAYABBRLEN option, 6.3

DAYNAMES option, 6.3

DAYOF function, 7.3

DBDESCRIBE program

name change, Preface

See AWDESCRIBE program

DBGOUTFILE command, 4.5.3, 9.3

and ECHOPROMPT, 6.3

DBMS_AW package, B

DBMS_AW PL/SQL package

ADD_DIMENSION_SOURCE procedure, B.5.2

ADVISE_CUBE procedure, B.5.2

ADVISE_DIMENSIONALITY function, B.5.2

ADVISE_DIMENSIONALITY procedure, B.5.2

ADVISE_REL procedure, B.5.2

ADVISE_SPARSITY procedure, B.5.2

AW_ATTACH procedure, B.5.2

AW_COPY procedure, B.5.2

AW_CREATE procedure, B.5.2

AW_DELETE procedure, B.5.2

AW_DETACH procedure, B.5.2

AW_RENAME procedure, B.5.2

AW_TABLESPACE function, B.5.2

AW_UPDATE procedure, B.5.2

CONVERT procedure, B.5.2

EVAL_NUMBER function, B.5.2

EVAL_TEXT function, B.5.2

EXECUTE procedure, B.5.2

GETLOG function, B.5.2

INFILE procedure, B.5.2

INTERP function, B.5.2

INTERP_SILENT function, B.5.2

INTERPCLOB function, B.5.2

OLAP_ON function, B.5.2, B.5.2

PRINTLOG procedure, B.5.2

RUN procedure, B.5.2

SHUTDOWN procedure, B.5.2

SPARSITY_ADVICE_TABLE procedure, B.5.2

STARTUP procedure, B.5.2

DBMS_AW$_COLUMNLIST_T table, B.4.2

DBMS_AW$_DIMENSION_SOURCE_T object type, B.4.2

DBMS_AW$_DIMENSION_SOURCES_T table type, B.4.2

DBTIMEZONE function, 7.3

DBWAITTIME option

name change, Preface

See AWWAITTIME option

DDOF function, 7.3

DEADLOCK statement, 9.3

debugging, 6.3

models, 3.3.5

programs, 4.5

decimal data types, comparing, 2.3.8.3.3

decimal marker (displayed), 6.3

decimal places (displayed), 6.3

decimal values, 6.3

decimal marker for output, 6.3

truncating to an integer, 7.3

DECIMALCHAR option, 6.3

DECIMALOVERFLOW option, 6.3

DECIMALS option, 6.3

DECLARE CURSOR command

See SQL command in OLAP DML

DECODE function, 7.3

default

outfile, 10

relations, 2.3.2.3.3, 10

default status list

determining if in effect, 8

DEFAULTAWSEGSIZE option, 6.3

DEFAULTDBFSIZE option

name change, Preface

See DEFAULTAWSEGSIZE option

DEFINE AGGMAP command, 9.3, 9.3

DEFINE command, 9.3

events, 4.8

triggers, 4.8

DEFINE COMPOSITE command, 1.5.1.2, 9.3

DEFINE DIMENSION ALIASOF command, 9.3

DEFINE DIMENSION command, 9.3

DEFINE FORMULA command, 9.3

DEFINE MODEL command, 9.3

DEFINE PARTITION TEMPLATE command, 9.3

DEFINE PROGRAM command, 9.3

DEFINE RELATION command, 9.3

DEFINE SURROGATE command, 9.3, 9.3

DEFINE VALUESET command, 9.3

DEFINE VARIABLE command, 9.3

DEFINE WORKSHEET command, 9.3

defining

aggmap objects, 9.3

alias dimensions, 9.3

analytic workspace objects, 9.3

dimension alias, 9.3

dimensions, 9.3

formulas, 9.3

partitions, 9.3

programs, 9.3

relations, 9.3, 9.3

surrogates, 9.3

valuesets, 9.3, 9.3

variables, 9.3

worksheet objects, 9.3

definitions

copying, 9.3

creating, 9.3

creating object properties, 10

deleting, 9.3

moving within NAME dimension, 10

report of, 9.3, 9.3

testing for, 7.3

DELETE command, 9.3

event, 10, 10

trigger, 10, 10

Delete event, 10

deleting

alias dimensions, 9.3

composite values, 10

composites, 9.3

definitions, 9.3

dimension alias, 9.3

dimension values, 10, 10

dimensions, 9.3

formulas, 9.3

models, 9.3

objects, 9.3

partition templates, 9.3

partitions, 9.3

programs, 9.3

surrogates, 9.3

triggers, 10, 10, 10

valuesets, 9.3

DEPRDECL function, 7.3

DEPRDECLSW function, 7.3

depreciation of assets, 7.3, 7.3, 7.3, 7.3

DEPRSL function, 7.3

DEPRSOYD function, 7.3

DESCRIBE command, 9.3

descriptions

adding to a definition, 10

deleting from a definition, 10

detaching

analytic workspaces, 4.8

dimension alias

See alias dimensions

DIMENSION command, in a model, 10

DIMENSION statement

for aggregation, 9.3

for allocation, 9.3

dimension status

effect on expressions, 2.3.1.2.2

null, 6.3

restoring, 4.3.4.2

saving current, 4.3.4.2

dimension surrogates

assigning values to, 10

defining, 9.3

dimension values

comparing, 2.3.8.4, 2.3.8.4

counting related values, 8

deleting values of, 10, 10

latest value, 8

null, 6.3

number of (determining), 8, 8

number of values in status, 8

place in status list, 8

retrieving current status list

retrieving, 8

returning first value in status, 8

returning last value in status, 8

setting the status of, 10

sorting, 8, 10

testing for, 7.3

using qualified data reference, 8

using result of LIMIT command, 8

dimensionality, changing, 7.3

dimension-based equations, 3.3.1

dimensions

acquired, 7.3

checking status of, 8

comparing values, 2.3.8.4

defining, 9.3, 9.3

defining surrogates for, 9.3

deleting, 9.3, 9.3

determining status of, 8

limiting, 10

limiting to single value, 2.3.2.5

listing associated objects, 10

looping over values of, 9.3, 9.3, 9.3

maintaining, 10

numeric value of text dimension, 2.3.4.2

of expression, 2.3.1.2, 2.3.1.2.1

order in models, 10

QDR with, 2.3.2.5, 2.3.2.5.5

related, 2.3.2.3.3, 10

restoring previous values, 4.3.4.3

saving current values, 4.3.4.3

See also alias dimensions, base dimensions, concat dimensions, conjoint dimensions, simple dimensions

status lists, 8, 8

type of (determining), 8

worksheet, 9.3

E

ECHOPROMPT option, 4.5.3, 6.3

EDIT command, 9.3

editing previously executed commands, 10

EIF file, 4.7.6, 9.3

exporting data from, 9.3

importing data from, 10

EIFBYTES option, 6.3

EIFEXTENSIONPATH option, 6.3

EIFNAMES option, 6.3

EIFSHORTNAMES option, 6.3

EIFTYPES option, 6.3

EIFUPDBYTES option, 6.3

EIFVERSION option, 6.3

embedded-total dimension views, A.2.2

embedded-total fact view, A.2.2

encoding, 8

ENDDATE function, 7.3

ENDOF function, 7.3

EQ command, 9.3

equations, dimension-based, 3.3.1

ERRNAMES option, 6.3

error messages, 10

creating your own, 4.3.5.4

deferring, 4.3.5.1

displaying, 6.3

option holding text of, 6.3

producing without error condition, 10

signaling error condition, 10

suppressing, 4.3.5.3, 6.3

suppressing during compilation, 6.3

wrapping, 6.3

ERRORLOG statement, 9.3

ERRORMASK statement, 9.3

ERRORNAME option, 4.3.5, 6.3

errors

controlling during calculations, 2.3.4.4

handling, 4.3.5

handling in nested programs, 10, 10

handling in programs, 10

name of first-occurring error, 6.3

signaling, 4.3.5.4, 10, 10

SQL error codes, 6.3

when comparing numeric data, 2.3.8.3, 2.3.8.3.2, 2.3.8.3.3

ERRORTEXT option, 4.3.5, 6.3

escape character for LIKE, 6.3

escape sequences, 2.1.2.2, 2.1.2.2

ESCAPEBASE option, 6.3

EVAL_NUMBER function (PL/SQL), B.5.2

EVAL_TEXT function (PL/SQL), B.5.2

events

Assign, 10, 10

assignment statements, 10

Define, 4.8

Delete, 10, 10

deleting, 10, 10, 10

identifying, 8

Maintain, 10, 10

Property, 10, 10

Update, 4.8, 4.8, 10

EVERSION function, 7.3

EVERY function, 7.3

EXECUTE procedure (PL/SQL), B.5.2

EXISTS function, 7.3

EXP function, 7.3

exponential forecasting, 9.3

exponents, retrieving, 7.3

EXPORT command, 4.7.6, 9.3

EXPORT to EIF command, 9.3

EXPORT to spreadsheet command, 9.3

exporting

metadata, 9.3

exporting data, 6.3, 6.3, 9.3

expressions

ampersand substitution, 2.3.10

Boolean, 2.3.8, 2.3.9, 2.3.9, 2.3.9.1

changing dimensionality of, 7.3

comparing, 8

conditional, 2.3.9, 2.3.9

data type of, 2.3.1.1

dates in, 2.3.7

datetime, 2.3.6.1

defined, 2.3

determining dimensions of, 2.3.1.2.1

dimensions of, 2.3.1.2, 2.3.1.2.1

dimensions status, 2.3.1.2.2

empty cells, 2.3.3

internal representation of, 8

interval, 2.3.6.2

NA values in, 2.3.3

numeric, 2.3.4

objects in, 2.3.2

padding, 8, 8

parsing, 10

retrieving largest, 7.3

retrieving smallest, 8

saving, 9.3

size in bytes, 8

substitution, 2.3.10

text, 2.3.5

trimming, 8, 8

using objects in, 2.3.2.4

using qualified data references in, 8

EXPTRACE option, 6.3

EXTBYTES function, 7.3

EXTCHARS function, 7.3

EXTCOLS function, 7.3

EXTLINES function, 7.3

EXTRACT function, 7.3

F

fastest-varying dimension, 9.3

FCCLOSE command, 9.3

FCEXEC command, 9.3

FCOPEN command, 7.3

FCQUERY command, 7.3

FCSET command, 9.3

FETCH command

See SQL command in OLAP DML

FETCH command (OLAP DML), A.2.2, A.2.2

fetching data (SQL), 10

file I/O, 7.3, 7.3, 9.3, 9.3, 9.3, 9.3, 9.3

closing, 7.3, 9.3, 9.3

current directory, 9.3

diagnosing errors when processing, 7.3

forcing a page break, 9.3

gathering information about, 7.3

list of open files, 10

opening, 7.3

processing data from, 9.3

reading a record, 7.3

reading data from, 9.3

reading Oracle OLAP commands from a file, 7.3, 10

records read, 8

setting attributes, 9.3

writing, 9.3

FILECLOSE command, 9.3

FILECOPY command, 9.3

FILEDELETE command, 9.3

FILEERROR function, 7.3

FILEGET function, 7.3

FILEMOVE command, 9.3

FILENEXT function, 7.3

FILEOPEN function, 7.3

FILEPAGE command, 9.3

FILEPUT command, 9.3

FILEQUERY function, 7.3

FILEREAD command, 9.3

files

appending output, 10

importing data from, 10

saving output in, 10

FILESET command, 9.3

fileunits, 7.3, 7.3

attributes, 7.3

number of outfile destination, 6.3

opening, 7.3, 10

reading data from, 9.3

setting attributes, 9.3

FILEVIEW command, 9.3

FILTERLINES function, 7.3

financial analysis, scenario modeling, 3.3.2.6

FINDBYTES function, 7.3

FINDCHARS function, 7.3

FINDLINES function, 7.3

FINTSCHED function, 7.3

floating point numbers, comparing, 2.3.8.3.2

floating-point format

limitations when calculating, 2.3.4.3

use of, 2.3.4.3

FLOOR function, 7.3

FOR command, 9.3, 9.3

breaking out of, 9.3

example of, 9.3

looping over dimension values, 9.3, 9.3, 9.3

used with BREAK, 9.3

used with CONTINUE, 9.3

used with OKFORLIMIT, 6.3

used with TEMPSTAT, 10

FORECAST command, 9.3

FORECAST function, 7.3

forecasting context, 9.3

closing, 9.3

executing, 9.3

opening, 7.3

querying, 7.3

setting characteristics of, 7.3

FORECAST.REPORT program, 9.3, 9.3

format model, 9.3

format models, 2.1.4.2

date

changing, 2.1.4.2, 9.3

default format, 2.1.4.2, 9.3

formats

for dates and numbers. See format models

of return values from the database, 2.1.4.2

of values stored in the database, 2.1.4.2

formatting

datetime data, 9.3

formulas

aggmap objects in, 8

aggregating data with, 7.3

compiling, 6.3, 9.3

defining, 9.3, 9.3

deleting, 9.3, 9.3

expression for (retrieving), 8

recursive, 6.3

specifying new expression, 9.3

FPMTSCHED function, 7.3

FROM_TZ function, 7.3

FULLDSC program, 9.3

functions

calling, 9.3

user-defined, 4.3.1, 4.3.1, 9.3, 10

G

GET function, 7.3

GETLOG function (PL/SQL), B.5.2

GOTO command, 9.3

GREATEST function, 7.3

group marker, 6.3

grouping ids, 5.3, 5.3, 5.3

GROUPINGID command, 9.3

GROUPINGID function, 7.3

GROWRATE function, 7.3

growth rate, 7.3

H

handling errors in programs, 10

hash partitions, 9.3

hash values, 8

heading, 10

for a report, 10

for output pages, 6.3

including a page number, 6.3

producing standard report heading, 10

HEADING command, 10

hexadecimal digits

converting to raw, 7.3

HEXTORAW function, 7.3

HIDE command, 10

hierarchies

shape of, 7.3

hierarchy shape, 7.3

HIERHEIGHT command, 10

HIERHEIGHT function, 7.3

HIERSHAPE function, 7.3, 7.3

Holt-Winters forecasting, 9.3

hyperbolic

cosine calculation, 7.3

sine calculation, 8

tangent calculation, 8

I

IDs

character sets, 8, 8

IF command, 9.3, 10

IF conditional expression, 2.3.9.1

IFNONE keyword, 10

IMPORT command, 4.7.6, 10

J

JOINBYTES function, 7.3

JOINCHARS function, 7.3

JOINCOLS function, 7.3

JOINLINES function, 7.3

K

KEY function, 7.3

L

label column width, 6.3

branching in a program, 9.3

for error handling in programs, 10

labels, 9.3

in programs, 4.3.5.6

with IFNONE, 10

LAG function, 3.3.2.3, 8

LAGABSPCT function, 8

LAGDIF function, 8

LAGPCT function, 8

larger value of two expressions, 8

LARGEST function, 8

largest value of an expression, 8

LAST_DAY function, 8

LCOLWIDTH option, 6.3

LD command, 10

LEAD function, 3.3.2.3, 8

LEAST function, 8

LENGTH function, 8

LENGTH2 function, 8

LENGTH4 function, 8

LENGTHB function, 8

LENGTHC function, 8

LIKE operator, 6.3, 6.3

LIKECASE option, 6.3

LIKEESCAPE option, 6.3

LIKENL option, 6.3

LIMIT BASEDIMS command, 10

LIMIT command, 10

using LEVELREL, 10

using NOCONVERT, 10

using parent relation, 10

using POSLIST, 10

using related dimension, 10

using values, 10

LIMIT function, 8

limit maps, A.1, A.2.2, A.2.2

order of processing, A.2.2

syntax, A.2.2

limiting

alias dimensions, 9.3

dimensions, 10

multidimensional valuesets, 9.3

LIMITMAPINFO function, 8

LIMIT.SORTREL option, 6.3

LIMITSTRICT option, 6.3, 10

line size for report heading, 6.3

LINENUM option, 6.3

lines on a page of report output, 6.3

LINESLEFT option, 6.3

LISTBY program, 10

LISTFILES command, 10

LISTNAMES program, 10

literals

numeric, 2.1.1

text, 2.3.5

LOAD command, 10

loans, 7.3

interest payment on, 7.3

interest payments on, 8

payment on, 7.3

payments on, 8

local variables, 10, 10

locale independent, 9.3

LOCALTIMESTAMP function, 8

LOG command, 10

LOG function, 8

LOG10 function, 8

logical operators, 2.2.2

logs

calculating base 10 logarithm, 8

calculating natural logarithm, 8

LOOP clause in SQL FETCH, 10

looping, 9.3

over dimension status, 9.3

looping, explicit, 5.3, 5.3, 5.3, 5.3

LOWCASE function, 8

LOWER function, 8

lowercase, converting to, 8

LPAD function, 8

LSIZE option, 6.3

LTRIM function, 8

M

MAINTAIN command

event, 10, 10

MAINTAIN ADD, 10

MAINTAIN ADD for DAY, WEEK, MONTH, QUARTER and YEAR values, 10

MAINTAIN ADD for TEXT, ID, and INTEGER values, 10

MAINTAIN ADD SESSION, 10

MAINTAIN DELETE, 10, 10, 10

MAINTAIN MERGE, 10

MAINTAIN MOVE, 10

MAINTAIN RENAME, 10

trigger, 10, 10

Maintain event, 10

maintaining

alias dimensions, 9.3

composites, 10

dimensions, 10

partition templates, 10

partitions, 10

MAKEDATE function, 8

margins, 6.3

setting bottom margin, 6.3

setting top margin, 6.3

MAX function, 8

MAXBYTES function, 8

MAXCHARS function, 8

MAXFETCH option, 6.3

maximum values, 8

for each time period in the status, 8

larger of two expressions, 8

MEASUREDIM statement

for aggregation, 9.3

for allocation, 9.3

MEDIAN function, 8

median value, 8

messages, suppressing, 6.3

metadata

exporting, 9.3

importing, 10

MIN function, 8

minimum value, 8

for each time period in the status, 8

smaller of two expressions, 8

MMOF function, 8

MOD function, 8

MODDAMP option, 6.3

MODE function, 8

models

adding to aggmap, 9.3

compiling, 3.3.3, 9.3, 10

creating, 10

debugging, 3.3.5

defining, 9.3

deleting, 9.3

editing, 10

in aggregation specifications, 9.3, 10, 10

obtaining information about, 7.3

removing from aggmap, 9.3, 9.3

running, 3.3.4, 10

scenario, 3.3.2.6

solution variables, 3.3.1

MODEL.XEQRPT program

compiling, 6.3

defining, 9.3, 9.3

including, 10

nesting, 10

options, 6.3, 6.3, 6.3, 6.3, 6.3, 6.3, 6.3

MODERROR option, 6.3

MODGAMMA option, 6.3

MODINPUTORDER option, 6.3

MODMAXITERS option, 6.3

MODOVERFLOW option, 6.3

MODSIMULTYPE option, 6.3

MODTOLERANCE option, 6.3

MODTRACE option, 6.3

module version numbers, 7.3

MODULO function, 8

MON datetime format element, 9.3

MONITOR command, 10

monitoring, 10

cost of program lines, 10

cost of programs, 10

MONTH datetime format element, 9.3

MONTHABBRLEN option, 6.3

MONTHNAMES option, 6.3

MONTHS_BETWEEN function, 8

MOVE command, 10

MOVINGAVERAGE function, 8

MOVINGMAX function, 8

MOVINGMIN function, 8

MOVINGTOTAL function, 8

multidimensional valuesets, 9.3

multiline text

columns, 7.3

MULTIPATHHIER option, 6.3

multiwriter mode, 7.3, 9.3, 9.3

N

NA values

accepted as numeric input, 6.3, 6.3

caching, 6.3

comparing, 2.3.8.2, 2.3.8.2

controlling how treated, 2.3.3.2, 2.3.3.2

in Boolean expression, 2.3.8.2

in expressions, 2.3.3

NA2 bits, 2.3.3, 9.3

permanently replacing, 6.3

replacing, 8

replacing with strings, 8

retrieving, 7.3

spelling of, 6.3

substituting another value, 8

triggers, 6.3, 6.3

NA2 bits, 2.3.3, 9.3

NA2 function, 8

NA2 values, 8, 8

NAFILL function, 8

NAFLAG function, 8

name, 10

changing object name, 10

dimension, 10

listing names of dictionary entries, 10

NAME dimension, 10

names

listing for objects, 10

listing objects by, 10

qualified object, 2.3.2.2

NaN values

in OLAP DML, 7.3

NANVL function, 8

NASKIP option, 6.3

NASKIP2 option, 6.3

NASPELL option, 6.3, 9.3

NATRIGGER

See $NATRIGGER

natural logarithm, 8

negative value, 6.3

in output, 6.3

obtaining the root, 6.3

net present value, 8

NEW_TIME function, 8

NEXT_DAY function, 8

NLS_CALENDAR option, 6.3

NLS_CHARSET_ID function, 8

NLS_CHARSET_NAME function, 8

NLS_CURRENCY option, 6.3

NLS_DATE_FORMAT option, 6.3

NLS_DATE_LANGAUGE option, 6.3

NLS_DATE_LANGUAGE initialization parameter, 9.3

NLS_DUAL_CURRENCY option, 6.3

NLS_ISO_CURRENCY option, 6.3

NLS_LANG option, 6.3

NLS_LANGUAGE initialization parameter, 9.3

NLS_LANGUAGE option, 6.3

NLS_NUMERIC_CHARACTERS option, 6.3

NLS_SORT option, 6.3

NLS_TERRITORY initialization parameter, 9.3

NLS_TERRITORY option, 6.3

NLSSORT function, 8

NONE function, 8

NORMAL function, 8

NOSPELL option, 6.3

NPV function, 8

null values

See NA values

NULLIF function, 8

numbers

assigning random numbers, 8

commas in output, 6.3

decimal marker for output, 6.3

decimal places in output, 6.3

determining sign of, 8

negative values in output, 6.3

rounding, 8

spelling out, 9.3

thousands marker for output, 6.3

NUMBYTES function, 8

NUMCHARS function, 8

numeric conversion, 8, 8

numeric data types, 2.1.1

comparing, 2.3.8.3, 2.3.8.3.3

mixing, 2.3.4.1

numeric expressions, 2.3.4

data type of the result, 2.3.4.1

dates in, 2.3.7

mixing data types, 2.3.4.1

text dimensions in, 2.3.4.2

numeric values

rounding, 8

NUMLINES function, 8

NUMTODSINTERVAL function, 8

NUMTOYMNTERVAL function, 8

NVL function, 8

NVL2 function, 8

O

OBJ function, 8

object definitions

adding descriptions to, 10

deleting descriptions from, 10

object types

automatic, A.1.2.1, A.2.2

predefining, A.1.2.1, A.2.2

syntax for creating, A.1.2, A.2.2

objects, 9.3

acquired (list of), 7.3

checking for changes, 8

compiling, 6.3

creating by copying, 9.3

creating properties, 10

data type of (determining), 8

defining, 9.3

definition (retrieving), 8

deleting, 9.3, 9.3

describing its definition, 9.3

describing its properties, 9.3

dimensions of (retrieving), 8, 8

dropping changes, 10, 10

exporting from analytic workspace, 9.3

identifying triggers, 8

importing into analytic workspace, 10

in expressions, 2.3.2

listing, 8

listing names of, 10, 10, 10

loading, 10

making current, 9.3

obtaining information, 8

pages used to store (determining), 8

qualified name, 2.3.2.2

recalculating permissions, 10

renaming, 10

restrictions on name, 9.3

storage class (determining), 8

testing for existence, 7.3

OBJLIST function, 8

OBSCURE function, 8

OESEIFVERSION option

name change, Preface

See EIFVERSION option

OKFORLIMIT option, 6.3

OKNULLSTATUS option, 6.3, 10

OLAP API

optimization, C

OLAP DML

executing in SQL, A.2.2, A.2.2, A.2.2, B.3, B.5.2

quotation marks in, B.3.2

OLAP session cache

blocking creation of, 6.3

checking if empty, 8

defined, 6.3

for variable, 8

non-NA values, 8

populating with aggregated values, 6.3, 9.3

populating with NA values, 6.3

OLAP_API_SESSION_INIT package, C

OLAP_CONDITION function (SQL), A.2.2, A.2.2

OLAP_EXPRESSION function (SQL), A.2.2, B.3.1

OLAP_EXPRESSION_BOOL function (SQL), A.2.2

OLAP_EXPRESSION_DATE function (SQL), A.2.2

OLAP_EXPRESSION_TEXT function (SQL), A.2.2

OLAP_ON function (PL/SQL), B.5.2, B.5.2

OLAP_TABLE

optimizing looping, 5.3, 5.3, 5.3, 5.3

OLAP_TABLE function (SQL), A.2.2

custom measures, A.2.2, A.2.2, A.2.2, A.2.2

data map parameter, A.2.2

data type conversions, A.2.2

examples, A.2.2

FETCH command, A.2.2, A.2.2

limit map, A.1, A.2.2, A.2.2

retrieving session log, B.5.2

specifying a ROW2CELL column, A.2.2

specifying an OLAP DML command, A.2.2

specifying the analytic workspace, A.2.2

specifying the logical table, A.2.2

ONATTACH program, 4.8

ONDETACH program, 4.8

OPEN command See SQL command in OLAP DML, 10

operating system, identifying, 8

operators, 6.3

Boolean, 2.2.2

comparisons, 2.2.2

conditional, 2.3.9, 2.3.9

LIKE, 6.3, 6.3, 6.3

logical, 2.2.2

overview, 2.2

substitution, 2.3.10

optimization

OLAP API, C, C.1

options

displaying value of, 6.1

restoring previous values, 4.3.4.3

retrieving, 6.1

saving current values, 4.3.4.3

specifying, 6.1

ORA_HASH function, 8

Oracle OLAP

internal build number, 7.3

ordinal numbers

specifying, 9.3

spelling out, 9.3

outfile

current, 6.3

OUTFILE command, 10, 10

affect on DBMS_AW.EXECUTE, B.5.2

affect on DBMS_AW.RUN, B.5.2

OUTFILEUNIT option, 6.3

out-of-range decimal values, 6.3

output, 10

redirecting, 10

saving in a file, 10

overflow condition, 6.3

P

padding expressions, 8, 8

PAGE command, 10

PAGENUM option, 6.3

PAGEPRG option, 6.3

PAGESIZE, 6.3

paging in reports, 10

forcing a page break, 10

line number on current page, 6.3

lines for bottom margin, 6.3

lines for top margin, 6.3

lines left on page, 6.3

lines on a page, 6.3

page number, 6.3

producing a custom heading, 6.3

producing a standard heading, 10

turning on, 6.3

PAGING option, 6.3

PARENS option, 6.3

PARSE command, 7.3, 10

parsing expressions, 10

PARTITION function, 8

partition templates, 9.3, 9.3

defining, 9.3, 9.3

deleting, 9.3

maintaining, 10

retrieving partition names, 8

retrieving partitioning method, 8

PARTITIONCHECK function, 8

partitioned variables, 9.3, 9.3

aggregating, 8

defining, 9.3

deleting data from, 10

maintaining, 10

retrieving dimensions of, 8

retrieving partitioning method, 8

partitioning methods, 8

partitions, 9.3, 9.3, 9.3

adding values to, 10, 10

defining, 9.3

list partitions, 9.3

deleting, 9.3

deleting data, 10

identifying for value, 8

list, 9.3

locking segments of, 10

moving values, 10

range, 8, 9.3

retrieving dimensions of, 8

retrieving names of, 8

specifying values of, 10

pattern matching, 2.3.8.6.1

payment schedules, 7.3

for loan interest, 7.3, 8

for loans, 7.3, 8

PERCENTAGE function, 8

permission programs, 4.7.1.1, 4.8, 4.8, 4.8

permissions, 10

assigning to an object definition, 10

recalculating permission, 10

specifying conditions for accessing, 10

violations of, 6.3

PERMIT command, 10

PERMIT_READ program, 4.7.1.1, 4.8

PERMIT_WRITE program, 4.7.1.1, 4.8

PERMITERROR option, 6.3

PERMITRESET command, 10

phonetic representation, of text expression, 8

platform, determining, 8

P.M. datetime format element, 9.3, 9.3

POP command, 4.3.4.3, 4.3.4.4, 10, 10

popping a whole series at once, 10

POPLEVEL command, 10

nesting, 10

using, 4.3.4.5

populating

alias dimensions, 9.3

POUTFILEUNIT option, 6.3

PRECOMPUTE statement, 9.3

PREPARE command

See SQL command in OLAP DML

PRGERR keyword (SIGNAL), 10

PRGTRACE option, 6.3

print buffer, B.5.2, B.5.2

PRINTLOG procedure (PL/SQL), B.5.2

PROCEDURE statement

See SQL command in OLAP DML, 10

profiles, 8

PROGRAM command, 10

programs

adding program contents to a definition, 10

branching, 9.3, 9.3, 10

branching in, 10

branching labels, 9.3

calling, 9.3

case statement, 10

comment lines in, 4.3

compiling, 4.4, 4.4, 6.3, 9.3, 9.3

conditional execution of commands, 10, 10

debugging, 4.5, 6.3

declaring arguments in, 4.3.2.1

defining, 9.3

deleting, 9.3

determining how invoked, 7.3

error handling, 6.3, 6.3, 10

errors in, 4.3.5

executing, 4.6

halting execution with an error, 10

hiding, 10

local variable, 10

passing arguments to, 7.3, 7.3, 7.3, 7.3

performance cost, 10

permission, 4.7.1, 4.7.1.1, 4.8, 4.8, 4.8, 4.8, 4.8, 4.8

preserving environment, 4.3.4, 4.3.4

preserving status, 7.3, 9.3

repeating commands, 9.3

restoring previous values, 4.3.4.3

restoring status, 10, 10

returning a value, 10

saving compiled code, 4.4

saving current values, 4.3.4.3

saving status, 10, 10

startup, 4.7.1

suspending execution, 10

terminating execution of, 10

timing execution, 10, 10

trigger, 4.7.3.2, 4.8, 4.8, 4.8, 4.8, 4.8, 4.8, 4.8, 10

unhiding, 10

properties, 10

copying with an object definition, 9.3

creating for objects, 10

listing for objects, 9.3

PROPERTY command, 10

event, 10, 10

trigger, 10, 10

Property event, 10

PUSH command, 4.3.4.4, 10, 10

marking start of series, 10

placement, 4.3.5.6

using, 4.3.4.3

PUSHLEVEL command, 10

nesting, 10

placement, 4.3.5.6

Q

QUAL function, 2.3.2.5, 8

qualified data references

ampersand substitution, 2.3.2.5.6, 2.3.10

creating, 2.3.2.5

definition of, 2.3.2.5

for dimensions, 2.3.2.5.5

qualifying a relation, 2.3.2.5.4

replacing dimension of variable, 2.3.2.5.2, 2.3.2.5.3

specifying explicitly, 8

using with relation, 2.3.2.5.4

with assignment statement, 2.3.2.5.2

with dimensions, 2.3.2.5

with relations, 2.3.2.5.4

with variables, 2.3.2.5.2, 2.3.2.5.2, 2.3.2.5.3

qualified object name, 2.3.2.2

quotation marks

double, 2.1.2.1

in OLAP DML, B.3.2

R

RANDOM function, 8

random numbers, 8, 8, 8

random sparsity, 9.3

RANDOM.SEED.1 option, 6.3

RANDOM.SEED.2 option, 6.3

range partitions

defining, 9.3

retrieving calculation for, 8

RANK function, 8

number of calls to, 8

number of computed values, 8

number of triggered sorts, 8

RANK_CALLS option, 8

RANK_CELLS option, 8

RANK_SORTS option, 8

ranking performance monitoring, 8

RAW data type, 2.1.6, 2.1.6

raw values

converting, 8

reading files, 8

current record number, 8

error diagnosis, 7.3

FILEREAD command, 9.3

processing a record, 9.3

reading a record, 7.3

RECAP command, 10

RECNO function, 8

RECURSIVE option, 6.3

REDO command, 10

REEDIT command, 10

REGEXP_COUNT function, 8

REGEXP_INSTR function, 8

REGEXP_REPLACE function, 8

REGEXP_SUBSTR function, 8

REGRESS command, 7.3, 10

regressions

linear, 10

REGRESS.REPORT program, 10

related dimensions, 2.3.2.3.3, 8, 10

limiting to, 6.3

RELATION command, 10

RELATION statement

for aggregation, 9.3

for allocation, 9.3

relational tables See tables

relations

assigning values to, 10, 10, 10

comparing to text literals, 2.3.8.6.2

default, 2.3.2.3.3, 10

defining, 9.3, 9.3

limiting to single value, 2.3.2.5.4

QDR with, 2.3.2.5.4

replacing dimension of, 2.3.2.5.4

relations, in aggmaps

identifying changes, 7.3

RELEASE command, 10

REM function, 8

remainder after division, 8

REMAINDER function, 8

REMBYTES function, 8

REMCHARS function, 8

REMCOLS function, 8

REMLINES function, 8

RENAME command, 10

REPLBYTES function, 8

REPLCHARS function, 8

REPLCOLS function, 8

REPLLINES function, 8

REPORT command, 10

reporting, 10

reports

processing ROW command output, 8

producing, 8, 10

producing with ROW commands, 10

RESERVED function, 8

reserved words, 8, 8

RESYNC command, 10

RETURN command, 10

return value of a program, 10

REVERT command, 10, 10

ROLE option, 6.3

roles, 8

root of negative number, 6.3

ROOTOFNEGATIVE option, 6.3

ROUND function

for numbers, 8

ROW command, 10

processing output, 8

ROW function, 8

ROW2CELL column, A.1.3, A.2.2, A.2.2, A.2.2, A.2.2, A.2.2, A.2.2, A.2.2

ROWID data type, 2.1.7.1

converting, 8, 8

ROWIDTOCHAR function, 8

ROWIDTONCHAR function, 8

ROWTOHEX function, 8

RPAD function, 8

RR datetime format element, 9.3

RTRIM function, 8

RUN procedure (PL/SQL), B.5.2

running totals, 8, 10

run-time aggregation, 3.4.4

RUNTOTAL function, 8

S

scenario models, 3.3.2.6

seasonal data, 9.3

SECONDS option, 6.3

segment width, 9.3

segments

analytic workspace, 9.3

locking, 10

retrieving maximum size of, 7.3

SELECT statements (in OLAP DML), 10

T

table type, A.2.2

automatic, A.1.2.1, A.2.2

predefining, A.1.2.1, A.2.2

syntax for creating, A.1.2, A.2.2

tables

exporting from analytic workspaces, 10

importing into analytic workspaces, 10

TALLY function, 8

TAN function, 8

tangent calculation, 8

angle value, 7.3

arc, 7.3, 7.3

hyperbolic, 8

TANH function, 8

TCONVERT function, 8

temporary members

adding to dimension, 10

identifying, 7.3

TEMPSTAT command, 10

text

comparing values, 2.3.8.6

converting to raw, 7.3

data types, 2.1.2

date and number formats, 2.1.4.2

literals, 2.3.5, 2.3.8.6.2

passing arguments as, 4.3.2.3, 10

special characters, 2.1.2.2

text expressions, 2.3.4.2, 2.3.5

phonetic representation of, 8

text formatting

importing worksheet data, 10

TEXTFILL function, 8

TH datetime format element suffix, 9.3

thousands marker, 6.3

THOUSANDSCHAR option, 6.3

THSP datetime format element suffix, 9.3

time format models

short, 9.3

time of day, 8, 8

time series, 8

cumulative totals over, 7.3

data from previous time period, 8

data from subsequent time period, 8

difference between time periods, 8

maximum value in period, 8

minimum value in period, 8

moving totals over, 8

percent difference between time periods, 8, 8

time zone

formatting, 9.3

time zones

converting data to particular, 2.3.6.1

timestamp

converting to local time zone, 2.3.6.1

TIMESTAMP data type, 2.1.4.5

TIMESTAMP_LTZ data type, 2.1.4.7

TIMESTAMP_TZ data type, 2.1.4.6

timezone offsets, 8

timing, 10

execution of program lines, 10

execution of programs, 10

title for a report, 10

TMARGIN option, 6.3

TO_BINARY_DOUBLE function, 8

TO_BINARY_FLOAT function, 8

TO_CHAR function, 8

TO_DATE function, 8, 9.3

TO_NCHAR function, 8

TO_NUMBER function, 8

TO_TIMESTAMP_TZ function, 8

TOD function, 8

TODAY function, 8

TOTAL function, 8

totals

calculating, 8

cumulative, 7.3

in a report, 8, 8, 10, 10

moving, 8

over time, 8

running, 8

TRACEFILEUNIT option, 6.3

tracking, 10

cost of program lines, 10

cost of programs, 10

TRACKPRG command, 10

TRACKREPORT program, 10

TRANSLATE function, 8

TRAP command, 4.3.5.1, 10, 10, 10, 10

TRIGGER command, 10

TRIGGER function, 8

trigger objects, 8

trigger programs

Assign, 10, 10

Delete, 10, 10

designing, 4.7.3.2

Maintain, 10, 10

Property, 10, 10

Update, 4.8, 10

TRIGGER_AFTER_UPDATE program, 4.8

TRIGGER_AW program, 4.8, 4.8

TRIGGER_BEFORE_UPDATE program, 4.8

TRIGGER_DEFINE program, 4.8

TRIGGERASSIGN command, 10

TRIGGERMAXDEPTH option, 6.3

triggers

Assign, 10, 10

creating, 10

Define, 4.8

Delete, 10

deleting, 10, 10, 10

events, 8

Maintain, 10

NA, 5.3, 6.3, 6.3

objects, 8

Property, 10

subevents, 8

Update, 4.8, 4.8, 10

TRIGGERSTOREOK option, 6.3

TRIM function, 8

trimming expressions, 8, 8

trimming strings, 8

TRUNC function, 8

for numbers, 8

TRUNCATE function, 8

for datetimes, 8

for numbers, 8

tuples, B.4.1

TZ_OFFSET function, 8

U

UNHIDE command, 10

UNIQUELINES function, 8

unnamed composites, 9.3

defining, 9.3

example of, 9.3

UNRAVEL function, 8

UPCASE function, 8

UPDATE command, 10

event, 10

events, 4.8, 4.8

trigger, 10

triggers, 4.8, 4.8, 4.8

UPPER function, 8

UROWID data type, 2.1.7.2

user ID, retrieving, 8

user-defined functions

arguments in, 4.3.1

data type of, 4.3.1

USERID option, 6.3

USETRIGGERS option, 6.3

UTC offset

replacing with time zone region, 2.1.4.6

V

VALSPERPAGE program, 8

value name format, 10

values

restoring previous, 4.3.4.3

saving current, 4.3.4.3

W

WEEKDAYSNEWYEAR option, 6.3

WEEKOF function, 8

WHILE command, 9.3, 10

used with BREAK, 9.3

used with CONTINUE, 9.3

WIDTH_BUCKET function, 8

wildcards, 2.3.8.6.1, 2.3.8.6.1

WKSDATA function, 8

worksheet objects

cells, 8

data type of cells, 8

defining, 9.3, 9.3, 9.3

deleting, 9.3

dimensions, 9.3

Y

YESSPELL option, 6.3

YMINTERVAL data type, 2.1.4.8

YMINTERVAL function, 8

YRABSTART option, 6.3

YYOF function, 8

Z

zero, 6.3

dividing by, 2.3.4.4, 6.3

spelling of, 6.3

suppressing all-zero report rows, 6.3

ZEROROW option, 6.3

ZEROTOTAL command, 10

ZSPELL option, 6.3