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

- continuation character, 8-7

- operator, 4-25

% wildcard, 4-37

& operator, 4-39

= command

ACROSS keyword, 5-15

example of, 5-15, 5-16

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

saving calculations, 5-15

with composites, 5-15

with dimensions, 5-17

with models, 7-6

with QDR, 4-20, 5-17

with relations, 5-17

with variables, 5-14, 5-15

with variables using composites, 5-15, 5-16

= continuation character, 8-7

= operator, See = command

_ wildcard, 4-37

_MSGID dimension, 8-31

_MSGTEXT variable, 8-31

ABS function, 4-32, 4-33

ACROSS phrase

data-reading commands, 11-22

in ROW command, 12-7

aggregation functions, NA values in, 4-42

ampersand (&) operator, 4-39

ampersand substitution

avoiding, 4-40

defined, 4-39

detecting logic errors, 8-37

effect performance, 8-14

example of, 4-39

program arguments and, 8-13 to 8-14

QDR with, 4-20

restrictions, 7-6

using to pass arguments, 8-13

when required, 8-14

analytic workspaces

active, 2-9

attached, 2-9

attached exclusively, 2-11

attached read-only, 2-11

attached read/write nonexclusive, 2-11

attaching, 2-9, 2-10, 2-11

attaching exclusively, 2-18

controlling access, 2-21

controlling access to, 2-20 to 2-22

creating, 2-2

current, 2-9

detaching, 2-10, 2-13

displaying description of, 2-23

extension file, 2-3

files, exporting, 2-16

files, importing, 2-16

files, reorganizing, 2-16

getting information about, 2-23

limiting access to, 5-4

list, 2-9

main file, 2-3

metadata, A-1

minimizing growth of, 2-14

minimizing size of, 2-16

multifile, 2-3

multiple, 2-12

objects, acquiring information about, 2-23, 2-25, 2-26, 2-27

objects, defining, 3-2

objects, defining in a program, 8-36

passwords for, 2-20, 2-21

permission programs, 2-12, 2-21

permission programs for, 2-21, 5-4

populating, 5-3, 5-19

read-only access to, 2-22

retrieving information about, 2-23

retrieving name of, 2-10

rolling up data, 5-19

saving changes to, 2-13

sharing across sessions, 2-17

update status, 2-9

updating, 2-14

using commands to populate, 5-3

waiting for, 2-18

AND operator, 4-29, 4-30

ARG function, 8-11

ARGFR function, 8-11

ARGS function, 8-11, 9-8

ARGUMENT command

placement of, 8-11

use of, 8-11

using multiple, 8-12

arguments

expressions used as, 8-15

in programs, 8-11

in user-defined functions, 8-17

passing as text, 8-13

passing by value, 8-15

using ampersand substitution with, 8-13 to 8-14

arithmetic expressions. See arithmetic operators, numeric expressions

arithmetic operators, 4-23

ASCII character set, 4-36

assignment operator. See = command

assignment statement. See = command

attributes

attribute dimension, defined, A-7

attribute dimension, how to define, A-7

attribute dimension, properties required, A-8

attribute domain relation, definition, A-21

attribute name variable, purpose of, A-22

DBATTRDIM property, A-20

definition, A-20

domain dimension, definition, A-20

domain relation, how to define, A-21

metadata required, A-20

range dimension, definition, A-20

range relation, A-21

setting the EXPOBJVAR property on the attribute dimension, A-22

setting the RANGEDIMREL property on the attribute dimension, A-22

AUTOGO programs, 2-19

defining, 2-19

running, 2-19

BACK debugger command, 9-8

backslashes

escape sequence for, 4-3

in path names, 11-5

backspace (escape sequence), 4-3

BADLINE option, 8-38

base model, 7-4

BLANK command, 12-5

BMARGIN option, 12-26

Boolean

Boolean expressions

involving NA values, 4-32

operators, 4-29

values, 4-28

with more than one dimension, 6-8

Boolean operators

evaluation order, 4-29

table of, 4-29

calculations

controlling errors during, 4-27

in models, 7-6

in reports, 12-20, 12-24

CALL command, 8-15

carriage return (escape sequence), 4-3

cells, empty, 3-15

CENTER attribute (ROW), 12-12

changes, saving, 2-13

character set, 4-36

characters

representing as decimals, 4-3

