Oracle9i OLAP Developer's Guide to the OLAP DML -- Index

% wildcard, 4-28

& operator, 4-30, 4-31

= command

ACROSS keyword, 5-12

example of, 5-12, 5-13

introduced, 4-3, 5-3, 5-10

saving calculations, 5-12

with composites, 5-12

with dimensions, 5-14

with models, 8-5

with QDR, 4-8, 5-14

with relations, 5-14

with variables, 5-11, 5-12

with variables using composites, 5-12, 5-13

= operator, See = command

_ wildcard, 4-28

ABS function, 4-24, 4-25

ACROSS phrase

used when reading files, 11-17

AGGINDEX command

definition, 12-9

purpose of, 12-9

AGGMAP command, 3-27, 12-7

aggmap object, See aggregation map

AGGMAPINFO command, 9-4

AGGREGATE command

introduced, 12-4

multiple variables, 12-11

AGGREGATE function

adding as a property to the variable, 12-23

introduced, 12-4

aggregating data

best practice, 12-24

for multiple variables, 12-11

list of commands, 12-3

methods, 12-14

on-the-fly, 12-2

overview, 12-2

precomputing, 12-2

process, 12-4

aggregation functions, NA values in, 4-33

aggregation map

commands for allocation, 9-5

compiling, 12-10

creating aggmap object, 12-7

for allocation, 9-5

how to define, 12-7

performance tip, 12-12

RELATION command, 9-6, 12-12

alias

analytic workspace, 2-8

directory, 11-4

ALLOCATE command, 9-2, 9-4

allocating data

introduction to, 9-2

list of related commands, 9-4

preparing for, 9-5

ALLOCERRLOGFORMAT command, 9-4

ALLOCERRLOGHEADER command, 9-4

ALLOCMAP command, 3-27, 9-4, 9-5

ampersand (&) operator, 4-30, 4-31

ampersand substitution

avoiding, 4-31

defined, 4-30

effect performance, 7-9

example of, 4-31

prevents compiling, 7-29

program arguments and, 7-9

QDR with, 4-10

restrictions, 8-6

using to pass arguments, 7-9

when required, 7-9

analytic workspaces

access from Java, 1-10

access from OLAP Worksheet, 1-6

access from SQL, 1-9

acquiring description of, 2-15

active workspace, 2-2

alias, 2-8

attached read-only or read/write, 2-4

attached workspace, 2-2

attaching, 2-3

committing changes, 2-9

controlling access to, 2-12

copying data into relational tables, 10-28 to 10-32

creating, 2-3

current workspace, 2-2

deleting, 2-5

detaching, 2-5

exporting, 2-14

importing, 2-14

introduction to, 1-2

list of attached, 2-2

minimizing growth of, 2-10

multiple, 2-6

name, 2-7

objects, acquiring information about, 2-15, 2-16, 2-17

objects, defining, 3-2

objects, defining in a program, 7-29

permission programs, 2-12, 2-13

populating, 5-1

populating from relational tables, 10-3 to 10-20

reorganizing, 2-10

retrieving name of, 2-2

saving changes to, 2-8

security, 2-12

sharing across sessions, 2-4

updating, 2-9

waiting for access, 2-5

AND operator, 4-21, 4-22

ARG function, 7-7

ARGFR function, 7-7

ARGS function, 7-7

ARGUMENT command

placement of, 7-7

use of, 7-7

using multiple, 7-8

arguments

in programs, 7-7

in user-defined functions, 7-12

passing as text, 7-9

using ampersand substitution with, 7-9

arithmetic expressions. See arithmetic operators, numeric expressions

arithmetic operators, 4-16

assignment operator. See = command

assignment statement. See = command

AUTOGO programs, 2-11

AW command, 2-5

ATTACH keyword, 2-3

CREATE keyword, 2-3

DETACH keyword, 2-5

LIST keyword, 2-2

NAME keyword, 2-2

WAIT keyword, 2-5

AW function, 2-15

AWDESCRIBE program, 2-15

backslash (escape sequence), 3-6

backspace (escape sequence), 3-6

BADLINE option, 7-30

base model, 8-4

batch window for aggregation, 12-2

Boolean

constants, 3-7, 4-21

data type, 3-7, 4-21

Boolean expressions

creating, 4-22

defined, 4-21

example of, 4-23

involving NA values, 4-24

operators, 4-21

values, 4-21

with more than one dimension, 6-6

Boolean operators

evaluation order, 4-21

