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

$AGGREGATE_FORCECALC property, 6

$AGGREGATE_FORCEORDER property, 6, 6

$AGGREGATE_FROM property, 6, 6

$AGGREGATE_FROMVAR property, 6

$ALLOCMAP property, 6

$COUNTVAR property, 6

$DEFAULT_LANGUAGE property, 6

$NATRIGGER property

calling recursively, 20

executing simultaneously, 24

$STORETRIGGERVAL property, 6

$VARCACHE property, 6

% wildcard, 2.8.6.1

& operator, 2.10

= command, 21

event, 24, 24, 24

introduced, 2.3, 2.3

trigger, 24, 24, 24

with QDR, 2.12.2.2

_ wildcard, 2.8.6.1

A

abbreviating OLAP DML statements, 5

ABS function, 2.8.3.1, 6

ACQUIRE command, 6

ACROSS command, 6

ACROSS keyword, 21

$AGGREGATE_FROMVAR property, 6, 6

= command, 21

FETCH command, 12

FILEREAD command, 13, 22

FILEVIEW command, 13

HEADING command, 14

models, 4.4.2.2

REPORT command, 20

ROW command, 21

SQL FETCH command, 22

SQL SELECT command, 22

ADD_MONTHS command, 6

Aggcount variables, 6, 9, 10, 10

AGGINDEX statement, 6

AGGMAP ADD model command, 6

AGGMAP command, 6

AGGMAP property

See $AGGMAP property

AGGMAP REMOVE model command, 6

AGGMAP SET command, 6

AGGMAPINFO command, 7

aggmaps

compiling, 3.1.2

defining, 10

deleting, 10

models in, 6

Aggregate Advisor, 3.1.3, 6, 6, 6, 6

AGGREGATE command, 7

AGGREGATE function, 7

AGGREGATE_FROM property

See $AGGREGATE_FROM property

AGGREGATE_FROMVAR property

See $AGGREGATE_FROMVAR property

aggregating data, 23

caching, 24

formulas to, 7

on-the-fly, 3.1.3

partitioned variables, 7, 19

precomputing, 3.1.3

specifying a relation for, 6

using an Aggcount variable, 6

AGGREGATION function, 7

aggregation functions, A.3.10.5

algorithm for composite values, 21

alias dimensions

defining, 10

deleting, 10, 10, 10, 10

limiting, 10

maintaining, 10

populating, 10

aliases

for analytic workspace, 2.4.1

for analytic workspaces, 8

for dimensions, 10

workspace See workspace alias

ALLCOMPILE program, 7

ALLOCATE command, 7

allocating data, 3.2.1, 23

ALLOCERRLOGFORMAT option, 7

ALLOCERRLOGHEADER option, 7

ALLOCMAP command, 7

ALLOCMAP property

See $ALLOCMAP property

ALLSTAT command, 7

ampersand &(amp;) operator, 2.10

ampersand substitution

example of, 2.10

prevents compiling, 5.3.2

program arguments and, 5.2.2.3

QDR with, 2.12.2.6

using to pass arguments, 5.2.2.3, 16

analytic workspaces

aliases, 2.4.1, 2.4.1, 8

content summary, displaying, 8

current, 2.4.1

current workspace, 2.4.1

deleting objects, 10

exclusive, 8

exporting, 5.6.6

importing, 5.6.6

name, 2.4.1

objects, defining in a program, 5.3.2

obtaining information about, 8

partitioning, 8

permission programs, 5.6.1, 5.6.1.1

read-only, 8

read/write, 8

sharing, 8

starting, 8

updating, 24

waiting to attach, 8

AND operator, 2.3.2, 2.3.2, 2.3.2

ANTILOG function, 7

ANTILOG10 function, 7

ANY function, 7

arc tangent calculation, 8

ARCCOS function, 7

ARCSIN function, 8

ARCTAN function, 8

ARCTAN2 function, 8

ARG command

See ARGUMENT command

ARG function, 8

ARGCOUNT function, 8

ARGFR function, 8

ARGS function, 8

ARGUMENT command, 8

arguments, 8

in user-defined functions, 5.2.1

passing as text, 5.2.2.3, 16

passing to a program, 8, 8, 8, 8, 8

using ampersand substitution with, 5.2.2.3

ASCII function, 8

Assign event, 24

assigning values

OLAP DML statements, A.3.6

SET, 21

SET1, 21

assignment operator

See = command

assignment statements

event, 24, 24, 24

SET, 21

SET1, 21

trigger, 24, 24, 24

with QDR, 2.12.2.2

authentication, 19

encrypting text expressions, 19

within Oracle OLAP, 19

average

calculating, 8

moving, 18

AVERAGE function, 8

AW ALIASLIST command, 8

AW ATTACH command, 8

AW command, 8

events, 24

triggers, 24

AW CREATE command, 8

AW DELETE command, 8

AW DETACH command, 8

AW function, 8

AW LIST command, 8

AW SEGMENTSIZE command, 8

AWDESCRIBE program, 8

AWWAITTIME option, 8

B

BACK function, 7, 7, 8, A.3.12, A.3.13

BADLINE option, 5.4.2, 8

base dimensions

finding values of, 8, 15

BASEDIM function

base dimensions

identifying, 8

BASEVAL function, 8

BEGINDATE, 8

BITAND function, 8

bits, adding, 8

BLANK command, 8

blank lines in reports, 8

blanks in text values, stripping, 8

BLANKSTRIP function, 8

BMARGIN option, 8

Boolean constants, 2.2.3, 2.8

Boolean data type, 2.2.3

Boolean expressions

creating, 2.8.1