representing as hexadecimals, 4-3

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

columns

headings in reports, 12-17

modifying in reports, 12-12

COLVAL function, 12-20

COLWIDTH option, 12-11

command line utilities, 2-18

commands

debugger, 9-7

limiting usage of, 5-4

reporting, 12-3

to populate analytic workspaces, 5-3

using with composites, 4-8

commas, 4-25

comments in programs, 8-7

COMMIT statement (SQL), 10-5, 10-14

comparison operators, 4-29

COMPILE command

example of, 8-35

in models, 7-6, 7-8

introduction to, 8-36

composites

assigning names to unnamed, 3-17

defined, 3-16

defining single-dimension, 3-19

in expressions, 4-7

limiting base dimensions, 6-21

limiting dimensions used by, 4-8, 6-21

single-dimension, 3-19

unnamed, 3-16, 3-18

unnaming, 3-17

using commands with, 4-8

conditional expressions, 4-37, 4-38

conditional operators

defined, 4-37

example of, 4-38

introduced, 4-10

conjoint dimensions

deleting values from, 5-11

limiting, 6-22, 6-23

maintaining, 5-13

maintaining with programs, 11-14

merging values into, 5-9

CONSIDER command, 3-24

CONTEXT

command, 8-28

function, 8-28

continuation characters, 8-7

control structures in programs, 8-19

controlled sparsity, 3-15

CONVERT function, 4-12, 4-25, 4-28

changing data type, 4-11, 4-12

for formatting headings, 12-18

currency symbols in reports, 12-15

current analytic workspace, defined, 2-9

cursor (SQL)

data

data types

of numeric expressions, 4-23, 4-24, 4-25

of user-defined function, 8-16

text, 4-3

time, 4-5

data values

accessing variable, 4-8

converting, using programs, 11-12

numeric, 4-23

rolling up, 5-19

saving calculations, 5-15

DATABASE command

ATTACH keyword, 2-10, 2-11

PASSWORD keyword, 2-20, 2-21

WAIT keyword, 2-17

DATABASE function, 2-23, 2-24

data-reading commands

ACROSS phrase, 11-22

limiting the ACROSS dimension, 11-24

DATE data type, 4-4, 4-28, 5-7, 6-6

date functions, 12-30

DATEFORMAT option, 4-28

DATEORDER option, 4-4, 4-5, 5-7, 6-6

dates

comparing with times, 4-35

concatenating, 4-6

in arithmetic expressions, 4-25

in text expressions, 4-28

reading with data-reading commands, 11-19

representing, 4-4

specifying time dimension values, 4-5

valid values, 4-4

DAY data type, 4-5

DBATTRDIM property

defined, A-7

how to set on ECMLOCATOR, A-8

DBDESCRIBE program, 2-9, 2-23

DBDIMDIM property

how to set on ECMLOCATOR, A-5

purpose of, A-4

DBEXTENDPATH option, 2-3

DBFOLDERDIM property

defined, A-9

how to set on ECMLOCATOR, A-10

DBGOUTFILE command, 8-24, 9-4

DBMEASDIM property

how to set on ECMLOCATOR, A-7

purpose of, A-6

DBSEARCHPATH option, 2-3

debugger commands, 9-7

debugger. See OLAP DML debugger

DECIMAL attribute (ROW), 12-12

DECIMAL data type, 4-2, 4-33

decimal data types

comparing, 4-33

decimal values, formatting, 4-25

DECIMALOVERFLOW option, 4-27

DECIMALS option, 4-32, 4-33, 12-11

DECLARE CURSOR statement (SQL), 10-7, 10-8

DEFINE command, 3-2

COMPOSITE keyword, 3-16, 3-17

DIMENSIONS keyword, 3-20

MODEL keyword, 7-6

PROGRAM keyword, 8-5

SPARSE keyword, 3-16

VARIABLE keyword, 3-14, 3-16

definitions

changing, 3-24

displaying, 2-23, 2-25

of objects, 3-1

DESCRIBE command, 2-25

dimension

hierarchy level, A-16

DIMENSION command, 7-6, 7-7

dimension dimension

definition, A-4

how to define, A-4

properties required, A-5

dimension hierarchies

metadata required to display, A-10

number-of-hierarchies formula, A-12

dimension member level relation

how to define, A-17

purpose of, A-17