table of, 4-21

branching in programs, 7-17

BTREE indexes in aggregation, 12-4, 12-6

CACHE command

definition, 12-9

purpose of, 12-9

calculation on-the-fly

a typical strategy, 12-25

requirements for, 12-22

calculations

controlling errors during, 4-19

in models, 8-6

CALL command, 7-2

carriage return (escape sequence), 3-6

CDA command, 2-14, 7-17, 11-4

cells, empty, 3-18

characters

representing as decimals, 3-6

representing as hexadecimals, 3-6

representing as Unicode, 3-6

CHGDFN command

aggregation, 12-6

for variables, 3-28

CHILDLOCK command, 9-6

CLEANUP statement (SQL), 10-14

CLOSE statement (SQL), 10-13, 10-14

comments in programs, 7-4

COMMIT command, 2-9

comparison operators, 4-21

COMPILE command

example of, 7-28

in models, 8-5, 8-7

introduction to, 7-28

composites

assigning names to unnamed, 3-20

defined, 3-18

defining single-dimension, 3-22

in expressions, 4-13

limiting base dimensions, 6-18

limiting dimensions used by, 4-14, 6-18

maintaining, 5-9

named, 3-18

naming, 3-20

renaming, 3-20

single-dimension, 3-22

unnamed, 3-18, 3-21

unnaming, 3-20

using commands with, 4-14

concat dimensions, 3-8

defined, 3-25

defining variables for, 3-26

example of, 3-26

limiting, 6-20

maintaining, 5-10

self-relations for, 3-26

conditional expressions, 4-29, 4-30

conditional operators

defined, 4-29

example of, 4-30

conjoint dimensions

deleting values from, 5-8

limiting, 6-19

maintaining, 5-9

maintaining when reading files, 11-10

merging values into, 5-6

CONSIDER command, 3-27

CONTEXT

command, 7-22

function, 7-22

control structures in programs, 7-14

controlled sparsity, 3-18

CONVERT function, 4-3

COPY operator for allocation, 9-10

current analytic workspace, defined, 2-2

current outfile, 7-18

current status, 6-2

cursors (SQL)

closing, 10-13, 10-14

declaring, 10-5

opening, 10-8

data aggregation

best practice, 12-24

creating the aggregation map, 12-7

for multiple variables, 12-11

data types

converting, 4-3, 4-17

date, 3-7

numeric, 3-4

of expressions, 4-2

of numeric expressions, 4-15, 4-17

of user-defined function, 7-12

text, 3-5

data values

accessing variable, 4-13

converting when reading files, 11-10

numeric, 4-15

saving calculations, 5-12

DATE data type, 3-7

dates

comparing with times, 4-27

in arithmetic expressions, 4-18

in text expressions, 4-20

reading from files, 11-15

DATETIME data type, 3-7, 4-20

DBGOUTFILE command, 7-31, 8-11

DEADLOCK command, 9-6

debugging programs, 7-29

DECIMAL data type, 3-4, 4-25

decimal data types, comparing, 4-25

DECIMALOVERFLOW option, 4-20

DECIMALS option, 4-24, 4-25

DECLARE CURSOR statement (SQL), 10-5

default outfile, 7-18

DEFINE command, 3-2

AGGMAP, 12-7

COMPOSITE keyword, 3-18, 3-19

DIMENSION keyword, 3-22, 3-25

MODEL keyword, 8-5

PROGRAM keyword, 7-3

RELATION keyword, 3-13

SPARSE keyword, 3-18

SURROGATE keyword, 3-11

VALUESET keyword, 6-22

VARIABLE keyword, 3-18

definitions

changing, 3-27

displaying, 2-15, 2-16

distinct from data, 3-2

DELETE keyword, 2-5

DESCRIBE command, 2-16

DIMENSION command, 8-5, 8-6, 9-6

dimension order in models, 8-6

dimension status, 6-2

effect of MAINTAIN command on, 5-4

effect on expressions, 4-6

examining, 6-25

if dimension is empty, 6-21

if valueset is empty, 6-21

null, 6-21

of concat dimension, 6-20

of conjoint dimension, 6-19

of dimensions used by composites, 4-14, 6-18

restoring, 6-4, 6-22, 7-20

retrieving current values, 6-25

retrieving default values, 6-25

saving, 6-22

saving current status, 6-4, 7-20

setting to a list of values, 6-4

setting to a literal value, 6-5

setting to null, 6-21

