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

$AGGREGATE_FORCECALC property, 8

$AGGREGATE_FORCEORDER property, 8, 8

$AGGREGATE_FROM property, 8, 8

$AGGREGATE_FROMVAR property, 8

$ALLOCMAP property, 8

$COUNTVAR property, 8

$DEFAULT_LANGUAGE property, 8

$NATRIGGER property

calling recursively, 22

executing simultaneously, 26

$STORETRIGGERVAL property, 8

$VARCACHE property, 8

% wildcard, 3.7.6.1

& operator, 3.9

= command, 23

event, 26, 26, 26

trigger, 26, 26, 26

_ wildcard, 3.7.6.1

A

abbreviating OLAP DML statements, 7

ABS function, 8

ACQUIRE command, 8

ACROSS command, 8

ACROSS keyword, 23

$AGGREGATE_FROMVAR property, 8, 8

= command, 23

FETCH command, 14

FILEREAD command, 15, 24

FILEVIEW command, 15

HEADING command, 16

models, 6.4.2.2

REPORT command, 22

ROW command, 23

SQL FETCH command, 24

SQL SELECT command, 24

ADD_MONTHS command, 8

Aggcount variables, 8, 11, 12, 12, 21

AGGINDEX statement, 8

AGGMAP ADD model command, 8

AGGMAP command, 8

AGGMAP property

See $AGGMAP property

AGGMAP REMOVE model command, 8

AGGMAP SET command, 8

AGGMAPINFO command, 9

aggmaps

compiling, 4.3, 11

defining, 12

deleting, 12

in formulas, 21

list of, 10

See also aggregation specifications, allocation specifications

Aggregate Advisor, 4.4, 8, 8, 8, 8

AGGREGATE command, 9

AGGREGATE function, 9

AGGREGATE_FROM property

See $AGGREGATE_FROM property

AGGREGATE_FROMVAR property

See $AGGREGATE_FROMVAR property

aggregating data

caching, 26

formulas for, 9

on-the-fly, 4.4

partitioned variables, 9, 21

precomputing, 4.4

specifying a relation for, 8

statements for, A.3.12

using an Aggcount variable, 8

using an aggmap object, 4.1

using TCONVERT, 25

B

BACK function, 9, 9, 10, A.3.12, A.3.13

BADLINE option, 7.4.2, 10

base dimensions

finding values of, 10, 17

identifying, 10

setting status list of, 18

BASEDIM function, 10

BASEVAL function, 10

BEGINDATE, 10

BITAND function, 10

bits, adding, 10

BLANK command, 10

blank lines in reports, 10

BLANKSTRIP function, 10

BMARGIN option, 10

Boolean

data type, 2.4

expressions, 3.7

operators, 3.2.3

values, 20, 26

branching in programs, 10, 11, 16, 16, 18, 25

BREAK command, 10

bucket numbers, retrieving, 26

build number of Oracle OLAP, 13

C

CACHE statement, 8, 8, 8, 8, 8

caches

See OLAP session cache

calculated members

adding to dimension, 18

identifying, 17

calculating a linear regression, 22

CALENDARWEEK option, 10

CALL command, 10

CALLTYPE function, 10, A.3.18.5

case statement in programs, 25

CATEGORIZE function, 10

CDA command, 10

CEIL function, 10

CHANGEBYTES function, 10

CHANGECHARS function, 10

characters

manipulation functions, A.3.8

representing as decimals, 2.3.2

representing as hexadecimals, 2.3.2

representing as Unicode, 2.3.2

special, 2.3.2

CHARLIST function, 10

CHGDFN command, 11

CHGDIMS function, 11

CHILDLOCK statement, 9

CHR function, 11

CLEANUP command

See SQL command in OLAP DML

CLEAR command, 11

CLOSE command

See SQL command in OLAP DML

COALESCE function, 11

columns

default width in reports, 11, 17

getting value from a report column, 11

headings in a report, 16

in reports, 11

multiline text, 14