defined, 2.8

example of, 2.8.1

involving NA values, 2.8.2

operators, 2.3.2, 2.3.2

values, 2.8

Boolean operators

evaluation order, 2.3.2, 2.3.2

table of, 2.3.2, 2.3.2

Boolean values, 18

spelling of false values, 18

spelling of true values, 24

branching in programs, 8, 9, 14, 14, 16, 23

BREAK command, 8

bucket numbers, retrieving, 24

build number, 11

byte manipulation functions, 8, 12, 13, 15, 15, 17, 18, 20, 20

bytes, 13

finding location in text expression, 13

functions for, A.3.8.1, A.3.8.2, A.3.8.3

C

CACHE command, 24

CACHE statement, 6, 6, 6, 6, 6, 6

caches

See OLAP session cache

calculated members

adding to dimension, 16

identifying, 15

calculating a linear regression, 12, 20

CALENDARWEEK option, 8

CALL command, 8

CALLTYPE function, 8, A.3.18.5

capitalizing strings, 15

carriage return (escape sequence), 2.2.2.2

case conversion, 24

case statement in programs, 23

CATEGORIZE function, 8

CDA command, 8

CEIL function, 8

CHANGEBYTES function, 8

CHANGECHARS function, 8

characters

capitalizing, 15

converting to uppercase, 24

finding location in text expression, 13

functions for, A.3.8.1, A.3.8.2, A.3.8.3

representing as decimals, 2.2.2.2

representing as hexadecimals, 2.2.2.2

representing as Unicode, 2.2.2.2

retrieving decimal representation, 8

CHARLIST function, 8

CHGDFN command, 9

CHGDIMS function, 9

CHILDLOCK statement, 7

CLEANUP command

See SQL CLEANUP command

CLEAR command, 9

CLOSE command

See SQL CLOSE command

COALESCE function, 9

columns

default width in reports, 9, 15

getting value from a report column, 9

headings in a report, 14

in reports, 9

multiline text, 12, 15, 15, 20, 20

COLVAL function, 9

COLWIDTH function, 9

command sequence

accessing previously executed commands, 20

executing previously executed commands, 20

COMMAS option, 9

comments in programs, 5.2

COMMIT command, 9

comparing text data, 15, 16

comparison operators, 2.3.2

compilable objects, 9

COMPILE command, 9

example of, 9

COMPILEMESSAGE option, 9

COMPILEWARN option, 9

compiling, 9, 9

aggmaps, 3.1.2

models, 4.3

programs, 5.3

SQL statements, 22

suppressing error messages, 9

composites

base dimension values, 15

changing to conjoint dimensions, 9

defining, 10, 10

deleting, 10, 10, 10, 10

deleting values of, 16

index algorithm, 21, 21

limiting dimensions used by, 2.4.4.3

maintaining, 16

reporting, 20, 21

showing a value, 21

specifying value, 2.4.3.1

statements for managing, A.3.15

testing for a value, 15

unnamed, 10

using commands with, 2.4.4.3

concat dimensions

defining, 10

deleting, 10, 10

specifying value of, 2.4.3.2

concat partitions, 10

conditional execution of commands, 11

conditional expressions, 2.9, 2.9

conditional operators

defined, 2.9

example of, 2.9

conjoint dimensions

base dimension values, 15

changing to composites, 9

defining, 10

deleting, 10, 10

CONSIDER command, 9

CONTEXT command, 5.2.4.6, 9

CONTEXT function, 5.2.4.6, 9

CONTINUE command, 9

controlled sparsity, 10

CONVERT function, 9

converting

decimal numbers to integers, 15

values from one data type to another, 9

COPYDFN command, 9

copying definitions, 9

CORRELATION function, 9

COS function, 9

COSH function, 9

cosine calculation, 9, 9

COUNT function, 9

counting, 18

lines in a text expression, 18

number of true values, 9

COUNTVAR property

See $COUNTVAR property

CUMSUM function, 9

cumulative totals, 9, 21

current

analytic workspace, 2.4.1

status See current status

current directory, 8

current outfile, 11, 19

current status, 1.5.1.1, 1.5.1.1, 15, 16

cursors, 22

closing (SQL), 22

defining (SQL), 22, 22

importing (SQL), 22

D

data fetches (SQL), 22

data types, 23, 23, 23

converting, 1.3.2, 1.3.2, 1.3.2, 9, 23, 23, 23, A.3.2, A.3.2, A.3.3, A.3.5

creating a report, 20, 21

date, 2.2.4

determining data type of an object, 19

for variables, 10

numeric, 2.2.1

of expressions, 2.1.1

of numeric expressions, 2.6, 2.6.1

of user-defined function, 5.2.1

qualifying data for expressions, 19

restricting access, 19

showing a single value, 21

statements for converting, 1.3.2, 1.3.2, 1.3.2, A.3.2, A.3.2, A.3.3, A.3.5

text, 2.2.2

transferring from one format to another, 24

data values

accessing variable, 2.4.4.2

numeric, 2.6

DATABASE command

name change, Preface

See AW command

DATABASE function

name change, Preface

See AW function

date and time functions, A.3.9

date conversion, 23, 23

DATE data type, 2.2.4

DATEFORMAT option, 9

DATEORDER option, 9

dates, 23, 23

comparing with times, 2.8.5

current, 23, 23

functions, A.3.9

in arithmetic expressions, 2.6.4

in text expressions, 2.7.2

DATETIME data type, 2.2.4, 2.7.2

DAYABBRLEN option, 9

DAYNAMES option, 9

DAYOF function, 9

DBDESCRIBE program

name change, Preface