dimension order in models, 7-7

dimension status, 6-11

dimension values

comparing, 4-34

translating coded, 11-14

dimension-based equations, 7-2

dimensions

adding values to, 5-5

assigning values to, 5-17

comparing values, 4-34

defined, 3-4

defining, 3-20, 3-21

defining in a program, 8-36

deleting values from, 5-10

domain, A-20

examining values in status, 6-27

hierarchical, 3-20, 3-21

hierarchy, setting the default, A-13

how data is stored, 3-5

in expressions, 4-6

level of detail, 3-4

limiting to a percentage of values, 6-12

limiting to Boolean expressions, 6-7

limiting to bottom performers, 6-11

limiting to single value, 4-16

limiting to top performers, 6-11

limiting, based on position, 6-15, 6-16

limiting, using a valueset, 6-26

limiting, using data-reading commands, 11-25

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

limiting, using time values, 6-6

looping over values of, 8-21, 8-22

maintaining with programs, 11-9

merging values into, 5-5

numeric value of text dimension, 4-25

of expression, 4-14, 4-15

of relations, 3-7

position of values in valueset, 6-28

QDR with, 4-16, 4-19

range, A-20

relations between, 3-8

repositioning values in, 5-11, 5-12

restoring previous values, 8-27

restricting maintenance on, 5-4

retrieving default status list, 6-28

retrieving list of objects related to, 2-26

running programs when limiting, 6-19

saving current values, 8-26

sorting values in, 5-12

storage of, 3-5

types of, 3-4

ways to define, 3-20

DIVIDEBYZERO option, 4-27

DO/DOEND commands

in report programs, 12-11

domain dimension

definition, A-20

DOMAINDIMREL property

how to set on the attribute dimension, A-21

double quotes, 10-3

escape sequence for, 4-3

DRILLINFOFRM property

how to set on a dimension, A-14

purpose of, A-14

ECHOPROMPT option, 8-24

ECMLOCATOR, A-2

how to define, A-2

properties required, A-3

embedded totals

EQ operator, 4-29, 4-30

equal sign (=).See = command

equal sign (=).See = continuation character

equations

cyclic dependence (in models), 7-10

error messages

routing to a file, 8-24

suppressing, 8-30

system, 8-31

error names, 8-31

ERRORNAME option, 8-29, 8-31

errors

controlling during calculations, 4-27

handling, 8-29

handling in nested programs, 8-33, 8-34

identifying, 8-31

names of, 8-31

signaling, 8-33, 8-34

when comparing numeric data, 4-32, 4-33

ERRORTEXT option, 8-29

escape sequences, 4-3

EXECUTE statement (SQL), 10-15

EXPOBJVAR property

how to set on the attribute dimension, A-23

expressions

EXTARGS command, 3-25

extension files, 2-3

FETCH statement (SQL), 10-7, 10-11

file names

file-ids

FILENEXT function, 11-19

FILEOPEN function, 11-4

FILEREAD command, 5-3

files

analytic workspace, 2-3

appending output, 8-24

debugging, 9-4

reading, 11-6

reading individual records, 11-19

reading structured PRN, 11-8

reading with FILENEXT function, 11-19

saving output in, 8-23, 8-24

size of, 2-3

FILEVIEW command, 11-19

financial analysis, scenario modeling, 7-15

floating point numbers

comparing, 4-33

floating-point format

limitations when calculating, 4-26

use of, 4-26

folder dimension

defined, A-9

how to define, A-9

properties required, A-10

folder membership valueset

how to define, A-23

FOR command

example of, 8-22

in report programs, 12-9

looping over dimension values, 8-21, 8-22

nested in reports, 12-10

form feed (escape sequence), 4-3

format attributes

for dimensioned data, 12-15

in ROW command, 12-12

formula

hierarchy drill information, how to define, A-14

hierarchy drill information, return values, A-14

number of hierarchies, purpose of, A-12

number-of-hierarchies, how to define, A-12

number-of-hierarchies, using, A-12

formulas in expressions, 4-6

FULLORDER property

how to set on a dimension, A-16

functions

user-defined, 8-4, 8-16, 8-17

using, 4-22

writing, 8-16

GE operator, 4-29, 4-30

GO command

example of, 9-8

introduced, 9-7

GT operator, 4-29, 4-30