setting using position in dimension, 6-12, 6-13

when reading files, 11-20

dimension surrogates

defining, 3-11

differences from dimensions, 3-12

in expressions, 4-12

dimension values

comparing, 4-26

translating when reading files, 11-11

dimension-based equations, 8-2

dimensions

adding values to, 5-5

assigning values to, 5-14

comparing values, 4-26

concat, 3-8, 3-25

defined, 3-8

defining, 3-22, 3-23, 3-25

defining in a program, 7-29

deleting values from, 5-7

examining values in status, 6-25

hierarchical, 3-22, 3-23

how data is stored, 3-10

in expressions, 4-12

level of detail, 3-9

limiting to a percentage of values, 6-9

limiting to Boolean expressions, 6-5

limiting to bottom performers, 6-10

limiting to related dimension, 6-11

limiting to single value, 4-6

limiting to top performers, 6-10

limiting when reading files, 11-20

limiting, based on position, 6-12, 6-13

limiting, using a valueset, 6-23

limiting, using hierarchical relationship, 6-13, 6-16

looping over values of, 7-15, 7-16

maintaining when reading files, 11-7

merging values into, 5-5

numeric value of text dimension, 4-18

of expression, 4-5, 4-6

of relations, 3-13

position of values in valueset, 6-25

QDR with, 4-6, 4-10

relations between, 3-15

repositioning values in, 5-8, 5-9

restoring previous values, 7-20

retrieving default status list, 6-25

retrieving list of objects related to, 2-16

running programs when limiting, 6-16

saving current values, 7-20

sorting values in, 5-8

storage of, 3-10

surrogate for, 3-11

types of, 3-8

ways to define, 3-22, 3-25

direct allocation, 9-8, 9-13

directory alias, 2-14, 7-17, 11-4

DIVIDEBYZERO option, 4-19

DML

and SQL, 1-3

and the OLAP API, 1-3

definition, 1-2

using, 1-3

double quotes (escape sequence), 3-6

ECHOPROMPT option, 7-19, 7-31

EIF file, 2-14

embedded totals dimension, 3-24, 3-26

empty cells, 3-18

EQ command, 3-28

EQ operator, 4-21, 4-22

equations

cyclic dependence (in models), 8-9

dimension-based, 8-2

in models, 8-6

simple blocks, 8-8

step blocks, 8-8

error log, 9-5, 9-17

error messages

creating your own, 7-25

deferring, 7-23

routing to a file, 7-19, 9-17

suppressing, 7-24

system, 7-24

error names, 7-24

ERRORLOG command, 9-6

ERRORMASK command, 9-6

ERRORNAME option, 7-23, 7-24

errors

controlling during calculations, 4-19

handling, 7-23

handling in nested programs, 7-26, 7-27

identifying, 7-24

names of, 7-24

signaling, 7-25, 7-26, 7-27

when comparing numeric data, 4-24, 4-25

ERRORTEXT option, 7-23

escape sequences, 3-6

EVEN operator for allocation, 9-2

EXECUTE statement (SQL), 10-28

EXPORT command, 2-14

expressions

ampersand substitution, 4-30, 4-31

Boolean, 4-21, 4-29, 4-30, 6-5, 6-6

changing the default behavior, 5-12

conditional, 4-29, 4-30

data type of, 4-2

dates in, 4-18

defined, 4-2

dimension surrogates in, 4-12

dimensions in, 4-12

dimensions of, 4-5, 4-6

evaluating, default behavior, 5-12

formulas in, 4-12

functions in, 4-12

mixing numeric data types, 4-17

numeric, 4-15

objects in, 4-12

relations in, 4-12, 4-15

substitution, 4-30, 4-31

text, 4-20

using composites in, 4-13

using text dimension in numeric expression, 4-18

valuesets in, 4-12

variables in, 4-12

fastest-varying dimension, 3-17

FETCH statement (SQL), 10-9

file identifier, 11-4

file names, 11-4

FILENEXT function, 11-15

FILEOPEN function, 11-4

FILEREAD command, 5-3

files

appending output, 7-18

fileunit, 11-4

maintaining dimensions from, 11-7, 11-10

modifying data from, 11-14

names and identifiers, 11-4

reading, 11-1

reading coded dimension values, 11-12

reading in programs, 11-5

reading individual records, 11-15

reading structured PRN, 11-6

reading with FILENEXT function, 11-15

saving output in, 7-17, 7-18

scaling input data from, 11-13