See AWDESCRIBE program

DBGOUTFILE command, 5.4.3, 9

and ECHOPROMPT, 11

DBWAITTIME option

name change, Preface

See AWWAITTIME option

DDOF function, 9

DEADLOCK statement, 7

debugging, 8, 9, 11, 12, 17, 17, 19

statements for, A.3.18.4

debugging programs, 5.4

decimal

marker, 10

places, 10

places (displayed), 10

DECIMAL data type, 2.2.1, 2.8.3.3

decimal data types, comparing, 2.8.3.3

decimal values, 10

decimal marker for output, 10

truncating to an integer, 15

DECIMALCHAR option, 10

DECIMALOVERFLOW option, 2.6.6, 10

DECIMALS option, 2.8.3, 2.8.3.1, 10

DECLARE CURSOR command

See SQL DECLARE CURSOR command

DECODE function, 10

default outfile, 11, 19

default relations, 2.4.3.3, 20

default status list, 1.5.1.2

DEFAULTAWSEGSIZE option, 10

DEFAULTDBFSIZE option

name change, Preface

See DEFAULTAWSEGSIZE option

DEFINE AGGMAP command, 10, 10

DEFINE command, 10

events, 24

triggers, 24

DEFINE COMPOSITE command, 10

DEFINE DIMENSION ALIASOF command, 10

DEFINE DIMENSION command, 10

DEFINE FORMULA command, 10

DEFINE MODEL command, 10

DEFINE PARTITION TEMPLATE command, 10

DEFINE PROGRAM command, 10

DEFINE RELATION command, 10

DEFINE SURROGATE command, 10, 10

DEFINE VALUESET command, 10

DEFINE VARIABLE command, 10

DEFINE WORKSHEET command, 10

defining

aggmap objects, 10

alias dimensions, 10

analytic workspace objects, 10

dimension alias, 10

dimensions, 10

formulas, 10

partitions, 10

programs, 10

relations, 10, 10

surrogates, 10

valuesets, 10, 10

variables, 10

worksheet objects, 10

definitions

copying, 9

creating, 10

creating object properties, 19

deleting, 10

moving within NAME dimension, 18

report of, 11, 13

testing for, 11

DELETE command, 10

event, 24, 24

trigger, 24, 24

Delete event, 24

deleting

alias dimensions, 10

composite values, 16

composites, 10

definitions, 10

dimension alias, 10

dimension values, 16, 16

dimensions, 10

formulas, 10

models, 10

objects, 10

partition templates, 10

partitions, 10

programs, 10

surrogates, 10

triggers, 24, 24, 24

valuesets, 10

DEPRDECL function, 11

DEPRDECLSW function, 11

depreciation of assets, 11, 11, 11, 11

DEPRSL function, 11

DEPRSOYD function, 11

DESCRIBE command, 11

descriptions

adding to a definition, 15

deleting from a definition, 15

dimension alias

defining, 10

deleting, 10, 10

DIMENSION command, in a model, 17

DIMENSION statement

for aggregation, 6

for allocation, 7

dimension status, 1.5.1.1, 16, 22

default, 1.5.1.2

effect on expressions, 2.5.2

null, 19

of dimensions used by composites, 2.4.4.3

restoring, 1.5.1.4, 5.2.4.2

restoring current, 1.5.1.4

saving current, 1.5.1.4

saving current status, 1.5.1.4, 5.2.4.2

status for managing, A.3.15

dimension surrogates

assigning values to, 21

defining, 10

dimension value

checking current status list, 22, 22, 22, 22

checking if in status, 15

checking status for a value, 15

counting related values, 23

listing associated objects, 16

listing values, 24

null values, 19

saving the status in a context, 9

sorting the status list, 16, 21, 21

testing for a value, 15

using qualified data reference, 19

using result of LIMIT command, 16

dimension values

checking if in status, 15

comparing, 2.8.4

counting related values, 23

deleting values of, 16, 16

latest value, 22

number of values in status, 22

retrieving current status list, 22

returning first value in status, 22

returning last value in status, 22

setting the status of, 16

dimensionality, changing in an expression, 9

dimension-based equations, 4.1

dimensions

checking status of, 22

comparing values, 2.8.4

defining, 10, 10

defining surrogates for, 10

deleting, 10, 10

in expressions, 2.4

limiting, 16

limiting to single value, 2.12.2

looping over values of, 13, 13, 13

maintaining, 16

numeric value of text dimension, 2.6.3

of expression, 2.5, 2.5.1

order in models, 17

QDR with, 2.12.2, 2.12.2.5

related, 2.4.3.3

restoring previous values, 5.2.4.3

saving current values, 5.2.4.3

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

sorting values, 16

statements for managing, A.3.15

status lists, 22

worksheet, 10

dimensions, language, 6

displaying error messages, 24

DIVIDEBYZERO option, 2.6.6, 11

division, 20

by zero, 11

calculating the remainder, 20

DO command, 11, 13

used with FOR, 13

used with SWITCH, 23

used with WHILE, 24

DOEND command, 11

double quotes (escape sequence), 2.2.2.2

DSECONDS option, 11

E

ECHOPROMPT option, 5.4.3, 11

EDIT command, 11

editing previously executed commands, 20

EIF file, 5.6.6, 12

exporting data from, 12

importing data from, 14

EIFBYTES option, 11

EIFEXTENSIONPATH option, 11

EIFNAMES option, 11

EIFSHORTNAMES option, 11

EIFTYPES option, 11

EIFUPDBYTES option, 11

EIFVERSION option, 11

encryption, 19

END command, 11

ENDDATE function, 11

ENDOF function, 11