HEADING command

in reports, 12-16

paging output from, 12-25

headings in reports, 12-16, 12-30

hierarchical dimensions

defined, 3-20

defining variables for, 3-21

drilling down, 6-19

example of, 3-21

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

rolling up data, 5-19

self-relations for, 3-21

hierarchy

drilling down, 6-19

hierarchy dimension

definition, A-11

how to define, A-11

hierarchy full order variable, A-15

hierarchy level dimension

how to define, A-16

purpose of, A-16

hierarchy parent relation

definition, A-14

how to define, A-15

HIERDEFAULT property

how to set on a dimension, A-13

purpose of, A-13

HIERDIM property

how to set on a dimension, A-11

purpose of, A-11

HIERLDSCVAR property

how to set on a dimension, A-13

purpose of, A-13

HIERLEVELVS property

how to set on a dimension, A-18

horizontal tab (escape sequence), 4-3

host variables (SQL)

input, 10-8

output, 10-12, 10-14

hyphen (-).See - continuation character

ID data type

defined, 4-3

IFNONE keyword

branching in programs, 8-23

implicit relations, 3-7

IMPORT command, 5-3

IN operator, 4-29, 4-30

INCLUDE command, 7-4, 7-6, 7-7

INDENT attribute (ROW), 12-12

INFO function

determining dimensionality with, 4-14

DIMENSION keyword, 4-15

with models, 7-14

inplace variables

advantages of, 3-12

defined, 3-12

disadvantages of, 3-12

when to use, 3-13

input host variables (SQL), 10-8

INSTAT function, 6-3, 6-27

INTEGER data type, 4-2

ISECMLOCATOR property

how to set on ECMLOCATOR, A-3

labels

in programs, 8-30

modifying in reports, 12-12

with IFNONE, 8-23

LAG function, 4-25, 7-12

LCOLWIDTH option, 12-11

LD command, 3-25

LDSCVAR property

how to set on an OLAP DML object, A-25

LE operator, 4-29, 4-30

LEAD function, 4-25, 7-12

LEFT attribute (ROW), 12-12

level depth variable, A-18

level long description variable, A-19

LEVELDEPTHVAR property

how to set on a dimension, A-19

LEVELDIM property

how to set on a dimension, A-17

LEVELLDSC property

how to set on a dimension, A-19

LEVELREL property

how to set on a dimension, A-17

level-to-hierarchy mapping valueset

purpose of, A-18

LIKE operator, 4-29, 4-30, 4-36

LIMIT command

linefeed (escape sequence), 4-3

LINENUM option, 12-26

LINESLEFT option, 12-26, 12-28

LISTBY program, 2-9

LISTNAMES program, 2-24

literals

date, 4-4

numeric, 4-2

text, 4-27

local variables, 8-8

logical operators, 4-29

long description variable, A-25

LSET attribute (ROW), 12-12

LSIZE option, 12-26, 12-30

LT operator, 4-29, 4-30

MAINTAIN command

adding values using, 5-5 to 5-7, 5-8

affect on dimension status, 5-4

deleting values using, 5-10, 5-11

denying permission to, 5-4

introduced, 5-3

merging values using, 5-5, 5-9

overview of, 5-3

repositioning values using, 5-11

when objects are updated, 5-4

with composites, 5-13

with conjoint dimensions, 5-13

MAKEDATE function, 4-6

MEASINFOLDERVS property

how to set on the folder dimension, A-24

measure dimension

definition, A-6

how to define, A-6

properties required, A-6

messages

warning, 8-32

metadata

analytic workspace, A-1

defined, A-1

locator object, A-2

purpose of, A-1

required for attributes, A-20

required for dimension hierarchies, A-10

required for hierarchy levels, A-16

requirements, A-2

minus sign (in numeric input), 4-25

MODEL command, 3-25, 7-6

MODEL.COMPRPT program, 7-14

MODEL.DEPRPT program, 7-14

models

base, 7-4

basic commands, 7-6

compiling, 7-3, 7-8

creating a nested hierarchy, 7-4

debugging, 7-13, 7-14

solution variables, 7-2

types of solution blocks, 7-9

MODEL.XEQRPT program, 7-14

MODTRACE option, 7-14

MONTH data type, 4-5

multidimensional data model, 3-11

multiple analytic workspaces, 2-12

NA pages