COLVAL function, 11

COLWIDTH function, 11

COMMAS option, 11

comments in programs, 7.2

COMMIT command, 11

comparing

dates, 3.7.5

values, 3.7.2, 3.7.6

comparison operators, 3.2.3

compilable objects, 11

COMPILE command, 11

COMPILEMESSAGE option, 11

COMPILEWARN option, 11

compiling, 11

aggmaps, 4.3

aggregation specifications, 4.3

models, 6.3

programs, 7.3

SQL statements, 24

suppressing error messages, 11

composites, 3.3.4.3

base dimension values, 17

changing to conjoint dimensions, 11

defining, 12, 12

deleting, 12, 12, 12, 12

deleting values of, 18

index algorithm, 23, 23

index type (determining), 21

listing associated objects, 18

maintaining, 18

reporting, 22, 23

showing a value, 23

specifying values for, 3.3.3.1

specifying values of, 3.3.3.1, 3.3.3.2

statements for managing, A.3.15

testing for a value, 17

unnamed, 12

D

data fetches (SQL), 24

data types

Boolean, 2.4

converting, 2.6, A.3.5

creating a report, 22, 23

date, 2.5

determining data type of an object, 21

for variables, 12

numeric, 2.2

of expressions, 3.1.1

of numeric expressions, 3.5.1

of user-defined function, 7.2.1

qualifying data for expressions, 21

restricting access, 21

showing a single value, 23

statements for converting, A.3.5

text, 2.3

transferring from one format to another, 26

WORKSHEET, 2.1

DATABASE command

name change, Preface

See AW command

DATABASE function

name change, Preface

See AW function

date and time functions, A.3.9

date data types, 2.5

date functions, A.3.9

DATEFORMAT option, 11

DATEORDER option, 11

dates, 25, 25

comparing, 3.7.5, 3.7.5

current, 25, 25

functions, A.3.9

in arithmetic expressions, 3.5.3

in text expressions, 3.6.2

DATETIME data type, 3.6.2

DAYABBRLEN option, 11

DAYNAMES option, 11

DAYOF function, 11

DBDESCRIBE program

name change, Preface

See AWDESCRIBE program

DBGOUTFILE command, 7.4.3, 11

and ECHOPROMPT, 13

DBWAITTIME option

name change, Preface

See AWWAITTIME option

DDOF function, 11

DEADLOCK statement, 9

debugging, 14

models, 6.5

options for, A.2.7

programs, 7.4

statements for, A.3.18.4

decimal data types, comparing, 3.7.3.3

decimal marker (displayed), 12

decimal places (displayed), 12

decimal values, 12

decimal marker for output, 12

truncating to an integer, 17

DECIMALCHAR option, 12

DECIMALOVERFLOW option, 12

DECIMALS option, 12

DECLARE CURSOR command

See SQL command in OLAP DML

DECODE function, 12

default

outfile, 21

relations, 3.3.3.3, 22

status. See default status list

default status list

changing, 1.5.1.2

definition of, 1.5.1.2

determining if in effect, 24

E

ECHOPROMPT option, 7.4.3, 13

EDIT command, 13

editing previously executed commands, 22

EIF file, 7.6.6, 14

exporting data from, 14

importing data from, 16

EIFBYTES option, 13

EIFEXTENSIONPATH option, 13

EIFNAMES option, 13

EIFSHORTNAMES option, 13

EIFTYPES option, 13

EIFUPDBYTES option, 13

EIFVERSION option, 13

encryption, 21

END command, 13

ENDDATE function, 13

ENDOF function, 13

EQ command, 13

equations, dimension-based, 6.1

ERRNAMES option, 13

error messages, 23

creating your own, 7.2.5.4

deferring, 7.2.5.1

displaying, 26

option holding text of, 13

producing without error condition, 23

signaling error condition, 23

suppressing, 7.2.5.3, 11

suppressing during compilation, 11

wrapping, 26

ERRORLOG statement, 9