EQ command, 11

EQ operator, 2.3.2, 2.3.2, 2.3.2

equations, dimension-based, 4.1

ERRNAMES option, 11

error messages, 21

creating your own, 5.2.5.4

deferring, 5.2.5.1

displaying, 24

finding line causing, 8

option holding text of, 11

output destination of, 11

producing without error condition, 21

signaling error condition, 21

suppressing, 5.2.5.3, 9

suppressing during compilation, 9

wrapping, 24

ERRORLOG statement, 7

ERRORMASK statement, 7

ERRORNAME option, 5.2.5, 11

errors

controlling during calculations, 2.6.6

handling, 5.2.5

handling in nested programs, 24, 24

handling in programs, 24

name of first-occurring error, 11

recording line causing, 8

signaling, 5.2.5.4, 24, 24

when comparing numeric data, 2.8.3, 2.8.3.2, 2.8.3.3

ERRORTEXT option, 5.2.5, 11

escape character for LIKE, 15

ESCAPEBASE option, 11

events

Assign, 24, 24

assignment statements, 24

Define, 24

Delete, 24, 24

deleting, 24, 24, 24

identifying, 24

Maintain, 24, 24

Property, 24, 24

Update, 24, 24, 24

EVERSION function, 11

EVERY function, 11

EXISTS function, 11

EXP function, 11

exponential forecasting, 12, 13

exponents, retrieving, 11

EXPORT command, 5.6.6, 12

EXPORT to EIF command, 12

EXPORT to spreadsheet command, 12

exporting data, 11, 11, 12

expressions, 15

ampersand substitution, 2.10

Boolean, 2.3.2, 2.8, 2.9, 2.9

changing dimensionality of, 9

comparing, 18

conditional, 2.9, 2.9

data type of, 2.1.1

dates in, 2.6.4

defined, 2.1

dimensions in, 2.4

dimensions of, 2.5, 2.5.1

formulas in, 2.4

functions in, 2.4

numeric, 2.6

objects in, 2.4

operators, 2.3.2

padding, 16, 21

parsing, 15, 19

relations in, 2.4

retrieving largest, 14

retrieving smallest, 15

saving, 10

substitution, 2.10

text, 2.7

trimming, 16, 21

using qualified data references in, 19

using text dimension in numeric expression, 2.6.3

valuesets in, 2.4

variables in, 2.4

EXPTRACE option, 12

EXTBYTES function, 12

EXTCHARS function, 12

EXTCOLS function, 12

external partitions, 9

EXTLINES function, 12

F

fastest-varying dimension, 10

FCCLOSE command, 12

FCEXEC command, 12

FCOPEN command, 12

FCQUERY command, 12

FCSET command, 12

FETCH command

G

GE operator, 2.3.2, 2.3.2, 2.3.2

GET function, 14

GOTO command, 14

GREATEST function, 14

group marker, 23

GROUPINGID command, 14

GROWRATE function, 14

growth rate, 14

GT operator, 2.3.2, 2.3.2, 2.3.2

H

handling errors in programs, 24

hash partitions, 8

heading, 14

for a report, 14

for output pages, 19

including a page number, 19

producing standard report heading, 23

HEADING command, 14

HIDE command, 14

HIERCHECK program, 14

HIERCHK.LOOPFND variable, 14

HIERCHK.LOOPVALS variable, 14

HIERCHK.XTRADIMS variable, 14

HIERHEIGHT command, 14

HIERHEIGHT function, 14

Holt-Winters forecasting, 12, 13

horizontal tab (escape sequence), 2.2.2.2

hyperbolic cosine calculation, 9

hyperbolic sine calculation, 21

hyperbolic tangent calculation, 23

I

ID data type, 2.2.2

IF command, 11, 14

IFNONE keyword, 16

IMPORT command, 5.6.6, 14

J

JOINBYTES function, 15

JOINCHARS function, 15

JOINCOLS function, 15

joining

columns of text, 15

text columns, 15

JOINLINES function, 15

K

KEY function, 15

L

label column width, 15

branching in a program, 14

for error handling in programs, 24

labels, 14

in programs, 5.2.5.6

with IFNONE, 16

LAG function, 2.6.4, 4.2.3, 15

LAGABSPCT function, 15

LAGDIF function, 15

LAGPCT function, 15

language dimension, 6

larger value of two expressions, 16

LARGEST function, 15

largest value of an expression, 15

LAST_DAY function, 15

LCOLWIDTH option, 15

LD command, 15

LE operator, 2.3.2, 2.3.2, 2.3.2

LEAD function, 2.6.4, 4.2.3, 15

LEAST function, 15

LIKE operator, 2.3.2, 2.3.2, 2.3.2, 2.8.6.1, 15, 15, 16

LIKECASE option, 15

LIKEESCAPE option, 15

LIKENL option, 16

LIMIT BASEDIMS command, 16

LIMIT command, 16

using LEVELREL, 16

using NOCONVERT, 16

using parent relation, 16

using POSLIST, 16

using related dimension, 16

using values, 16

with variables with composite, 2.4.4.3

LIMIT function, 16

limiting

alias dimensions, 10

dimensions, 16

multidimensional valuesets, 10

LIMITMAPINFO function, 16

LIMIT.SORTREL option, 16

LIMITSTRICT option, 16, 16

line size for report heading, 16

linefeed (escape sequence), 2.2.2.2

LINENUM option, 16

lines on a page of report output, 19

LINESLEFT option, 16

LISTBY program, 16

LISTFILES command, 16

LISTNAMES program, 16

literals

numeric, 2.2.1

text, 2.7

LOAD command, 16