creating, 2-15, 2-16

releasing, 2-15

retrieving number of, 2-15

NA values, 3-15

comparing, 4-32

controlling how treated, 4-41

defined, 4-40

in aggregation functions, 4-42

in arithmetic operations, 4-43

in Boolean expression, 4-32

substituting another value for, 4-43

times when relevant, 4-40

NAFILL function, 4-41, 4-43

NAME dimension, 2-27

named composites

defined, 3-16

NASKIP option, 4-41, 4-42

NASKIP2 option, 4-41, 4-43

NASPELL option, 8-11

NE operator, 4-29, 4-30

NOPRINT keyword (TRAP), 8-30, 8-34

NOSPELL function, 4-4

NOT operator, 4-29, 4-30

number-of-hierarchies formula

how to define, A-12

how to use, A-12

numeric data

comparing, 4-32 to 4-33

numeric data types

automatic conversion of, 4-24

comparing, 4-32, 4-33

list of, 4-2

mixing, 4-24

numeric expressions

data type of the result, 4-23, 4-24, 4-25

dates in, 4-25

defined, 4-23

evaluating, 4-23

mixing data types in, 4-24

NA values in, 4-43

numeric literals, 4-25

NUMHIERFRM property

defining the number-of-hierarchies formula, A-12

how to set on the dimension dimension, A-12

OBJ function, 2-26, 2-27

objects

assigning values to, 4-10, 5-13

changing definition of, 3-24

definitions, 3-1

displaying definitions of, 2-25

in expressions, 4-6

list of, 3-3

maintaining, 5-4

retrieving information about, 2-26, 2-27

retrieving list of, 2-24, 2-26

updating, 5-4

OCI

special features of Oracle, 10-20

OKNULLSTATUS option, 6-24, 8-23

OLAP DML

using with composites, 4-8

OLAP DML debugger

accessing, 9-6

tracing nested programs, 9-8

using, 9-7

OPEN statement (SQL), 10-7, 10-10

operators

arithmetic, 4-23

Boolean, 4-29

comparison, 4-29

conditional, 4-37, 4-38

logical, 4-29

substitution, 4-39

options

paging, 8-24, 12-26

restoring previous values, 8-27

saving current values, 8-26

OR operator, 4-29, 4-30

Oracle data types, 10-18

OUTFILE command, 8-23, 8-24, 12-28

outfiles

creating, 8-24

paging options for, 8-24

output

host variables, 10-14

host variables (SQL), 10-12

saving in a file, 8-23, 8-24

OVER attribute (ROW), 12-12

PAGE command, 12-27

PAGENUM option, 12-26, 12-27, 12-29

PAGEPAUSE option, 12-29

PAGEPRG option, 12-26, 12-30, 12-31, 12-33

PAGEPROMPT option, 12-30

pages

breaks in reports, 12-27

headings in reports, 12-30

numbers in reports, 12-29

PAGESIZE option, 12-26

PAGING option, 12-25 to 12-27

PAREN attribute (ROW), 12-12

PARENS option, 12-11

parent model, defined, 7-4

PARENTREL property

how to set on a dimension, A-15

PARSE command, 4-14, 4-15

passwords

for analytic workspaces, 2-20

removing, 2-21

path names, specifying, 11-5

pattern matching, 4-36

PAUSE command, 12-29

permission programs, 2-12, 2-21, 5-4

permissions to maintain dimensions, 5-4

PERMIT command, 2-22, 3-25, 5-4

PERMIT_READ program, 2-21

PERMIT_WRITE program, 2-21

persistent sessions, 2-19

POP command, 8-27

POPLEVEL command

nesting, 8-28

using, 8-28

PREPARE statement (SQL), 10-15

PRGERR keyword (SIGNAL), 8-33

PRN files, reading, 11-8

PROGRAM command, 3-25

programs

analytic workspace permission, 2-12, 2-21, 5-4

arguments, 8-11

AUTOGO, 2-19

automatic running of, 2-19, 6-19

branching in, 8-23

branching labels, 8-20

comment lines in, 8-7

compilation of, 8-14

compiling, 8-35, 8-36

control structures, 8-19

DBDESCRIBE, 2-9

debugging, 9-1

debugging file for, 9-4

debugging, stepping through, 9-8

declaring arguments in, 8-11, 8-12