fileunit, 11-4

FILEVIEW command, 11-15

financial analysis, scenario modeling, 8-12

floating point numbers, comparing, 4-25

floating-point format

limitations when calculating, 4-18

use of, 4-18

FOR command

example of, 7-16

looping over dimension values, 7-15, 7-16

forecasting data, 5-15

form feed (escape sequence), 3-6

formulas in expressions, 4-12

functions

defined, 4-15

in expressions, 4-12

numeric, 5-16

user-defined, 7-3, 7-11, 7-12

writing, 7-11

GE operator, 4-21, 4-22

globalization, 2-6

GT operator, 4-21, 4-22

HASH indexes in aggregation, 12-6

HEVEN operator for allocation, 9-8

HFIRST operator for allocation, 9-13

hierarchical dimensions

defined, 3-22

defining variables for, 3-24

drilling down, 6-16

example of, 3-23, 3-24

limiting based on relationship within, 6-13, 6-16

self-relations for, 3-24

HLAST operator for allocation, 9-13

horizontal tab (escape sequence), 3-6

host variables (SQL)

input, 10-6

output, 10-9

ID data type, 3-5

IFNONE keyword, 7-17

implicit relations, 3-13

IMPORT command, 2-14, 5-3

IMPORT statement (SQL), 10-9

IN operator, 4-21, 4-22

INCLUDE command, 8-4, 8-5, 8-6

INFO function

determining dimensionality with, 4-5

DIMENSION keyword, 4-6

with models, 8-11

input host variables (SQL), 10-6

INSTAT function, 6-3, 6-25

INTEGER data type, 3-4

labels

in programs, 7-24

with IFNONE, 7-17

LAG function, 4-18, 8-10

LD command, 3-28

LE operator, 4-21, 4-22

LEAD function, 4-18, 8-10

level relation, defined, 12-4

LIKE operator, 4-21, 4-22, 4-28

LIMIT command

DESCENDANT keyword, 6-14

examples of, 6-5, 6-9, 6-10, 6-11, 6-16, 6-23

HIERARCHY keyword, 6-13, 6-14

NOCONVERT keyword, 6-13

NULL keyword, 6-21

overview, 6-4

POSLIST keyword, 6-12

relation dimension, 6-11

RUN keyword, 6-16

with Boolean expression, 6-5, 6-6

with concat dimension, 6-20

with conjoint dimension, 6-19

with variables with composite, 4-14, 6-18

linefeed (escape sequence), 3-6

LISTNAMES program, 2-16

literals

numeric, 3-4

text, 4-20

local variables, 7-5

localization, 2-6

locking values in an allocation, 9-12, 9-15

logical operators, 4-21

LONGINTEGER data type, 3-4

LT operator, 4-21, 4-22

MAINTAIN command

adding values using, 5-5

deleting values using, 5-7, 5-8

effect on dimension status, 5-4

introduced, 5-3

merging values using, 5-5, 5-6

overview of, 5-3

repositioning values using, 5-8

when objects are updated, 5-4

with composites, 5-9

with concat dimensions, 5-10

with conjoint dimensions, 5-9

MAX operator for allocation, 9-8

MODEL command, 3-28, 8-5

MODEL.COMPRPT program, 8-11

MODEL.DEPRPT program, 8-11

models

base, 8-4

basic commands, 8-5

compiling, 8-3, 8-7

creating, 8-2

creating a nested hierarchy, 8-4

debugging, 8-11

defined, 8-2

editing, 8-2

parent, 8-4

running, 8-3, 8-9

scenario, 8-12

solution variables, 8-2

types of solution blocks, 8-8

MODEL.XEQRPT program, 8-11

MODTRACE option, 8-11

multidimensional data model, 3-16

multiple analytic workspaces, 2-6

NA values, 3-18

comparing, 4-24

controlling how treated, 4-32

defined, 4-32

in aggregation functions, 4-33

in an allocation, 9-6, 9-7

in arithmetic operations, 4-34

in Boolean expression, 4-24

substituting another value for, 4-34

times when relevant, 4-32

NAFILL function, 4-32, 4-34

NAME dimension, 2-16

named composites, defined, 3-18

NASKIP option, 4-32, 4-33

NASKIP2 option, 4-32, 4-34

NASPELL option, 7-7

NE operator, 4-21, 4-22

NLS options, 2-6

NOL_SORT option, 4-27

NOPRINT keyword (TRAP), 7-24, 7-27