loans, 13

interest payment on, 13

interest payments on, 24

payment on, 13

payments on, 24

local variables, 24, 24

localization options, 18, A.2

LOG command, 16

LOG function, 16

LOG10 function, 16

logical operators, 2.3.2

logs

calculating base 10 logarithm, 16

calculating natural logarithm, 16

LONGINTEGER data type, 2.2.1

LOOP clause in SQL FETCH, 22

looping, 13

over dimension status, 13

statements, 5.2.3.1

LOWCASE function, 16

lowercase, converting to, 16

LPAD function, 16

LSIZE option, 16

LT operator, 2.3.2, 2.3.2, 2.3.2

LTRIM function, 16

M

MAINTAIN command

event, 24, 24

MAINTAIN ADD, 16

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

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

MAINTAIN ADD SESSION, 16

MAINTAIN DELETE, 16, 16, 16

MAINTAIN MERGE, 16

MAINTAIN MOVE, 16

MAINTAIN RENAME, 16

trigger, 24, 24

Maintain event, 24

maintaining

alias dimensions, 10

composites, 16

dimensions, 16

partition templates, 16

partitions, 16

MAKEDATE function, 16

margins, 8

setting bottom margin, 8

setting top margin, 23

MAX function, 16

MAXBYTES function, 17

MAXCHARS function, 17

MAXFETCH option, 17

maximum values, 18

for each time period in the status, 18

larger of two expressions, 16

MEASUREDIM statement

for aggregation, 6

for allocation, 7

MEDIAN function, 17

median value, 17

messages, suppressing, 9

MIN function, 17

minimum value, 18

for each time period in the status, 18

smaller of two expressions, 17

MMOF function, 17

MODDAMP option, 17

MODE function, 17

models

adding to aggmap, 6

compiling, 4.3, 17

creating, 17

defined, 4.1

defining, 10

deleting, 10

editing, 17

in aggmap objects, 6

removing from aggmap, 6, 6

running, 4.4, 17

scenario, 4.2.6

solution variables, 4.1

MODEL.XEQRPT program

compiling, 9, 9

debugging, 9, 17, 17

defining, 10, 10

finding line causing error, 8

including, 17

nesting, 17

obtaining information about, 15

options, 17, 17, 17, 17, 17, 17, 17, 17, 17

MODERROR option, 17

MODGAMMA option, 17

MODINPUTORDER option, 17

MODMAXITERS option, 17

MODOVERFLOW option, 17

MODSIMULTYPE option, 17

MODTOLERANCE option, 17

MODTRACE option, 17

module version numbers, 11

MONITOR command, 18

monitoring, 18

cost of program lines, 18

cost of programs, 23

MONTHABBRLEN option, 18

MONTHNAMES option, 18

MONTHS_BETWEEN function, 18

MOVE command, 18

MOVINGAVERAGE function, 18

MOVINGMAX function, 18

MOVINGMIN function, 18

MOVINGTOTAL function, 18

multidimensional valuesets, 10

multiline text

columns, 12, 15, 15, 20, 20

counting lines in, 18

deleting duplicate lines, 24

extracting lines from, 12

filtering lines in, 13

finding lines, 13

inserting lines into, 15

joining, 15

removing lines from, 20

replacing lines in, 20

sorting lines in, 21, 24

testing whether found, 15

MULTIPATHHIER option, 18

multiwriter mode, 6, 8, 8, A.3.4

N

NA values

accepted as numeric input, 18, 18

caching, 24

comparing, 2.8.2

controlling how treated, 2.11.2, 2.11.2, A.2.12

in Boolean expression, 2.8.2

permanently replacing, 24

replacing, 18

replacing with strings, 18

retrieving, 9

spelling of, 18

statements for working with, A.3.7

substituting another value, 18

triggers, 24, 24

NAFILL function, 2.11.2, 2.11.2, 18, A.2.12

name, 18

changing object name, 20

dimension, 18

listing names of dictionary entries, 18

NAME dimension, 18

names

listing for objects, 16

listing objects by, 16

qualified object, 2.4.1

NASKIP option, 2.11.2, 2.11.2, 18, A.2.12

NASKIP2 option, 2.11.2, 2.11.2, 18, A.2.12

NASPELL option, 8, 18

NATRIGGER

See $NATRIGGER

NATRIGGER property

See $NATRIGGER property

natural logarithm, 16

NE operator, 2.3.2, 2.3.2, 2.3.2

negative value, 19

in output, 19

obtaining the root, 21

net present value, 18

NEW_TIME function, 18

NEXT_DAY function, 18

NLS options, 18, A.2

NLS_CALENDAR option, 18

NLS_CURRENCY option, 18

NLS_DATE_FORMAT option, 18

NLS_DATE_LANGUAGE option, 18

NLS_DUAL_CURRENCY option, 18

NLS_ISO_CURRENCY option, 18

NLS_LANG option, 18

NLS_LANGUAGE option, 18

NLS_NUMERIC_CHARACTERS option, 18

NLS_SORT option, 2.8.6, 18

NLS_TERRITORY option, 18

NONE function, 18

NORMAL function, 18

NOSPELL option, 2.2.3, 18

NOT operator, 2.3.2, 2.3.2, 2.3.2

NPV function, 18

NTEXT data type, 2.2.2

null values

See NA values

NULLIF function, 18

number conversion, 23, 23

numbers

assigning random numbers, 20

commas in output, 9

decimal marker for output, 10

decimal places in output, 10

determining sign of, 21

negative values in output, 19

rounding, 21

thousands marker for output, 23

NUMBYTES function, 18

NUMCHARS function, 18