ERRORMASK statement, 9

ERRORNAME option, 7.2.5, 13

errors

controlling during calculations, 3.5.5

handling, 7.2.5

handling in nested programs, 26, 26

handling in programs, 26

name of first-occurring error, 13

signaling, 7.2.5.4, 26, 26

SQL error codes, 24

when comparing numeric data, 3.7.3, 3.7.3.2, 3.7.3.3

ERRORTEXT option, 7.2.5, 13

escape character for LIKE, 17

escape sequences, 2.3.2, 2.3.2

ESCAPEBASE option, 13

events

Assign, 26, 26

assignment statements, 26

Define, 26

Delete, 26, 26

deleting, 26, 26, 26

identifying, 26

Maintain, 26, 26

Property, 26, 26

Update, 26, 26, 26

EVERSION function, 13

EVERY function, 13

EXISTS function, 13

EXP function, 13

exponential forecasting, 15

exponents, retrieving, 13

EXPORT command, 7.6.6, 14

EXPORT to EIF command, 14

EXPORT to spreadsheet command, 14

exporting data, 13, 13, 14

expressions

ampersand substitution, 3.9

Boolean, 3.7, 3.8, 3.8, 3.8.1

changing dimensionality of, 3.4.3, 11

comparing, 20

conditional, 3.8, 3.8, 3.8

data type of, 3.1.1

dates in, 3.5.3

defined, 3.1

determining dimensions of, 3.4.1

dimensions of, 3.4, 3.4.1

dimensions status, 3.4.2

empty cells, 3.10

NA values in, 3.10

numeric, 3.5

objects in, 3.3

padding, 18, 23

parsing, 21

retrieving largest, 16

retrieving smallest, 17

saving, 12

substitution, 3.9

text, 3.6

trimming, 18, 23

using objects in, 3.3.4.3

using qualified data references in, 21

EXPTRACE option, 14

EXTBYTES function, 14

EXTCHARS function, 14

EXTCOLS function, 14

external partitions, 11

EXTLINES function, 14

F

fastest-varying dimension, 12

FCCLOSE command, 14

FCEXEC command, 14

FCOPEN command, 14

FCQUERY command, 14

FCSET command, 14

FETCH command

See SQL command in OLAP DML

fetching data (SQL), 24

file I/O, 14, 14, 15, 15, 15, 15, 15

closing, 14, 14, 14

current directory, 10

diagnosing errors when processing, 14

forcing a page break, 15

gathering information about, 15

list of open files, 18

opening, 15

processing data from, 15

reading a record, 15

reading data from, 15

reading Oracle OLAP commands from a file, 16, 17

records read, 22

setting attributes, 15

writing, 15

FILECLOSE command, 14

FILECOPY command, 14

FILEDELETE command, 14

FILEERROR function, 14

FILEGET function, 14

FILEMOVE command, 14

FILENEXT function, 15

FILEOPEN function, 15

FILEPAGE command, 15

FILEPUT command, 15

FILEQUERY function, 15

FILEREAD command, 15

files

appending output, 21

importing data from, 16

saving output in, 21

FILESET command, 15

fileunits, 15, 15

attributes, 15

number of outfile destination, 21

opening, 15, 21

reading data from, 15

setting attributes, 15

FILEVIEW command, 15

FILTERLINES function, 15

financial analysis, scenario modeling, 6.2.6

financial functions, A.3.10.2, A.3.10.2

FINDBYTES function, 15

FINDCHARS function, 15

FINDLINES function, 15

FINTSCHED function, 15

floating point numbers, comparing, 3.7.3.2

floating-point format

limitations when calculating, 3.5.4

use of, 3.5.4

FLOOR function, 15

FOR command, 13, 15

breaking out of, 10

example of, 15

looping over dimension values, 15, 15, 15

used with BREAK, 10

used with CONTINUE, 11

used with OKFORLIMIT, 21

used with TEMPSTAT, 25

FORECAST command, 15