NOSPELL option, 3-7

NOT operator, 4-21, 4-22

NTEXT data type, 3-5

NUMBER data type, 3-5

NUMBER dimension, surrogate for, 3-11

numeric data types

automatic conversion of, 4-17

comparing, 4-24, 4-25

list of, 3-4

mixing, 4-17

numeric expressions

data type of the result, 4-15, 4-17

dates in, 4-18

defined, 4-15

evaluating, 4-16

mixing data types in, 4-17

NA values in, 4-34

OBJ function

PROPERTY keyword, 12-5

workspace object information, 2-17

objects

assigning values to, 4-3, 5-10

changing definition of, 3-27

definitions, 3-2

displaying definitions of, 2-16

in expressions, 4-12

list of, 3-3

maintaining, 5-4

retrieving information about, 2-17

retrieving list of, 2-16

updating, 5-4

OKNULLSTATUS option, 6-21, 7-17

OLAP Worksheet, 1-6

OPEN statement (SQL), 10-8

operators

arithmetic, 4-16

Boolean, 4-21

comparison, 4-21

conditional, 4-29, 4-30

for allocation, 9-7

logical, 4-21

substitution, 4-30, 4-31

options

restoring previous values, 7-20

saving current values, 7-20

OR operator, 4-21, 4-22

OUTFILE command, 7-17, 7-18

OUTFILEUNIT option, 12-21

output

host variables, 10-9

saving in a file, 7-17, 7-18

parent model, defined, 8-4

parent relation, defined, 12-4

PARSE command, 4-5, 4-6

pattern matching, 4-28

permission programs, 2-12

PERMIT command, 2-13, 3-28

PERMIT_READ program, 2-12, 2-13

PERMIT_WRITE program, 2-12, 2-13

POP command, 7-20, 7-21

POPLEVEL command

nesting, 7-22

using, 7-21

populating analytic workspaces, 5-1

POUTFILEUNIT option, 9-4, 12-4, 12-21

PREPARE statement (SQL), 10-28

PRGERR keyword (SIGNAL), 7-26

PRGTRACE option, 7-31

PRN files, reading, 11-6

PROGRAM command, 3-28

programs

analytic workspace permission, 2-13

arguments, 7-7

AUTOGO, 2-11

automatic running of, 2-11, 6-16

branching in, 7-17

branching labels, 7-14

comment lines in, 7-4

compiling, 7-9, 7-28

control structures, 7-14

debugging, 7-29

declaring arguments in, 7-7, 7-8

defined, 7-2

defining, 7-3

designing, 7-5, 7-14

errors in, 7-23

executing, 7-2

LISTNAMES, 2-16

permission, 2-12

PERMIT_READ, 2-12, 2-13

PERMIT_WRITE, 2-12, 2-13

preserving environment, 7-19

restoring previous values, 7-20

running, 7-29

sample, 7-12

saving compiled code, 7-28

saving current values, 7-20

testing by running, 7-29

variables in, 7-4, 7-5

PROPERTY command, 3-28

PROPORTIONAL operator for allocation, 9-15

protecting values in an allocation, 9-12, 9-15

PUSH command, 7-21

placement, 7-23

using, 7-20

PUSHLEVEL command

nesting, 7-22

placement, 7-23

QON, 2-6

QUAL function, 4-10

qualified data references

ampersand substitution, 4-10

creating, 4-6

defined, 4-6

qualifying a relation, 4-9

replacing dimension of variable, 4-7, 4-8

using with = command, 4-8, 5-14

using with relation, 4-9

with dimensions, 4-6

with relations, 4-9

with variables, 4-7, 4-8

qualified object names, 2-6

quotation marks (escape sequence), 3-6

random sparsity, 3-18

RAW DATE attribute

when reading files, 11-15

records, reading, 11-15

recursive allocation, 9-10, 9-15

RELATION command, 12-7

arguments for allocation, 9-7

for allocation, 9-6

operators for allocation, 9-7

syntax for aggregation, 12-12

relational data, 10-1

See also SQL

copying into analytic workspace, 10-3 to 10-20

inserting from analytic workspace, 10-28 to 10-32

updating from analytic workspace, 10-28 to 10-32

relations

assigning values to, 5-14

between two dimensions, 3-15

comparing to text literals, 4-29

defined, 3-13

defining, 3-15

dimensionality of, 3-13

example of, 3-15, 3-24, 3-26

how data is stored, 3-14

implicit, 3-13

in aggregation, 12-4