numeric data types

comparing, 2.8.3, 2.8.3.3

list of, 2.2.1

mixing, 2.6.1

numeric expressions

data type of the result, 2.6, 2.6.1

dates in, 2.6.4

defined, 2.6

mixing data types in, 2.6.1

numeric functions, A.3.10

numeric options, A.3.10

numeric values

rounding, 21

NUMLINES function, 18

NVL function, 18

NVL2 function, 18

O

OBJ function, 19

object definitions

adding descriptions to, 15

deleting descriptions from, 15

statements for manipulating, A.3.14

objects, 2.4, 9

assigning values to, 2.3, 2.3

compiling, 9

creating by copying, 9

creating properties, 19

defining, 10

deleting, 10, 10

describing its definition, 11

describing its properties, 13

dropping changes, 21, 21

exporting from analytic workspace, 12

identifying triggers, 24

importing into analytic workspace, 14

listing, 19

listing names of, 16, 16, 18

loading, 16

making current, 9

obtaining information, 19

qualified name, 2.4.1

recalculating permissions, 19

renaming, 20

restrictions on name, 10

statements for defining, A.3.14

statements for deleting, A.3.14

testing for existence, 11

OBJLIST function, 19

OBSCURE function, 19

obtaining, 15

FORECAST results, 15

model information, 15

PARSE results, 15

REGRESS results, 15

OESEIFVERSION option

name change, Preface

See EIFVERSION option

OKFORLIMIT option, 19

OKNULLSTATUS option, 16, 19

OLAP

Data Definition Language See OLAP DML

Data Manipulation Language See OLAP DML

OLAP DML

definition, 1.1

functional categories, A.1

OLAP DML SQL FETCH command, 22

OLAP DML statements

abbreviations, 5

OLAP session cache

blocking creation of, 21

defined, 21

populating with aggregated values, 6, 24

populating with NA values, 24

ONATTACH program, 19

OPEN command See SQL OPEN command, 22

operating system, identifying, 23

operators, 15

Boolean, 2.3.2, 2.3.2

comparison, 2.3.2

conditional, 2.9, 2.9

LIKE, 15, 15

logical, 2.3.2

substitution, 2.10

text formatting

newline characters, 16

options

displaying value of, 1.2.1

localization, 18

NLS, 18

restoring previous values, 5.2.4.3

retrieving, 1.2.1

saving current values, 5.2.4.3

specifying, 1.2.1

OR operator, 2.3.2, 2.3.2, 2.3.2

OUTFILE command, 19, 19

OUTFILEUNIT option, 19

out-of-range decimal values, 10

output, 19

redirecting, 19

saving in a file, 19

overflow condition, 10

P

padding expressions, 16, 21

PAGE command, 19

PAGENUM option, 19

PAGEPRG option, 19

PAGESIZE, 19

paging in reports, 19

forcing a page break, 19

line number on current page, 16

lines for bottom margin, 8

lines for top margin, 23

lines left on page, 16

lines on a page, 19

page number, 19

producing a custom heading, 19

producing a standard heading, 23

turning on, 19

PAGING option, 19

PARENS option, 19

PARSE command, 2.5.1, 2.5.1, 19

parsing expressions, 15, 19

partition templates, 10, 10

defining, 10, 10

deleting, 10

maintaining, 16

retrieving partition names, 19

retrieving partitioning method, 19

PARTITIONCHECK function, 19

partitioned variables, 10, 10

aggregating, 7, 19

defining, 10

deleting data from, 16

maintaining, 16

retrieving dimensions of, 19

retrieving partitioning method, 19

partitioning methods, 19

partitions, 10, 10

adding, 9

adding values to, 16, 16

concat, 10

defining, 10

list partitions, 10

deleting, 10

deleting data, 16

external, 7, 9, 10

internal, 10

list, 10

locking segments of, 22

moving values, 16

range, 10, 19

retrieving dimensions of, 19

retrieving names of, 19

specifying values of, 16

pattern matching, 2.8.6.1

payment schedules, 13

for loan interest, 13, 24

for loans, 13, 24

PERCENTAGE function, 19

permission

programs, 5.6.1.1, A.3.18.5

permission programs, 19, 19, 19

permissions, 19

assigning to an object definition, 19

recalculating permission, 19

specifying conditions for accessing, 19

violations of, 19

PERMIT command, 19

PERMIT_READ program, 5.6.1.1, 19

PERMIT_WRITE program, 5.6.1.1, 19

PERMITERROR option, 19

PERMITRESET command, 19

platform, determining, 23

POP command, 5.2.4.3, 5.2.4.4, 19, 19

popping a whole series at once, 19

POPLEVEL command, 19

nesting, 19

using, 5.2.4.5

populating

alias dimensions, 10

POUTFILEUNIT option, 19

PRECOMPUTE statement, 6

PREPARE command

See SQL PREPARE command

PRGERR keyword (SIGNAL), 24

PRGTRACE option, 19

PROCEDURE statement

See SQL PROCEDURE command, 22

profiles, 23

PROGRAM command, 19

programs

adding program contents to a definition, 19

branching, 8, 9, 23

branching in, 16

branching labels, 14

calling, 8

case statement, 23

comment lines in, 5.2

compiling, 5.3, 5.3, 9, 9, 9

conditional execution of commands, 14, 24

debugging, 5.4, 8, 9, 12, 19

declaring arguments in, 5.2.2.1

defining, 10

deleting, 10

determining how invoked, 8, A.3.18.5

error handling, 11, 11, 24

errors in, 5.2.5

executing, 5.5

finding line causing error, 8

halting execution with an error, 21