FORECAST function, 17

forecast statements, A.3.11.1

forecasting context, 14

closing, 14

executing, 14

opening, 14

querying, 14

setting characteristics of, 14

FORECAST.REPORT program, 15, 15

formulas

aggmap objects in, 21

aggregating data with, 9

compiling, 11, 11

defining, 12, 12

deleting, 12, 12

expression for (retrieving), 21

recursive, 22

specifying new expression, 13

statements used for, A.3.16

FPMTSCHED function, 15

FULLDSC program, 15

functions

aggregation, A.3.10.5

calling, 10

date, A.3.9

financial, A.3.10.2

numeric, A.3.10

statistical, A.3.10.3

text, A.3.8

time, A.3.9

time-series, A.3.10.4

user-defined, 7.2.1, 7.2.1, 10, 23

G

GET function, 16

GOTO command, 16

GREATEST function, 16

group marker, 25

GROUPINGID command, 16

GROWRATE function, 16

growth rate, 16

H

handling errors in programs, 26

hash partitions, 10

heading, 16

for a report, 16

for output pages, 21

including a page number, 21

producing standard report heading, 25

HEADING command, 16

HIDE command, 16

HIERHEIGHT command, 16

HIERHEIGHT function, 16

Holt-Winters forecasting, 15

hyperbolic

cosine calculation, 11

sine calculation, 23

tangent calculation, 25

I

IF command, 13, 16

IF conditional expression, 3.8.1

IFNONE keyword, 18

IMPORT command, 7.6.6, 16

J

JOINBYTES function, 17

JOINCHARS function, 17

JOINCOLS function, 17

JOINLINES function, 17

K

KEY function, 17

L

label column width, 17

branching in a program, 16

for error handling in programs, 26

labels, 16

in programs, 7.2.5.6

with IFNONE, 18

LAG function, 6.2.3, 17

LAGABSPCT function, 17

LAGDIF function, 17

LAGPCT function, 17

language dimension, 8

larger value of two expressions, 18

LARGEST function, 17

largest value of an expression, 17

LAST_DAY function, 17

LCOLWIDTH option, 17

LD command, 17

LEAD function, 6.2.3, 17

LEAST function, 17

LIKE operator, 17, 18

LIKECASE option, 17

LIKEESCAPE option, 17

LIKENL option, 18

LIMIT BASEDIMS command, 18

LIMIT command, 18

using LEVELREL, 18

using NOCONVERT, 18

using parent relation, 18

using POSLIST, 18

using related dimension, 18

using values, 18

LIMIT function, 18

limiting

alias dimensions, 12

dimensions, 18

multidimensional valuesets, 12

LIMITMAPINFO function, 18

LIMIT.SORTREL option, 18

LIMITSTRICT option, 18, 18

line size for report heading, 18

LINENUM option, 18

lines on a page of report output, 21

LINESLEFT option, 18

LISTBY program, 18

LISTFILES command, 18

LISTNAMES program, 18

literals

numeric, 2.2

text, 3.6

LOAD command, 18

loans, 15

interest payment on, 15

interest payments on, 26

payment on, 15

payments on, 26

local variables, 26, 26

localization options, 20, A.2

LOG command, 18

LOG function, 18

LOG10 function, 18

logical operators, 3.2.3

logs

calculating base 10 logarithm, 18

calculating natural logarithm, 18

LOOP clause in SQL FETCH, 24

looping, 15

over dimension status, 15

statements, 7.2.3.1

LOWCASE function, 18

lowercase, converting to, 18

LPAD function, 18

LSIZE option, 18

LTRIM function, 18

M

MAINTAIN command

event, 26, 26

MAINTAIN ADD, 18

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

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

MAINTAIN ADD SESSION, 18

MAINTAIN DELETE, 18, 18, 18

MAINTAIN MERGE, 18

MAINTAIN MOVE, 18

MAINTAIN RENAME, 18

trigger, 26, 26

Maintain event, 26

maintaining