defined, 8-2

defining, 8-5

designing, 8-8, 8-19

displaying list of running, 9-8

errors in, 8-29

executing from other programs, 8-15

expressions used as arguments to, 8-15

finding logic errors in, 9-2

importing, 8-36

LISTBY, 2-9

LISTNAMES, 2-24

logging execution of, 9-4

logic errors in, 9-2

maintaining dimensions with, 11-9, 11-13, 11-14

modifying data with, 11-18

permission, 2-12, 2-21, 5-4

PERMIT_READ, 2-21

PERMIT_WRITE, 2-21

preserving environment, 8-25

reading coded dimension values, 11-15

restoring previous values, 8-27

running, 2-19, 8-37

sample, 8-17

saving compiled code, 8-36

saving current values, 8-26

scaling input data, 11-17

skipping invalid records, 11-10

STDHDR, 12-30

stepping through, 9-8

testing by running, 8-37

tracing, 9-6

tracing nested, 9-8

updating, 8-36

using continuation characters in, 8-7

variables in, 8-8, 8-9

watch points, 9-10, 9-11, 9-12

properties required by metadata

PROPERTY command, 3-25

PUSHLEVEL command

qualified data references

ampersand substitution, 4-20

creating, 4-16

defined, 4-16

in programs, 11-17

qualifying a relation, 4-19

replacing dimension of variable, 4-17, 4-19

using with = command, 4-20, 5-17

using with relation, 4-19

with dimensions, 4-16

with relations, 4-19

with variables, 4-17, 4-19

QUARTER data type, 4-5

quotation marks

escape sequences for, 4-3

SQL, 10-3

random sparsity, 3-15

range dimension

definition, A-20

RANGEDIMREL property

how to set on the attribute dimension, A-22

RAW DATE attribute

with data-reading commands, 11-19

with program, 11-13

records, reading, 11-19

relation

attribute domain, how to define, A-21

attribute domain, purpose of, A-21

attribute range, how to define, A-21

attribute range, purpose of, A-21

dimension member level, definition, A-17

hierarchy parent, defined, A-14

relational data, 10-1

See also SQL

DATE data type example, 10-32

fetching example, 10-29

updating tables example, 10-38

relational database example, 10-22

relations

REPORT command

paging output from, 12-25

with sparse data, 4-8

report programs

FOR loops in, 12-9

writing, 12-2 to 12-34

reports

RETURN command, 8-16

RIGHT attribute (ROW), 12-12

ROLLBACK statement (SQL), 10-5, 10-14

ROOTOFNEGATIVE option, 4-27

ROUND function, 4-32, 4-33

ROW command

column format, 12-6

format attributes, 12-12

generating blank lines, 12-5

global attributes, 12-8, 12-14

looping over dimensions, 12-9

paging output from, 12-25

reporting data, 12-4

reporting dimension values, 12-5

reporting literal text, 12-4

reporting multiple expressions, 12-5

reporting sparse data, 12-9

reporting values across row, 12-7

row format, 12-6

setting status, 12-8

skipping columns, 12-7

RSET attribute (ROW), 12-12

RUNTOTAL function, 12-20, 12-23

scenario model, defined, 7-15

scenarios for financial modeling, 7-15

SDSCVAR property

how to set on an OLAP DML object, A-24

SELECT statement (SQL), 10-4

sessions

preserving environment, 8-25

restoring environment, 8-27

sharing analytic workspaces across, 2-17

setting status. See dimension status

short description variable, A-24

SHORTDECIMAL data type, 4-33

SHORTINTEGER data type, 4-2

side headings in reports, 12-17

SIGNAL command, 8-31

simple blocks (in models), 7-9

simultaneous equations in models, 7-12

single quotes

escape sequence for, 4-3

SQL, 10-3

SKIP keyword (ROW), 12-7

solution variables

defined, 7-2

example of, 7-16

SPACE attribute (ROW), 12-12

sparse data, 3-15

controlled sparsity, 3-15

defined, 3-15, 4-40

eliminating, 3-16 to 3-18

in reports, 12-9

random sparsity, 3-15

setting dimension status, 6-21

SQL, 10-1

See also relational data

command summary, 10-4

data type equivalents, 10-20

precompiling code, 10-15

savepoints, 10-20

stored procedures, 10-20

transaction processing, 10-5