hiding, 14

local variable, 24

passing arguments to, 8, 8, 8, 8

performance cost, 23

permission, 5.6.1, 5.6.1.1, 19, 19, 19, 19, 19, 19, A.3.18.5, A.3.18.5

PERMIT_READ, 5.6.1.1

PERMIT_WRITE, 5.6.1.1

preserving environment, 5.2.4, 5.2.4

preserving status, 9, 9, 19, 19, 19, 19

repeating commands, 13

restoring previous values, 5.2.4.3

returning a value, 21

running, 5.4

saving compiled code, 5.3

saving current values, 5.2.4.3

startup, 5.6.1

statements for, A.3.18

suspending execution, 21

terminating execution of, 21

testing by running, 5.4

timing execution, 18, 23

trigger, 5.6.3.2, 24, 24, 24, 24, 24, 24, 24, 24

unhiding, 24

properties, 19

copying with an object definition, 9

creating for objects, 19

listing for objects, 13

PROPERTY command, 19

event, 24, 24

trigger, 24, 24

Property event, 24

PUSH command, 5.2.4.4, 19, 19

marking start of series, 19

placement, 5.2.5.6

using, 5.2.4.3

PUSHLEVEL command, 19

nesting, 19

placement, 5.2.5.6

Q

QDR

with = command, 2.12.2.2

with assignment statements, 2.12.2.2

QUAL function, 2.12.2.7, 19

qualified data references, 19

ampersand substitution, 2.12.2.6

creating, 2.12.2

defined, 2.12.2

qualifying a relation, 2.12.2.4

replacing dimension of variable, 2.12.2.2, 2.12.2.3, 2.12.2.3

using with relation, 2.12.2.4

with = command, 2.12.2.2

with assignment statement, 2.12.2.2

with dimensions, 2.12.2

with relations, 2.12.2.4

with variables, 2.12.2.2, 2.12.2.2, 2.12.2.2, 2.12.2.3, 2.12.2.3

qualified object name, 2.4.1

quotation marks (escape sequence), 2.2.2.2

R

RANDOM function, 20

random numbers, 18, 20

random sparsity, 10

RANDOM.SEED.1 option, 20

RANDOM.SEED.2 option, 20

range partitions, 10

retrieving calculation for, 19

RANK function, 20

RANK_CALLS option, 20

RANK_CELLS option, 20

RANK_SORTS option, 20

ranking

performance monitoring, 20

ranking performance monitoring, 20

reading files, 20

current record number, 20

error diagnosis, 12

FILEREAD command, 13

processing a record, 13

reading a record, 13

RECAP command, 20

RECNO function, 20

RECURSIVE option, 20

REDO command, 20

REEDIT command, 20

REGRESS command, 20

regression, 12

calculating a linear regression, 12, 20

obtaining information about, 15

regression statements, A.3.11.1

REGRESS.REPORT program, 20

related dimensions, 2.4.3.3

relation, 23

RELATION command, 20

RELATION statement

for aggregation, 6

for allocation, 7

relations

assigning values to, 21, 21, 21

comparing to text literals, 2.8.6.2

default, 2.4.3.3, 20

defining, 10, 10

limiting to single value, 2.12.2.4

QDR with, 2.12.2.4

replacing dimension of, 2.12.2.4

RELEASE command, 20

REM function, 20

remainder after division, 20

REMBYTES function, 20

REMCHARS function, 20

REMCOLS function, 20

REMLINES function, 20

RENAME command, 20

REPLBYTES function, 20

REPLCHARS function, 20

REPLCOLS function, 20

REPLLINES, 20

REPORT command, 20

reporting, 20

reports, 20, 21

processing ROW command output, 21

producing, 20

producing with ROW commands, 21

RESERVED function, 21

reserved words, 21, 21

restoring dimension status, 1.5.1.4

RESYNC command, 21, A.3.4

RETURN command, 21

return value of a program, 21

REVERT command, 21, 21

ROLE option, 21

roles, 23

root of negative number, 21

ROOTOFNEGATIVE option, 2.6.6, 21

ROUND function, 2.8.3, 2.8.3.1

for dates and time, 21

for numbers, 21

ROW command, 21

processing output, 21

ROW function, 21

RPAD function, 21

RTRIM function, 21

running totals, 21, 24

run-time aggregation, 3.1.3

RUNTOTAL function, 21

S

saving dimension status, 1.5.1.4

scenario models

defined, 4.2.6

for financial modeling, 4.2.6

seasonal data, 12, 12

SECONDS option, 21

segment width, 9

segments

locking, 22

SELECT statement

See SQL SELECT command

SELECT statements (in SQL), 22, 22

selecting

alias dimension values, 10

data, 16

SESSCACHE option, 21

session cache

See OLAP session cache

sessions, 16

preserving environment, 5.2.4, 5.2.4

recording in disk file, 16

restoring environment, 5.2.4.3

user ID, 23

SET command, 21

SET1 command, 21

SHORTDECIMAL data type, 2.8.3.3

SHORTINTEGER data type, 2.2.1

SHOW command, 21

showing, 11

definitions of workspace objects, 11

names of objects, 16

object names, 16

object properties, 13

SIGN function, 21

SIGNAL command, 5.2.5.4, 21

simultaneous equations in models, 4.2.5

SIN function, 21

sine calculation, 21, 21

single quotes (escape sequence), 2.2.2.2

SINH function, 21

SLEEP command, 21

slowest-varying dimension, 10

smaller value of two expressions, 17

SMALLEST function, 21

smallest value of an expression, 21

SMOOTH function, 21

solution variables

defined, 4.1

example of, 17