alias dimensions, 12

composites, 18

dimensions, 18

partition templates, 18

partitions, 18

MAKEDATE function, 18

margins, 10

setting bottom margin, 10

setting top margin, 25

MAX function, 18

MAXBYTES function, 19

MAXCHARS function, 19

MAXFETCH option, 19

maximum values, 20

for each time period in the status, 20

larger of two expressions, 18

MEASUREDIM statement

for aggregation, 8

for allocation, 9

MEDIAN function, 19

median value, 19

messages, suppressing, 11

MIN function, 19

minimum value, 20

for each time period in the status, 20

smaller of two expressions, 19

MMOF function, 19

MODDAMP option, 19

MODE function, 19

models

adding to aggmap, 8

compiling, 6.3, 11, 19

creating, 19

debugging, 6.5

defined, 6.1

defining, 12

deleting, 12

editing, 19

in aggregation specifications, 8, 18, 18

obtaining information about, 17

removing from aggmap, 8, 8

running, 6.4, 19

scenario, 6.2.6

solution variables, 6.1

MODEL.XEQRPT program

compiling, 11

defining, 12, 12

including, 19

nesting, 19

options, 19, 19, 19, 19, 19, 19, 19

MODERROR option, 19

MODGAMMA option, 19

MODINPUTORDER option, 19

MODMAXITERS option, 19

MODOVERFLOW option, 19

MODSIMULTYPE option, 19

MODTOLERANCE option, 19

MODTRACE option, 19

module version numbers, 13

MONITOR command, 20

monitoring, 20

cost of program lines, 20

cost of programs, 25

MONTHABBRLEN option, 20

MONTHNAMES option, 20

MONTHS_BETWEEN function, 20

MOVE command, 20

MOVINGAVERAGE function, 20

MOVINGMAX function, 20

MOVINGMIN function, 20

MOVINGTOTAL function, 20

multidimensional valuesets, 12

multiline text, A.3.8.3

columns, 14

MULTIPATHHIER option, 20

multiwriter mode, 8, 10, 10, A.3.4, A.3.4

N

NA values

accepted as numeric input, 20, 20

caching, 26

comparing, 3.7.2, 3.7.2

controlling how treated, 3.10.2, 3.10.2, A.2.12

in Boolean expression, 3.7.2

in expressions, 3.10

permanently replacing, 26

replacing, 20

replacing with strings, 20

retrieving, 11

spelling of, 20

statements for working with, A.3.7

substituting another value, 20

triggers, 26, 26

working with, A.3.7

NAFILL function, 20, A.2.12

name, 20

changing object name, 22

dimension, 20

listing names of dictionary entries, 20

NAME dimension, 20

names

listing for objects, 18

listing objects by, 18

qualified object, 3.3.1

NASKIP option, 20, A.2.12

NASKIP2 option, 20, A.2.12

NASPELL option, 10, 20

NATRIGGER

See $NATRIGGER

NATRIGGER property

See $NATRIGGER property

natural logarithm, 18

negative value, 21

in output, 21

obtaining the root, 23

net present value, 20

NEW_TIME function, 20

NEXT_DAY function, 20

NLS options, 20, A.2

NLS_CALENDAR option, 20

NLS_CURRENCY option, 20

NLS_DATE_FORMAT option, 20

NLS_DATE_LANGUAGE option, 20

NLS_DUAL_CURRENCY option, 20

NLS_ISO_CURRENCY option, 20

NLS_LANG option, 20

NLS_LANGUAGE option, 20

NLS_NUMERIC_CHARACTERS option, 20

NLS_SORT option, 20

NLS_TERRITORY option, 20

NONE function, 20

NORMAL function, 20

NOSPELL option, 20

NPV function, 20

null values

See NA values

NULLIF function, 20

numbers

assigning random numbers, 22

commas in output, 11

decimal marker for output, 12

decimal places in output, 12

determining sign of, 23

negative values in output, 21

rounding, 23

thousands marker for output, 25