SQL command

SQLMESSAGES option, 10-4

STATFIRST function, 6-3, 6-27

STATLAST function, 6-3, 6-28

STDHDR program, 12-30

step blocks (in models), 7-9

storage

of dimensions, 3-5

of relations, 3-8

of variables, 3-13

stored procedures, 8-2

structured files, reading, 11-8

substitution expressions, 4-39

substitution operator, 4-39

introduced, 4-10

SUBTOTAL function, 12-20, 12-22

SYSINFO function, 2-22

tab (escape sequence), 4-3

temporary variables, 8-9, 11-25

text

comparing values, 4-36

comparing values to a pattern, 4-36

data types, 4-3

effects of character set, 4-36

passing arguments as, 8-13

TEXT data type, 4-3

text expressions

dates in, 4-28

defined, 4-27

text literals

comparing to relations, 4-37

time data types

described, 4-5

time dimensions

adding values to, 5-6, 5-7, 5-8

deleting values from, 5-10

limiting, 6-6

limiting using, 6-14

maintaining with programs, 11-13

relations between, 3-7

specifying values for, 4-5

time values

formatting in report headings, 12-18

limiting using, 6-6

titles for reports, 12-16, 12-30

TMARGIN option, 12-26

TOD function, 12-30

TODAY function, 12-30

totals in reports, 12-20

TRACE command, 7-14, 9-6

trace list, 9-7

transactions (SQL), 10-20

TRAP command, 8-29, 8-33, 8-34

UNDER attribute (ROW), 12-12

unnamed composites, 3-16, 3-18

user-defined functions, 8-16

arguments in, 8-17

calling, 8-4

data type of, 8-16

utilities, command line, 2-18

VALONLY attribute (ROW), 12-12

VALUE keyword

used in data-reading commands, 11-18

used in programs, 11-15

values

assigning to dimensions, 5-17

assigning to objects, 5-13

assigning to relations, 5-17

assigning to variables, 5-15

assigning to variables with composites, 5-15, 5-16

assigning, using a QDR, 5-17

in current status list, 6-28

in default status list, 6-28

NA, 3-15

restoring previous, 8-27

saving current, 8-26

VALUES function, 6-4, 6-28

valuesets

creating, 6-25

defined, 6-25

defining, 6-26

folder membership, definition of, A-23

folder membership, how to define, A-23

in expressions, 4-6

level-to-hierarchy mapping, definition of, A-18

level-to-hierarchy mapping, how to define, A-18

limiting using, 6-26

listing dimension positions in, 6-28

VARIABLE command, 8-9

variables

accessing, 4-8

assigning values to, 5-14, 5-15, 5-16, 5-17

attribute name, definition of, A-22

attribute name, how to define, A-22

changing storage type of, 3-25

controlling sparsity in, 3-16

defined, 3-11

defining, 3-14

defining in a program, 8-36

defining with composite, 3-16 to 3-18

defining with unnamed composite, 3-18

dimensioned, 3-11

example of, 3-14

hierarchy description, how to define, A-13

hierarchy full order, how to define, A-15

hierarchy full order, purpose of, A-15

holding, 12-25

how data is stored, 3-13

in expressions, 4-6

level depth, definition, A-18

level depth, how to define, A-18

level long description, definition of, A-19

level long description, how to define, A-19

limiting to single value, 4-17, 4-19

local, 8-8

long description, definition of, A-25

long description, how to define, A-25

NA values in, 3-15

persistence of, 8-8, 8-9

QDR with, 4-17, 4-19

replacing dimension of, 4-17, 4-19

rolling up, 5-19

short description, definition of, A-24

short description, how to define, A-24

sparse data in, 4-8

storage of, 3-13

temporary, 8-9

three-dimensional, 3-14

undimensioned, 3-11

with embedded totals, 3-21

with NA values, 3-16

with single-dimension composite, 3-19

VNF command, 4-5

described, 3-25

for formatting headings, 12-18

VNF format, 4-5, 5-7, 6-6, 11-13

WATCH command, 7-14

example of, 9-10, 9-11

WHERE clauses (SQL), 10-9

WIDTH attribute (ROW), 12-12

wildcards, 4-37

YEAR data type, 4-5

YESSPELL function, 4-4

zero

dividing by, 4-27

ZEROTOTAL command, 12-24

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