SORT

command, 21

function, 21

SORTCOMPOSITE option, 21

sorting

dimension values, 16

status list of a dimension, 16, 21, 21

valuesets, 21, 21

SORTLINES function, 21

SOURCEVAL statement, 7

sparse data, 15

base dimension value, 15

changing definitions, 9

eliminating, 10

exporting, 12

importing, 14

index algorithm, 21

obtaining information, 19

reading from files, 13

renaming composites, 20

reporting, 20, 21

specifying composites, 10

testing for a value, 15

SPARSE keyword, 10

SPARSEINDEX option, 21

sparsity

controlled, 10

random, 10

spreadsheets

defining, 10

exporting to, 12

importing data from, 14, 14

See worksheets

SQL CLEANUP command, 22

SQL CLOSE command, 22

SQL command, 22

SQL DECLARE CURSOR command, 22

SQL EXECUTE command, 22

SQL IMPORT command, 22

SQL PREPARE command, 22

SQL PROCEDURE command, 22

SQL SELECT command, 22, 22

SQL statements, 22

compiling, 22

embedding in OLAP DML, 5.6.2.1, 22

optimizing, 22

SQL stored procedures

creating, 22

executing, 22

SQL support, 22

blocking factor, 22

error codes, 22

error messages, 22, 22

SQL statement execution, 22

SQLBLOCKMAX option, 22

SQLCODE option, 22

SQLCOLUMNS procedure, 22, 22

SQLERRM option, 22

SQLFETCH function, 22

SQLMESSAGES option, 22

SQLTABLES procedure, 22, 22, 22

SQRT command, 22

square root, 22

calculating, 22

result for negative number, 21

standard deviation calculation, 23

STARTOF function, 22

startup programs, 5.6.1

STATALL function, 22

STATDEPTH function, 22

statements

abbreviating, 5

altering order of execution, 14

editing previously executed, 20

functional categories of, A

looping, 5.2.3.1

reading from a file, 15

sending to file, 20

STATFIRST function, 22

STATIC_SESSION_LANGUAGE option, 22

statistical functions, A.3.10.3

STATLAST function, 22

STATLEN function, 22

STATLIST function, 22

STATMAX function, 22

STATMIN function, 22

STATRANK function, 22

status, 22, 22

checking current status list, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22

checking for a dimension value, 15

dimension, 22

looping over in a program, 13, 19, 23

null values, 19

saving, 9, 9, 19, 19, 19, 19

See dimension status

setting, 16

sorting values in the status list, 21, 21

using result of LIMIT command, 16

status list

current, 1.5.1.1

default, 1.5.1.2

empty, 19

STATUS program, 22

STATVAL function, 22

STDDEV function, 23

STDHDR program, 23

line size for centering, 16

storage, 9

in-place vs. permanent, 9

of variables, 10

stored procedures

creating, 22

executing, 22

STORETRIGGERVAL property, 19

See $STORETRIGGERVAL property

subevents, identifying, 24

substitution expressions, 2.10

substitution operator, 2.10

SUBSTR function, 23

SUBSTRB function, 23

substrings

retrieving, 15, 15, 23, 23

SUBTOTAL function, 23

subtotals, 23

in a report, 23

resetting to zero, 24

surrogate dimension, 10

defining, 10

surrogates

defining, 10

deleting, 10

SWITCH command, 8, 11, 23

SYSDATE function, 23

SYSINFO function, 23

SYSTEM function, 23

system statements, A.3.1

T

tab (escape sequence), 2.2.2.2

TALLY function, 23

TAN function, 23

tangent calculation, 23

arc, 8, 8

hyperbolic, 23

tangents

calculating angle value, 8

TANH function, 23

TCONVERT function, 23

temporary members

adding to dimension, 16

identifying, 15

TEMPSTAT command, 23

testing

if every value is true, 11

if no values are true, 18

number of true values, 9

whether an object exists, 11

text, 15

comparing values, 2.8.6, 2.8.6

comparing values to a pattern, 2.8.6.1

data types, 2.2.2

functions, A.3.8.1, A.3.8.2, A.3.8.3

multiline, 8

NLS_SORT option in comparisons, 2.8.6

options, A.3.8.1, A.3.8.2, A.3.8.3

passing arguments as, 5.2.2.3, 16

U

UNHIDE command, 24

UNIQUELINES function, 24

unnamed composites, 10

defining, 10

example of, 10

UNRAVEL function, 24

UPCASE function, 24

UPDATE command, 24

event, 24

events, 24, 24

trigger, 24

triggers, 24, 24, 24

uppercase, converting to, 24

user ID, 23

user-defined functions

arguments in, 5.2.1

data type of, 5.2.1

USERID option, 24

USETRIGGERS option, 24

V

VALSPERPAGE program, 24

value name format, 24

W

WEEKDAYSNEWYEAR option, 24

WEEKOF function, 24

WHILE command, 8, 24

used with BREAK, 8

used with CONTINUE, 9

WIDTH_BUCKET function, 24

wildcards, 2.8.6.1, 2.8.6.1

WKSDATA function, 24

WORKSHEET data type, 2.2

worksheet objects

cells, 24

data type of cells, 24

defining, 10, 10, 10

deleting, 10

dimensions, 10

workspace aliases, 2.4.1

WRAPERRORS option, 24

Y

YESSPELL option, 2.2.3, 24

YRABSTART option, 24

YYOF function, 24

Z

zero, 11

dividing by, 2.6.6, 11

spelling of, 24

suppressing all-zero report rows, 24

ZEROROW option, 24

ZEROTOTAL command, 24

ZSPELL option, 24