NUMBYTES function, 20

NUMCHARS function, 20

numeric data types, 2.2

comparing, 3.7.3, 3.7.3.3

mixing, 3.5.1

numeric expressions, 3.5

data type of the result, 3.5.1

dates in, 3.5.3

mixing data types, 3.5.1

text dimensions in, 3.5.2

numeric functions, A.3.10, A.3.10

numeric options, A.3.10

numeric values

rounding, 23

NUMLINES function, 20

NVL function, 20

NVL2 function, 20

O

OBJ function, 21

object definitions

adding descriptions to, 17

deleting descriptions from, 17

statements for manipulating, A.3.14

objects, 11

acquired (list of), 10

checking for changes, 21

compiling, 11

creating by copying, 11

creating properties, 21

data type of (determining), 21

defining, 12

definition (retrieving), 21

deleting, 12, 12

describing its definition, 13

describing its properties, 15

dimensions of (retrieving), 21, 21

dropping changes, 23, 23

exporting from analytic workspace, 14

identifying triggers, 26

importing into analytic workspace, 16

in expressions, 3.3

listing, 21

listing names of, 18, 18, 20

loading, 18

making current, 11

managing in multiwriter mode, A.3.4

obtaining information, 21

pages used to store (determining), 21

qualified name, 3.3.1

recalculating permissions, 21

renaming, 22

restrictions on name, 12

statements for defining, A.3.2, A.3.14

statements for deleting, A.3.14

storage class (determining), 21

testing for existence, 13

OBJLIST function, 21

OBSCURE function, 21

OESEIFVERSION option

name change, Preface

See EIFVERSION option

OKFORLIMIT option, 21

OKNULLSTATUS option, 18, 21

OLAP

Data Definition Language See OLAP DML

OLAP DML

definition, 1.1

functional categories, A.1

OLAP DML statements

abbreviations, 7

OLAP session cache

blocking creation of, 23

checking if empty, 21

defined, 23

for variable, 21

non-NA values, 21

populating with aggregated values, 8, 26

populating with NA values, 26

ONATTACH program, 21

OPEN command See SQL command in OLAP DML, 24

operating system, identifying, 25

operators, 18

Boolean, 3.2.3

comparisons, 3.2.3

conditional, 3.8, 3.8

LIKE, 17, 17, 18

logical, 3.2.3

overview, 3.2

substitution, 3.9

options

displaying value of, 1.2.1

localization, 20

NLS, 20

restoring previous values, 7.2.4.3

retrieving, 1.2.1

saving current values, 7.2.4.3

specifying, 1.2.1

Oracle OLAP

internal build number, 13

outfile

current, 13

OUTFILE command, 21, 21

OUTFILEUNIT option, 21

out-of-range decimal values, 12

output, 21

redirecting, 21

saving in a file, 21

overflow condition, 12

P

padding expressions, 18, 23

PAGE command, 21

PAGENUM option, 21

PAGEPRG option, 21

PAGESIZE, 21

paging in reports, 21

forcing a page break, 21

line number on current page, 18

lines for bottom margin, 10

lines for top margin, 25

lines left on page, 18

lines on a page, 21

page number, 21

producing a custom heading, 21

producing a standard heading, 25

turning on, 21

PAGING option, 21

PARENS option, 21

PARSE command, 17, 21

parsing expressions, 21

partition templates, 12, 12

defining, 12, 12

deleting, 12

maintaining, 18

retrieving partition names, 21

retrieving partitioning method, 21

PARTITIONCHECK function, 21

partitioned variables, 12, 12

aggregating, 9, 21

defining, 12

deleting data from, 18

maintaining, 18

retrieving dimensions of, 21

retrieving partitioning method, 21

partitioning methods, 21

partitions, 12, 12

adding, 11

adding values to, 18, 18

concat, 12

defining, 12

list partitions, 12

deleting, 12

deleting data, 18

external, 9, 11, 12

internal, 12

list, 12