in allocation, 9-5, 9-6, 9-9

in expressions, 4-12, 4-15

limiting to single value, 4-9

QDR with, 4-9

replacing dimension of, 4-9

self, 3-15, 3-24, 3-26

used when reading files, 11-13

REMOPERATOR in an allocation, 9-9

REPORT command

for viewing objects, 2-17

with sparse data, 4-14

RETURN command, 7-11

ROLLBACK, effect on changes, 2-10

ROOTOFNEGATIVE option, 4-20

ROUND function, 4-24, 4-25

run-time aggregation, 12-2

scenario model, defined, 8-12

scenarios for financial modeling, 8-12

sessions

preserving environment, 7-19

restoring environment, 7-20

sharing analytic workspaces across, 2-4

SHORTDECIMAL data type, 4-25

SHORTINTEGER data type, 3-4

SIGNAL command, 7-25

simple blocks (in models), 8-8

simultaneous equations in models, 8-10

single quotes (escape sequence), 3-6

slowest-varying dimension, 3-17

solution variables

defined, 8-2

example of, 8-12

source object for allocation, 9-5

SOURCEVAL command, 9-6

sparse data, 3-18

controlled sparsity, 3-18

defined, 3-18, 4-32

eliminating, 3-18 to 3-21

random sparsity, 3-18

setting dimension status, 6-18

SQL, 10-1

See also relational data

error handling, 10-34

OLAP DML command, introduced, 5-3

precompiling code, 10-28

stored procedures, 10-32

triggers, 10-32

SQL statements

issuing through OLAP DML, 10-2 to 10-33

STATFIRST function, 6-3, 6-25

STATLAST function, 6-3, 6-25

status. See dimension status

step blocks (in models), 8-8

storage

of dimensions, 3-10

of relations, 3-14

of variables, 3-17

stored procedures, 7-2

structured files, reading, 11-6

substitution expressions, 4-30, 4-31

substitution operator, 4-30, 4-31

surrogates. See dimension surrogates

SYSINFO function, 2-13

tab (escape sequence), 3-6

temporary variables, 7-5, 11-20

text

comparing values, 4-27, 4-28

comparing values to a pattern, 4-28

data types, 3-5

NLS_SORT option in comparisons, 4-27

passing arguments as, 7-9

TEXT data type, 3-5

text expressions

dates in, 4-20

defined, 4-20

text literals

comparing to relations, 4-29

defined, 4-20

TRAP command, 7-23, 7-26, 7-27

unnamed composites, 3-18, 3-21

defining, 3-21

example of, 3-21

naming, 3-20

UPDATE command, 2-9

user-defined functions, 7-11

arguments in, 7-12

data type of, 7-12

defined, 7-2

executing, 7-3

VALUE keyword

used in reading files, 11-12

used when reading files, 11-14

values

assigning to dimensions, 5-14

assigning to objects, 5-10

assigning to relations, 5-14

assigning to variables, 5-12

assigning to variables with composites, 5-12, 5-13

assigning, using a QDR, 5-14

in current status list, 6-25

in default status list, 6-25

NA, 3-18

restoring previous, 7-20

saving current, 7-20

VALUES function, 6-3, 6-25

valuesets

creating, 6-22

defined, 6-22

defining, 6-22

in expressions, 4-12

limiting using, 6-23

listing dimension positions in, 6-25

VARIABLE command, 7-6

variables

accessing, 4-13

aggregating data for multiple, 12-11

assigning values to, 5-11, 5-12, 5-13, 5-14

controlling sparsity in, 3-18

defined, 3-16

defining in a program, 7-29

defining with composite, 3-18 to 3-21

defining with unnamed composite, 3-21

dimensioned, 3-17

how data is stored, 3-17

in expressions, 4-12

limiting to single value, 4-7, 4-8

local, 7-5

NA values in, 3-18

persistence of, 7-4, 7-5

QDR with, 4-7, 4-8

replacing dimension of, 4-7, 4-8

sparse data in, 4-14

storage of, 3-17

temporary, 7-5

undimensioned, 3-17

with embedded totals, 3-24, 3-26

with NA values, 3-18

with single-dimension composite, 3-22

WHERE clauses (SQL), 10-7

wildcards, 4-28

YESSPELL option, 3-7

zero, dividing by, 4-19

Index

Symbols

A

B

C

D

E

F

G

H

I

L

M

N

O

P

Q

R

S

T

U

V

W

Y

Z