locking segments of, 24

moving values, 18

range, 12, 21

retrieving dimensions of, 21

retrieving names of, 21

specifying values of, 18

pattern matching, 3.7.6.1

payment schedules, 15

for loan interest, 15, 26

for loans, 15, 26

PERCENTAGE function, 21

permission

programs, A.3.18.5

permission programs, 7.6.1.1, 21, 21, 21

permissions, 21

assigning to an object definition, 21

recalculating permission, 21

specifying conditions for accessing, 21

violations of, 21

PERMIT command, 21

PERMIT_READ program, 7.6.1.1, 21

PERMIT_WRITE program, 7.6.1.1, 21

PERMITERROR option, 21

PERMITRESET command, 21

platform, determining, 25

POP command, 7.2.4.3, 7.2.4.4, 21, 21

popping a whole series at once, 21

POPLEVEL command, 21

nesting, 21

using, 7.2.4.5

populating

alias dimensions, 12

POUTFILEUNIT option, 21

PRECOMPUTE statement, 8

PREPARE command

See SQL command in OLAP DML

PRGERR keyword (SIGNAL), 26

PRGTRACE option, 21

PROCEDURE statement

See SQL command in OLAP DML, 24

profiles, 25

PROGRAM command, 21

programs

adding program contents to a definition, 21

branching, 10, 11, 25

branching in, 18

branching labels, 16

calling, 10

case statement, 25

comment lines in, 7.2

compiling, 7.3, 7.3, 11, 11, 11

conditional execution of commands, 16, 26

debugging, 7.4, 14

declaring arguments in, 7.2.2.1

defining, 12

deleting, 12

determining how invoked, 10, A.3.18.5

error handling, 13, 13, 26

errors in, 7.2.5

executing, 7.5

halting execution with an error, 23

hiding, 16

local variable, 26

passing arguments to, 10, 10, 10, 10

performance cost, 25

permission, 7.6.1, 7.6.1.1, 21, 21, 21, 21, 21, 21, A.3.18.5, A.3.18.5

preserving environment, 7.2.4, 7.2.4

preserving status, 11, 11

repeating commands, 15

restoring previous values, 7.2.4.3

restoring status, 21, 21

returning a value, 23

saving compiled code, 7.3

saving current values, 7.2.4.3

saving status, 21, 21

startup, 7.6.1

statements for, A.3.18

suspending execution, 23

terminating execution of, 23

timing execution, 20, 25

trigger, 7.6.3.2, 26, 26, 26, 26, 26, 26, 26, 26

unhiding, 26

properties, 21

copying with an object definition, 11

creating for objects, 21

listing for objects, 15

PROPERTY command, 21

event, 26, 26

trigger, 26, 26

Property event, 26

PUSH command, 7.2.4.4, 21, 21

marking start of series, 21

placement, 7.2.5.6

using, 7.2.4.3

PUSHLEVEL command, 21

nesting, 21

placement, 7.2.5.6

Q

QDR, 3.3.4.2

QUAL function, 3.11.2.7, 21

qualified data references

ampersand substitution, 3.11.2.6

creating, 3.11.2

definition of, 3.11.2

for dimensions, 3.11.2.5

introduced, 3.3.4.2

qualifying a relation, 3.11.2.4

replacing dimension of variable, 3.11.2.2, 3.11.2.3

specifying explicitly, 21

using with relation, 3.11.2.4

with assignment statement, 3.11.2.2

with dimensions, 3.11.2

with relations, 3.11.2.4

with variables, 3.11.2.2, 3.11.2.2, 3.11.2.3

qualified object name, 3.3.1

R

RANDOM function, 22

random numbers, 20, 22

random sparsity, 12

RANDOM.SEED.1 option, 22

RANDOM.SEED.2 option, 22

range partitions

defining, 12

retrieving calculation for, 21

RANK function, 22

number of calls to, 22

number of computed values, 22

number of triggered sorts, 22

RANK_CALLS option, 22

RANK_CELLS option, 22

RANK_SORTS option, 22

ranking performance monitoring, 22

reading files, 22

current record number, 22

error diagnosis, 14

FILEREAD command, 15

processing a record, 15

reading a record, 15

RECAP command, 22

RECNO function, 22

RECURSIVE option, 22

REDO command, 22

REEDIT command, 22

REGRESS command, 17, 22

regression statements, A.3.11.1

regressions

linear, 22

statements for, A.3.11

REGRESS.REPORT program, 22

related dimensions, 3.3.3.3, 22, 25

limiting to, 18

RELATION command, 22

RELATION statement

for aggregation, 8

for allocation, 9

relational tables See tables

relations

assigning values to, 23, 23, 23

comparing to text literals, 3.7.6.2

default, 3.3.3.3, 22

defining, 12, 12

limiting to single value, 3.11.2.4

QDR with, 3.11.2.4

replacing dimension of, 3.11.2.4

RELEASE command, 22

REM function, 22

remainder after division, 22

REMBYTES function, 22

REMCHARS function, 22

REMCOLS function, 22

REMLINES function, 22

RENAME command, 22

REPLBYTES function, 22

REPLCHARS function, 22

REPLCOLS function, 22

REPLLINES function, 22

REPORT command, 22

reporting, 22

reports

processing ROW command output, 23

producing, 22, 23

producing with ROW commands, 23

RESERVED function, 23

reserved words, 23, 23

RESYNC command, 23, A.3.4

RETURN command, 23

return value of a program, 23

REVERT command, 23, 23

ROLE option, 23

roles, 25

root of negative number, 23

ROOTOFNEGATIVE option, 23

ROUND function

for dates and time, 23

for numbers, 23

ROW command, 23

processing output, 23

ROW function, 23

RPAD function, 23

RTRIM function, 23

running totals, 23, 26

run-time aggregation, 4.4

RUNTOTAL function, 23

S

scenario models, 6.2.6

seasonal data, 15

SECONDS option, 23

segment width, 11

segments

analytic workspace, 10

locking, 24

retrieving maximum size of, 10

SELECT statements (in OLAP DML), 24

T

tables

exporting from analytic workspaces, 24

importing into analytic workspaces, 24

TALLY function, 25

TAN function, 25

tangent calculation, 25

angle value, 10

arc, 10, 10

hyperbolic, 25

TANH function, 25

TCONVERT function, 25

temporary members

adding to dimension, 18

identifying, 17

TEMPSTAT command, 25

text

comparing values, 3.7.6

data types, 2.3

literals, 3.6, 3.7.6.2

manipulation functions, A.3.8

passing arguments as, 7.2.2.3, 18

special characters, 2.3.2

U

UNHIDE command, 26

UNIQUELINES function, 26

unnamed composites, 12

defining, 12

example of, 12

UNRAVEL function, 26

UPCASE function, 26

UPDATE command, 26

event, 26

events, 26, 26

trigger, 26

triggers, 26, 26, 26

user ID, retrieving, 25

user-defined functions

arguments in, 7.2.1

data type of, 7.2.1

USERID option, 26

USETRIGGERS option, 26

V

VALSPERPAGE program, 26

value name format, 26

W

WEEKDAYSNEWYEAR option, 26

WEEKOF function, 26

WHILE command, 10, 26

used with BREAK, 10

used with CONTINUE, 11

WIDTH_BUCKET function, 26

wildcards, 3.7.6.1, 3.7.6.1

WKSDATA function, 26

WORKSHEET data type, 2.1

worksheet objects

cells, 26

data type of cells, 26

defining, 12, 12, 12

deleting, 12

dimensions, 12

Y

YESSPELL option, 26

YRABSTART option, 26

YYOF function, 26

Z

zero, 13

dividing by, 3.5.5, 13

spelling of, 26

suppressing all-zero report rows, 26

ZEROROW option, 26

ZEROTOTAL command, 26

ZSPELL option, 26