1. Index

Index

Symbols  Numerics  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

  • _ wildcard 1
  • ((amp)) operator 1
  • $AGGMAP property 1
  • $AGGREGATE_FORCECALC property 1
  • $AGGREGATE_FORCEORDER property 1
  • $AGGREGATE_FROM property 1, 2
  • $AGGREGATE_FROMVAR property 1
  • $ALLOCMAP property 1
  • $COUNTVAR property 1
  • $DEFAULT_LANGUAGE property 1
  • $GID_DEPTH property 1
  • $GID_LIST property 1
  • $GID_TYPE property 1
  • $LOOP_AGGMAP property 1
  • $LOOP_DENSE property 1
    • for derived measures in cubes 1
  • $LOOP_TYPE property 1
  • $LOOP_VAR property 1
    • for derived measures in cubes 1
  • $NATRIGGER property
    • calling recursively 1
    • executing simultaneously 1
  • $STORETRIGGERVAL property 1
  • $VARCACHE property
  • % wildcard 1
  • = command 1
    • event 1, 3
    • trigger 1, 3

Numerics

  • 20th century 1
  • 21st century 1

A

  • A.D. datetime format element 1
  • A.M. datetime format element 1
  • ABS function
  • abstract data types 1, 2
    • automatic 1, 2
    • predefining 1, 2
  • ACQUIRE command
  • ACROSS command
  • ADD_ALTER_SESSION procedure (PL/SQL) 1
  • ADD_CUBE_MODEL program 1
  • ADD_DIMENSION_MEMBER program 1
  • ADD_DIMENSION_SOURCE procedure (PL/SQL) 1
  • ADD_MODEL_DIMENSION program 1
  • ADD_MONTHS command
  • AD datetime format element 1
  • ADT
    • See abstract data types 1, 2
  • ADVISE_CUBE procedure (PL/SQL) 1
  • ADVISE_DIMENSIONALITY function (PL/SQL) 1
  • ADVISE_DIMENSIONALITY procedure (PL/SQL) 1
  • ADVISE_REL procedure 1
  • ADVISE_REL procedure (PL/SQL) 1
  • ADVISE_SPARSITY procedure (PL/SQL) 1
  • Aggcount variables 1, 2, 3, 4
  • AGGINDEX statement
  • AGGMAP ADD model command
  • AGGMAP command
  • AGGMAPINFO command
  • aggmap objects
    • identifying changes 1
  • AGGMAP REMOVE model command
  • aggmaps 1
    • See also: aggregation specifications, allocation specifications
    • compiling 1, 2
    • defining 1
    • deleting 1
    • in formulas 1
    • list of 1
    • removing models from in cube dimensions 1
  • AGGMAP SET command
  • Aggregate Advisor 1, 2, 4
  • AGGREGATE command
  • AGGREGATE function
  • aggregating data 1
    • See also: aggregation specifications
    • caching 1
    • formulas for 1
    • on-the-fly 1
    • partitioned variables 1
    • precomputing 1
    • specifying a relation for 1
    • using an Aggcount variable 1
    • using an aggmap object 1
    • using TCONVERT 1
  • aggregation
    • in analytic workspaces 1
  • AGGREGATION function
  • aggregations
    • identifying changes 1, 2, 3
  • aggregation specifications 1
    • See also: aggregating data
    • compiling 1
    • defining 1
    • deleting 1
    • models in 1, 2
    • writing 1
  • algorithm for composite values 1
  • alias dimensions
    • base dimensions (list of) 1
    • defining 1
    • deleting 1
    • limiting 1
    • maintaining 1
    • populating 1
    • retrieving list of 1
  • aliases
    • for analytic workspaces 1
    • for analytic workspaces. See analytic workspace aliases 1
    • for dimensions. See alias dimensions 1
  • ALLCOMPILE program
  • ALLOCATE command
  • allocating data 1
    • See also: allocation specifications
    • using an aggmap object 1
    • using TCONVERT 1
  • allocation specifications 1
    • See also: allocating data
    • defining 1
    • deleting 1
    • writing 1
  • ALLOCERRLOGFORMAT option 1
  • ALLOCERRLOGHEADER option
  • ALLOCMAP command
  • ALLSTAT command
  • AM datetime format element 1
  • ampersand (((amp))) operator 1
  • ampersand substitution
    • example of 1
    • program arguments and 1
    • QDR with 1, 2
    • using to pass arguments 1, 2
  • analytic workspace aliases
    • creating 1
    • definition of 1
    • deleting 1
  • analytic workspace objects
    • underlying cubes and cube dimensions 1
  • analytic workspaces
    • accessing from SQL 1
    • aggregation 1
    • aliases. See analytic workspace aliases 1
    • attached (list of) 1
    • attaching 1, 2
    • content summary, displaying 1
    • creating 1
    • current 1
    • deleting 1, 2
    • deleting objects from 1
    • detaching 1, 2
    • exporting 1
    • identifying active 1
    • importing 1
    • naming 1
    • obtaining information about 1
    • partitioning 1
    • segmenting 1
    • sharing 1
    • updating 1
  • ANTILOG10 function
  • ANTILOG function
  • ANY function
  • ARCCOS function
  • ARCSIN function
  • ARCTAN2 function 1
  • ARCTAN function 1
  • arc tangent calculation 1
  • ARG command
    • See: ARGUMENT command
  • ARGCOUNT function
  • ARGFR function
  • ARG function
  • ARGS function
  • ARGUMENT command
  • arguments 1
    • in user-defined functions 1
    • passing as text 1, 2
    • passing to a program 1, 2, 3, 4, 5
    • using ampersand substitution with 1
  • arithmetic
    • with DATE values 1
  • ASCII function 1
  • ASCIISTR function 1
  • Assign event 1
  • assignment statements
    • event 1, 3
    • trigger 1, 3
    • with different dimensionality 1
    • with QDR 1
  • authentication 1
    • encoding text expressions 1
    • within Oracle OLAP 1
  • AUTOGO program 1
  • AVERAGE function 1
  • AW_ATTACH procedure (PL/SQL) 1
  • AW_COPY procedure (PL/SQL) 1
  • AW_CREATE procedure (PL/SQL) 1
  • AW_DELETE procedure (PL/SQL) 1
  • AW_DETACH procedure (PL/SQL) 1
  • AW_RENAME procedure (PL/SQL) 1
  • AW_TABLESPACE function (PL/SQL) 1
  • AW_UPDATE procedure (PL/SQL) 1
  • AW command
    • AW ALIASLIST 1
    • AW ATTACH 1
    • AW CREATE 1
    • AW DELETE 1
    • AW DETACH 1
    • AW FREEZE 1
    • AW LIST 1
    • AW PURGE 1
    • AW ROLLBACK 1
    • AW SEGMENTSIZE 1
    • AW THAW 1
    • events 1
    • triggers 1
  • AWDESCRIBE program
  • AW function
  • AW PURGE 1
  • AWWAITTIME option 1

B

  • B.C. datetime format element 1
  • BACK function 1, 2, 3
  • BADLINE option 1, 2
  • base dimensions
    • finding values of 1, 2
    • identifying 1
    • setting status list of 1
  • BASEDIM function 1
  • BASEVAL function 1
  • BC datetime format element 1
  • BEGINDATE 1
  • BIN_TO_NUM function 1
  • binary data 1
  • BITAND function 1
  • bits, adding 1
  • BLANK command 1
  • blank lines in reports 1
  • BLANKSTRIP function 1
  • BMARGIN option 1
  • Boolean
    • data type 1
    • expressions 1
    • operators 1
    • values 1, 2
  • branching in programs 1, 2, 3, 4, 5, 6
  • BREAK command 1
  • bucket numbers, retrieving 1
  • build number of Oracle OLAP 1
  • bytes
    • used by expression 1
  • bytes strings 1

C

  • caches
    • See: OLAP session cache
  • CACHE statement 1
  • caching 1
  • calculated members
    • adding to dimension 1
    • identifying 1
  • calculating a linear regression 1
  • CALENDARWEEK option 1
  • CALL command 1
  • CALLTYPE function 1
  • case statement in programs 1
  • CATEGORIZE function 1
  • CDA command 1
  • CEIL function 1
  • CHANGEBYTES function 1
  • CHANGECHARS function 1
  • CHANGEDRELATIONS function 1
  • CHANGEDVALIES function 1
  • characters
    • converting 1
    • replacing 1
    • representing as decimals 1
    • representing as hexadecimals 1
    • representing as Unicode 1
    • special 1
  • character sets 1, 2
  • CHARLIST function 1
  • CHGDFN command 1
  • CHGDIMS function 1
  • CHILDLOCK statement 1
  • CHR function 1
  • CLEAN_ALTER_SESSION procedure (PL/SQL) 1
  • CLEANUP command
    • See: SQL command in OLAP DML
  • CLEAR command 1
  • CLOSE command
    • See: SQL command in OLAP DML
  • COALESCE function 1
  • code comments 1
  • columns
    • default width in reports 1, 2
    • getting value from a report column 1
    • headings in a report 1
    • in reports 1
    • multiline text 1
  • COLVAL function 1
  • COLWIDTH function 1
  • COMMAS option 1
  • comments
    • code 1
  • comments in programs 1
  • COMMIT command 1
  • comparing
    • dates 1
    • values 1, 2
  • comparison operators 1
  • compilable objects 1
  • COMPILE command 1
  • COMPILEMESSAGE option 1
  • COMPILEWARN option 1
  • compiling 1
    • aggmaps 1
    • aggregation specifications 1
    • models 1
    • programs 1
    • SQL statements 1
    • suppressing error messages 1
  • composites 1, 2
    • See also: unnamed composites
    • base dimension values 1
    • changing to conjoint dimensions 1
    • defining 1, 2
    • deleting 1
    • deleting values of 1
    • index algorithm 1
    • index type (determining) 1
    • listing associated objects 1
    • maintaining 1
    • reporting 1, 2
    • showing a value 1
    • specifying values for 1
    • specifying values of 1, 2
    • testing for a value 1
    • unnamed 1
  • composites (regular and compressed)
    • defined 1
  • concat dimensions 1
    • See also: dimensions
    • defining 1
    • deleting 1
    • specifying values for 1
  • conditional execution of commands 1
  • conditional expressions
    • Boolean 1
    • IF 1
    • SWITCH 1
  • conditional operators 1
  • conjoint dimensions 1
    • See also: dimensions
    • base dimension values 1
    • changing to composites 1
    • defining 1
    • deleting 1
    • index type (determining) 1
  • CONSIDER command 1
  • CONTEXT command 1, 2
  • CONTEXT function 1, 2
  • CONTINUE command 1
  • controlled sparsity 1
  • conversion
    • rules, string to date 1, 2
  • CONVERT function 1
  • converting
    • characters 1
    • hexidecimal digits to raw 1
    • numerics 1, 2
    • raw values 1
    • ROWID data type 1, 2
    • to ASCII 1
    • to DSINTERVAL 1
    • to YMINTERVAL 1
  • converting data types
    • decimals to integers 1
    • introduction to 1
  • CONVERT procedure (PL/SQL) 1
  • COPYDFN command 1
  • copying definitions 1
  • CORRELATION function 1
  • COS function 1
  • COSH function 1
  • cosine calculation 1, 2
  • COUNT function 1
  • CREATE_LOGICAL_MODEL program 1
  • cube dimension members
    • adding to a hierarchy 1
    • removing 1
    • removing from a hierarchy 1
  • cube dimensions
    • adding dimensions to models 1
    • adding models to 1
    • adding model to 1
    • creating models for 1
    • deleting model from 1
    • identifying physical characteristics of 1
    • removing dimensions from models 1
    • removing models fromaggmaps 1
  • cubes
    • identifying physical characteristics of 1
  • CUMSUM function 1
  • cumulative totals 1, 2
  • current
    • analytic workspace 1
  • CURRENT_DATE function 1
  • CURRENT_TIMESTAMP function 1
  • current directory 1
    • changing 1
    • identifying 1
  • current outfile 1, 2
  • current status list
    • setting 1
  • cursors 1
    • closing (SQL) 1
    • importing (SQL) 1
  • custom measures 1
    • examples with OLAP_EXPRESSION 1

D

  • data
    • binary 1
  • DATABASE command
    • See: AW command
    • name change 1
  • DATABASE function
    • See: AW function
    • name change 1
  • database initialization 1, 2
  • data export programs 1
  • data fetches (SQL) 1
  • data import programs 1
  • data type conversions 1
  • data types
    • Boolean 1
    • converting 1
    • creating a report 1, 2
    • date 1, 3
    • DATE 1
    • DATETIME 1
    • determining data type of an object 1
    • DSINTERVAL 1
    • for variables 1
    • numeric 1
    • of expressions 1
    • of numeric expressions 1
    • of user-defined function 1
    • qualifying data for expressions 1
    • RAW 1
    • restricting access 1
    • ROWID 1
    • showing a single value 1
    • text 1
    • TIMESTAMP 1
    • TIMESTAMP_LTZ 1
    • TIMESTAMP_TZ 1
    • transferring from one format to another 1
    • UROWID 1
    • YMINTERVAL 1
  • DATE_FORMAT 1
  • date data types 1, 3
  • DATE data types 1
  • date format models 1
    • long 1
    • punctuation in 1
    • short 1
    • text in 1
  • DATEFORMAT option 1
  • DATEORDER option 1
  • dates 1, 2
    • arithmetic 1
    • comparing 1
    • current 1, 2
    • in arithmetic expressions 1
    • in text expressions 1
  • datetime arithmetic 1
  • datetime data
    • format of 1
  • DATETIME data type 1
  • DATETIME data types 1
  • datetime expressions 1
  • datetime format elements
    • and Globalization Support 1
    • capitalization 1
    • ISO standard 1
    • RR 1
    • suffixes 1
  • datetime values
    • truncating 1
  • DAYABBRLEN option 1
  • DAY datetime format element 1
  • DAYNAMES option 1
  • DAYOF function 1
  • DBDESCRIBE program
    • See: AWDESCRIBE program
    • name change 1
  • DBGOUTFILE command 1, 2
    • and ECHOPROMPT 1
  • DBMS_AW package
  • DBMS_AW PL/SQL package
    • ADD_DIMENSION_SOURCE procedure 1
    • ADVISE_CUBE procedure 1
    • ADVISE_DIMENSIONALITY function 1
    • ADVISE_DIMENSIONALITY procedure 1
    • ADVISE_REL procedure 1
    • ADVISE_SPARSITY procedure 1
    • AW_ATTACH procedure 1
    • AW_COPY procedure 1
    • AW_CREATE procedure 1
    • AW_DELETE procedure 1
    • AW_DETACH procedure 1
    • AW_RENAME procedure 1
    • AW_TABLESPACE function 1
    • AW_UPDATE procedure 1
    • CONVERT procedure 1
    • EVAL_NUMBER function 1
    • EVAL_TEXT function 1
    • EXECUTE procedure 1
    • GETLOG function 1
    • INFILE procedure 1
    • INTERP_SILENT function 1
    • INTERPCLOB function 1
    • INTERP function 1
    • OLAP_ON function 1, 2
    • PRINTLOG procedure 1
    • RUN procedure 1
    • SHUTDOWN procedure 1
    • SPARSITY_ADVICE_TABLE procedure 1
    • STARTUP procedure 1
  • DBTIMEZONE function 1
  • DBWAITTIME option
    • See: AWWAITTIME option
    • name change 1
  • DDOF function 1
  • DEADLOCK statement 1
  • debugging 1
    • formulas 1
    • models 1, 2
    • programs 1, 2
  • DECIMALCHAR option 1
  • decimal data types, comparing 1
  • decimal marker (displayed) 1
  • DECIMALOVERFLOW option 1
  • decimal places (displayed) 1
  • DECIMALS option 1
  • decimal values 1
    • decimal marker for output 1
    • truncating to an integer 1
  • DECLARE CURSOR command
    • See: SQL command in OLAP DML
  • DECODE function 1
  • default
    • outfile 1
    • relations 1, 2
  • DEFAULTAWSEGSIZE option 1
  • DEFAULTDBFSIZE option
    • See: DEFAULTAWSEGSIZE option
    • name change 1
  • default status list
    • determining if in effect 1
  • DEFINE AGGMAP command 1
  • DEFINE command 1
    • events 1
    • triggers 1
  • DEFINE COMPOSITE command 1
  • DEFINE DIMENSION ALIASOF command
  • DEFINE DIMENSION command 1
  • DEFINE FORMULA command 1
  • DEFINE MODEL command 1
  • DEFINE PARTITION TEMPLATE command 1
  • DEFINE PROGRAM command 1
  • DEFINE RELATION command 1
  • DEFINE SURROGATE command 1
  • DEFINE VALUESET command 1
  • DEFINE VARIABLE command 1
  • DEFINE WORKSHEET command 1
  • defining
    • aggmap objects 1
    • alias dimensions 1
    • analytic workspace objects 1
    • dimension alias 1
    • dimensions 1
    • formulas 1
    • partitions 1
    • programs 1
    • relations 1
    • surrogates 1
    • valuesets 1
    • variables 1
    • worksheet objects 1
  • definitions
    • copying 1
    • creating 1
    • creating object properties 1
    • deleting 1
    • moving within NAME dimension 1
    • report of 1, 2
    • testing for 1
  • DELETE_ALTER_SESSION procedure (PL/SQL) 1
  • DELETE command 1
    • event 1
    • trigger 1
  • Delete event 1
  • deleting
    • alias dimensions 1
    • composites 1
    • composite values 1
    • definitions 1
    • dimension alias 1
    • dimensions 1
    • dimension values 1, 2
    • formulas 1
    • models 1
    • objects 1
    • partitions 1
    • partition templates 1
    • programs 1
    • surrogates 1
    • triggers 1
    • valuesets 1
  • DEPRDECL function 1
  • DEPRDECLSW function 1
  • depreciation of assets 1, 2, 3, 4
  • DEPRSL function 1
  • DEPRSOYD function 1
  • DESCRIBE command 1
  • descriptions
    • adding to a definition 1
    • deleting from a definition 1
  • detaching
    • analytic workspaces 1
  • dimension alias
    • See alias dimensions 1
  • dimensionality, changing 1
  • dimension-based equations 1
  • DIMENSION command, in a model 1
  • dimensions 1
    • See also: alias dimensions, base dimensions, concat dimensions, conjoint dimensions, simple dimensions
    • adding to cube dimension models 1
    • checking status of 1
    • comparing values 1
    • defining 1
    • defining surrogates for 1
    • deleting 1
    • determining status of 1
    • limiting 1
    • limiting to single value 1
    • listing associated objects 1
    • looping over values of 1
    • maintaining 1
    • numeric value of text dimension 1
    • of expression 1, 2
    • order in models 1
    • QDR with 1, 2
    • related 1, 2
    • removing from cube dimension models 1
    • restoring previous values 1
    • saving current values 1
    • status lists 1, 2
    • type of (determining) 1
    • worksheet 1
  • DIMENSION statement
    • for aggregation 1
    • for allocation 1
  • dimension status
    • effect on expressions 1
    • null 1
    • restoring 1
    • saving current 1
  • dimension surrogates
    • assigning values to 1
    • defining 1
  • dimension values
    • comparing 1
    • counting related values 1
    • deleting values of 1, 2
    • latest value 1
    • null 1
    • number of (determining) 1
    • number of values in status 1
    • place in status list 1
    • retrieving current status list
      • retrieving 1
    • returning first value in status 1
    • returning last value in status 1
    • setting the status of 1
    • sorting 1, 2
    • testing for 1
    • using qualified data reference 1
    • using result of LIMIT command 1
  • directory
    • changing 1
    • identifying current 1
  • displaying error messages 1
  • DIVIDEBYZERO option 1
  • division 1
    • by zero 1
    • calculating the remainder 1
  • DO command 1, 2
    • used with FOR 1
    • used with SWITCH 1
    • used with WHILE 1
  • DOEND command 1
  • double quotes 1
  • DSECONDS option 1
  • DSINTERVAL data type 1
  • DSINTERVAL function 1
  • DY datetime format element 1

E

  • ECHOPROMPT option 1, 2
  • EDIT command 1
  • editing previously executed commands 1
  • EIFBYTES option 1
  • EIFEXTENSIONPATH option 1
  • EIF file 1, 2
    • exporting data from 1
    • importing data from 1
  • EIFNAMES option 1
  • EIFSHORTNAMES option 1
  • EIFTYPES option 1
  • EIFUPDBYTES option 1
  • EIFVERSION option 1
  • embedded-total dimension views 1
  • embedded-total fact view 1
  • encoding 1
  • ENDDATE function 1
  • ENDOF function 1
  • EQ command 1
  • equations, dimension-based 1
  • ERRNAMES option 1
  • ERRORLOG statement 1
  • ERRORMASK statement 1
  • error messages 1
    • creating your own 1
    • deferring 1
    • displaying 1
    • option holding text of 1
    • producing without error condition 1
    • signaling error condition 1
    • suppressing 1, 2
    • suppressing during compilation 1
    • wrapping 1
  • ERRORNAME option 1, 2
  • errors
    • controlling during calculations 1
    • handling 1
    • handling in nested programs 1
    • handling in programs 1
    • name of first-occurring error 1
    • signaling 1, 2
    • SQL error codes 1
    • when comparing numeric data 1, 2, 3
  • ERRORTEXT option 1, 2
  • ESCAPEBASE option 1
  • escape character for LIKE 1
  • escape sequences 1
  • EVAL_NUMBER function (PL/SQL) 1
  • EVAL_TEXT function (PL/SQL) 1
  • events
    • Assign 1, 2
    • assignment statements 1
    • Define 1
    • Delete 1
    • deleting 1
    • identifying 1
    • Maintain 1
    • Property 1
    • Update 1, 2, 3
  • EVERSION function 1
  • EVERY function 1
  • EXECUTE procedure (PL/SQL) 1
  • EXISTS function 1
  • EXP function 1
  • exponential forecasting 1
  • exponents, retrieving 1
  • EXPORT command 1, 2
  • exporting
    • metadata 1
  • exporting data 1, 3
  • EXPORT to EIF command 1
  • EXPORT to spreadsheet command 1
  • expressions
    • ampersand substitution 1
    • Boolean 1, 2
    • changing dimensionality of 1
    • comparing 1
    • conditional 1
    • data type of 1
    • dates in 1
    • datetime 1
    • defined 1
    • determining dimensions of 1
    • dimensions of 1, 2
    • dimensions status 1
    • empty cells 1
    • internal representation of 1
    • interval 1
    • NA values in 1
    • numeric 1
    • objects in 1
    • padding 1, 2
    • parsing 1
    • retrieving largest 1
    • retrieving smallest 1
    • saving 1
    • size in bytes 1
    • substitution 1
    • text 1
    • trimming 1, 2
    • using objects in 1
    • using qualified data references in 1
  • EXPTRACE option 1
  • EXTBYTES function 1
  • EXTCHARS function 1
  • EXTCOLS function 1
  • EXTLINES function 1
  • EXTRACT function 1

F

  • fastest-varying dimension 1
  • FCCLOSE command 1
  • FCEXEC command 1
  • FCOPEN command 1
  • FCQUERY command 1
  • FCSET command 1
  • FETCH command
    • See: SQL command in OLAP DML
  • FETCH command (OLAP DML) 1
  • fetching data (SQL) 1
  • FILECLOSE command 1
  • FILECOPY command 1
  • FILEDELETE command 1
  • FILEERROR function 1
  • FILEGET function 1
  • file I/O 1, 2, 3, 4, 5, 6, 7
    • closing 1, 2
    • current directory 1
    • diagnosing errors when processing 1
    • forcing a page break 1
    • gathering information about 1
    • list of open files 1
    • opening 1
    • processing data from 1
    • reading a record 1
    • reading data from 1
    • reading Oracle OLAP commands from a file 1, 2
    • records read 1
    • setting attributes 1
    • writing 1
  • FILEMOVE command 1
  • FILENEXT function 1
  • FILEOPEN function 1
  • FILEPAGE command 1
  • FILEPUT command 1
  • FILEQUERY function 1
  • FILEREAD command 1
  • files
    • appending output 1
    • importing data from 1
    • saving output in 1
  • FILESET command 1
  • fileunits 1, 2
    • attributes 1
    • number of outfile destination 1
    • opening 1, 2
    • reading data from 1
    • setting attributes 1
  • FILEVIEW command 1
  • FILTERLINES function 1
  • financial analysis, scenario modeling 1
  • FINDBYTES function 1
  • FINDCHARS function 1
  • FINDLINES function 1
  • FINTSCHED function 1
  • floating-point format
    • limitations when calculating 1
    • use of 1
  • floating point numbers, comparing 1
  • FLOOR function 1
  • FOR command 1, 2
    • breaking out of 1
    • example of 1
    • looping over dimension values 1
    • used with BREAK 1
    • used with CONTINUE 1
    • used with OKFORLIMIT 1
    • used with TEMPSTAT 1
  • FORECAST.REPORT program 1, 2
  • FORECAST command 1
  • FORECAST function 1
  • forecasting context 1
    • closing 1
    • executing 1
    • opening 1
    • querying 1
    • setting characteristics of 1
  • format model 1
  • format models 1
    • date
      • changing 1, 2
      • default format 1, 2
  • formats
    • for dates and numbers. See format models 1
    • of return values from the database 1
    • of values stored in the database 1
  • formatting
    • datetime data 1
  • formulas
    • aggmap objects in 1
    • aggregating data with 1
    • compiling 1, 2
    • debugging 1
    • defining 1
    • deleting 1
    • expression for (retrieving) 1
    • recursive 1
    • specifying new expression 1
  • FPMTSCHED function 1
  • FROM_TZ function 1
  • FULLDSC program 1
  • functions
    • calling 1
    • user-defined 1, 3, 4

G

  • GET function 1
  • GETLOG function (PL/SQL) 1
  • GOTO command 1
  • GREATEST function 1
  • GROUPINGID command 1
  • GROUPINGID function 1
  • grouping ids 1, 2, 3
  • group marker 1
  • GROWRATE function 1
  • growth rate 1

H

  • handling errors in programs 1
  • hash partitions 1
  • hash values 1
  • heading 1
    • for a report 1
    • for output pages 1
    • including a page number 1
    • producing standard report heading 1
  • HEADING command
  • hexadecimal digits
    • converting to raw 1
  • HEXTORAW function 1
  • HIDE command 1
  • hierarchies
    • shape of 1
  • hierarchy shape 1
  • HIERHEIGHT command 1
  • HIERHEIGHT function 1
  • HIERSHAPE function 1
  • Holt-Winters forecasting 1
  • hyperbolic
    • cosine calculation 1
    • sine calculation 1
    • tangent calculation 1

I

  • IDs
    • character sets 1, 2
  • IF command 1, 2
  • IF conditional expression 1
  • IMPORT command 1, 2
    • See also: SQL command in OLAP DML
  • importing
    • metadata 1
  • importing data 1, 2
    • controlling update frequency 1
    • from an analytic workspace 1
    • from spreadsheets 1
    • from text files 1
    • tracking names of objects 1
    • tracking types of objects 1
  • INCLUDE command 1
  • INF_STOP_ON_ERROR option
  • INFILE command 1
  • INFILE procedure (PL/SQL) 1
  • infinity
    • numbers 1, 2
  • INFO function
    • FORECAST 1
    • MODEL 1
    • PARSE 1
    • REGRESS 1
  • INF values
    • in OLAP DML 1
  • INITCAP function 1
  • initialization parameters 1, 2
  • INLIST function 1
  • input file
    • reading from a file 1, 2
    • with SNAPI connection 1
    • with XCA dialog 1
  • INSBYTES function 1
  • INSCHARS function 1
  • INSCOLS function 1
  • INSLINES function 1
  • INSTAT function 1
  • INSTRB function 1
  • INSTRC function 1
  • INSTR function 1
  • integer part of decimal number 1
  • interest on loans 1, 2
  • internal rate of return 1
  • INTERP_SILENT procedure (PL/SQL) 1
  • INTERPCLOB function (PL/SQL) 1
  • INTERP function (PL/SQL) 1
  • interval
    • arithmetic 1
  • INTERVAL expressions 1
  • INTPART function 1
  • IRR function 1
  • ISDATE program 1
  • ISEMPTY function 1
  • ISINFINITE 1
  • ISNAN 1
  • ISSESSION function 1
  • ISVALUE function 1

J

  • JOINBYTES function 1
  • JOINCHARS function 1
  • JOINCOLS function 1
  • JOINLINES function 1

K

  • KEY function 1

L

  • label column width 1
    • branching in a program 1
    • for error handling in programs 1
  • labels 1
    • in programs 1
    • with IFNONE 1
  • LAGABSPCT function 1
  • LAGDIF function 1
  • LAG function 1, 2
  • LAGPCT function 1
  • larger value of two expressions 1
  • LARGEST function 1
  • largest value of an expression 1
  • LAST_DAY function 1
  • LCOLWIDTH option 1
  • LD command 1
  • LEAD function 1, 2
  • LEAST function 1
  • LENGTH2 function 1
  • LENGTH4 function 1
  • LENGTHB function 1
  • LENGTHC function 1
  • LENGTH function 1
  • LIKECASE option 1
  • LIKEESCAPE option 1
  • LIKENL option 1
  • LIKE operator 1, 2
  • LIMIT.SORTREL option 1
  • LIMIT BASEDIMS command 1
  • LIMIT command 1
    • using LEVELREL 1
    • using NOCONVERT 1
    • using parent relation 1
    • using POSLIST 1
    • using related dimension 1
    • using values 1
  • LIMIT function 1
  • limiting
    • alias dimensions 1
    • dimensions 1
    • multidimensional valuesets 1
  • LIMITMAPINFO function 1
  • limit maps 1, 2
    • order of processing 1
    • syntax 1
  • LIMITSTRICT option 1, 2
  • LINENUM option 1
  • line size for report heading 1
  • LINESLEFT option 1
  • lines on a page of report output 1
  • LISTBY program 1
  • LISTFILES command 1
  • LISTNAMES program 1
  • literals
    • numeric 1
    • text 1
  • LOAD command 1
  • loans 1
    • interest payment on 1
    • interest payments on 1
    • payment on 1
    • payments on 1
  • locale independent 1
  • LOCALTIMESTAMP function 1
  • local variables 1
  • LOG10 function 1
  • LOG command 1
  • LOG function 1
  • logical operators 1
  • logs
    • calculating base 10 logarithm 1
    • calculating natural logarithm 1
  • LOOP clause in SQL FETCH 1
  • looping 1
    • over dimension status 1
  • looping, explicit 1, 2, 3, 4
  • LOWCASE function 1
  • lowercase, converting to 1
  • LOWER function 1
  • LPAD function 1
  • LSIZE option 1
  • LTRIM function 1

M

  • MAINTAIN command
    • event 1
    • MAINTAIN ADD 1
    • MAINTAIN ADD for DAY, WEEK, MONTH, QUARTER and YEAR values 1
    • MAINTAIN ADD for TEXT, ID, and INTEGER values 1
    • MAINTAIN ADD SESSION 1
    • MAINTAIN DELETE 1, 2, 3
    • MAINTAIN MERGE 1
    • MAINTAIN MOVE 1
    • MAINTAIN RENAME 1
    • trigger 1
  • Maintain event 1
  • maintaining
    • alias dimensions 1
    • composites 1
    • dimensions 1
    • partitions 1
    • partition templates 1
  • MAKEDATE function 1
  • margins 1
    • setting bottom margin 1
    • setting top margin 1
  • MAXBYTES function 1
  • MAXCHARS function 1
  • MAXFETCH option
  • MAX function 1
  • maximum values 1
    • for each time period in the status 1
    • larger of two expressions 1
  • MEASUREDIM statement
    • for aggregation 1
    • for allocation 1
  • MEDIAN function 1
  • median value 1
  • messages, suppressing 1
  • metadata
    • exporting 1
    • importing 1
  • MIN function 1
  • minimum value 1
    • for each time period in the status 1
    • smaller of two expressions 1
  • MMOF function 1
  • MODDAMP option 1
  • MODE function 1
  • MODEL.XEQRPT program
    • compiling 1
    • defining 1, 2
    • including 1
    • nesting 1
    • options 1, 2, 3, 4, 5, 6, 7
  • MODEL command 1
  • model dimensions
    • adding to cube dimensions 1
    • removing from cube dimensions 1
  • models
    • adding a specification 1
    • adding to aggmap 1
    • adding to cube dimensions 1
    • adding to cubes 1
    • compiling 1, 2, 3
    • creating 1
    • creating for cube dimensions 1
    • debugging 1, 2
    • defining 1
    • deleting 1
    • deleting from cube dimensions 1
    • editing 1
    • in aggregation specifications 1, 2
    • obtaining information about 1
    • removing from aggmap 1
    • removing from aggmaps of cube dimensions 1
    • running 1, 2
    • scenario 1
    • solution variables 1
  • MODERROR option 1
  • MOD function 1
  • MODGAMMA option 1
  • MODINPUTORDER option 1
  • MODMAXITERS option 1
  • MODOVERFLOW option 1
  • MODSIMULTYPE option 1
  • MODTOLERANCE option 1
  • MODTRACE option 1
  • module version numbers 1
  • MODULO function 1
  • MON datetime format element 1
  • MONITOR command 1
  • monitoring 1
    • cost of program lines 1
    • cost of programs 1
  • MONTHABBRLEN option 1
  • MONTH datetime format element 1
  • MONTHNAMES option 1
  • MONTHS_BETWEEN function 1
  • MOVE command 1
  • MOVINGAVERAGE function 1
  • MOVINGMAX function 1
  • MOVINGMIN function 1
  • MOVINGTOTAL function 1
  • multidimensional valuesets 1
  • multiline text
    • columns 1
  • MULTIPATHHIER option 1
  • multiwriter mode 1, 2, 3

N

  • NA2 bits 1, 2
  • NA2 function 1
  • NA2 values 1, 2
  • NAFILL function 1
  • NAFLAG function 1
  • name 1
    • changing object name 1
    • dimension 1
    • listing names of dictionary entries 1
  • NAME dimension
  • names
    • listing for objects 1
    • listing objects by 1
    • qualified object 1
  • NaN values
    • in OLAP DML 1
  • NASKIP2 option 1
  • NASKIP option 1
  • NASPELL option 1, 2
  • NATRIGGER
    • See: $NATRIGGER
  • natural logarithm 1
  • NA values
    • about 1
    • accepted as numeric input 1, 2
    • caching 1
    • comparing 1
    • controlling how treated 1
    • in Boolean expression 1
    • in expressions 1
    • NA2 bits 1, 2
    • permanently replacing 1
    • replacing 1
    • replacing with strings 1
    • retrieving 1
    • spelling of 1
    • substituting another value 1
    • triggers 1, 2
  • negative value 1
    • in output 1
    • obtaining the root 1
  • net present value 1
  • NEW_TIME function 1
  • NEXT_DAY function 1
  • NLS_CALENDAR option 1
  • NLS_CHARSET_ID function 1
  • NLS_CHARSET_NAME function 1
  • NLS_CURRENCY option 1
  • NLS_DATE_FORMAT option 1
  • NLS_DATE_LANGAUGE option 1
  • NLS_DATE_LANGUAGE initialization parameter 1
  • NLS_DUAL_CURRENCY option 1
  • NLS_ISO_CURRENCY option 1
  • NLS_LANG option 1
  • NLS_LANGUAGE initialization parameter 1
  • NLS_LANGUAGE option 1
  • NLS_NUMERIC_CHARACTERS option 1
  • NLS_SORT option 1
  • NLS_TERRITORY initialization parameter 1
  • NLS_TERRITORY option 1
  • NLSSORT function 1
  • NONE function 1
  • NORMAL function 1
  • NOSPELL option 1
  • NPV function 1
  • NULLIF function 1
  • null values
    • See: NA values
  • numbers
    • assigning random numbers 1
    • commas in output 1
    • decimal marker for output 1
    • decimal places in output 1
    • determining sign of 1
    • negative values in output 1
    • rounding 1
    • spelling out 1
    • thousands marker for output 1
  • NUMBYTES function 1
  • NUMCHARS function 1
  • numeric conversion 1, 2
  • numeric data types 1
    • comparing 1, 2
    • mixing 1
  • numeric expressions
    • data type of the result 1
    • dates in 1
    • mixing data types 1
    • text dimensions in 1
  • numeric values
    • rounding 1
  • NUMLINES function 1
  • NUMTODSINTERVAL function 1
  • NUMTOYMNTERVAL function 1
  • NVL2 function 1
  • NVL function 1

O

  • object definitions
    • adding descriptions to 1
    • deleting descriptions from 1
  • objects 1
    • checking for changes 1
    • compiling 1
    • creating by copying 1
    • creating properties 1
    • data type of (determining) 1
    • defining 1
    • definition (retrieving) 1
    • deleting 1
    • describing its definition 1
    • describing its properties 1
    • dimensions of (retrieving) 1
    • dropping changes 1
    • exporting from analytic workspace 1
    • identifying triggers 1
    • importing into analytic workspace 1
    • in expressions 1
    • listing 1
    • listing names of 1, 2
    • loading 1
    • making current 1
    • obtaining information 1
    • pages used to store (determining) 1
    • qualified name 1
    • recalculating permissions 1
    • renaming 1
    • restrictions on name 1
    • storage class (determining) 1
    • testing for existence 1
  • object types
    • automatic 1, 2
    • predefining 1, 2
    • syntax for creating 1, 2
  • OBJ function 1
  • OBJLIST function 1
  • OBJORG function 1
  • OBSCURE function 1
  • OESEIFVERSION option
    • See: EIFVERSION option
    • name change 1
  • OKFORLIMIT option 1
  • OKNULLSTATUS option 1, 2
  • OLAP_API_SESSION_INIT PL/SQL package
    • ADD_ALTER_SESSION procedure 1
    • CLEAN_ALTER_SESSION procedure 1
    • DELETE_ALTER_SESSION procedure 1
  • OLAP_CONDITION function (SQL) 1
  • OLAP_EXPRESSION_BOOL function (SQL) 1
  • OLAP_EXPRESSION_DATE function (SQL)
  • OLAP_EXPRESSION_TEXT function (SQL)
  • OLAP_EXPRESSION function (SQL) 1
  • OLAP_ON function (PL/SQL) 1, 2
  • OLAP_TABLE
    • optimizing looping 1, 2, 3, 4
  • OLAP_TABLE function (SQL)
    • custom measures 1, 2, 3, 4
    • data map parameter 1
    • data type conversions 1
    • examples 1
    • FETCH command 1
    • limit map 1, 2
    • retrieving session log 1
    • specifying an OLAP DML command 1
    • specifying a ROW2CELL column 1
    • specifying the analytic workspace 1
    • specifying the logical table 1
  • OLAP API
    • optimization 1
  • OLAP DML
    • executing in SQL 1, 2, 3, 4, 5
    • quotation marks in 1
  • OLAP session cache
    • blocking creation of 1
    • checking if empty 1
    • defined 1
    • for variable 1
    • non-NA values 1
    • populating with aggregated values 1, 2
    • populating with NA values 1
  • ONATTACH program 1
  • ONDETACH program 1
  • OPEN command See SQL command in OLAP DML 1
  • operating system, identifying 1
  • operators 1
    • Boolean 1
    • comparisons 1
    • conditional 1
    • LIKE 1, 2, 3
    • logical 1
    • overview 1
    • substitution 1
  • optimization
    • OLAP API 1, 2
  • options
    • displaying value of 1
    • restoring previous values 1
    • retrieving 1
    • saving current values 1
    • specifying 1
  • ORA_HASH function 1
  • Oracle OLAP
    • internal build number 1
  • ordinal numbers
    • specifying 1
    • spelling out 1
  • outfile
    • current 1
  • OUTFILE command 1
    • affect on DBMS_AW.EXECUTE 1
    • affect on DBMS_AW.RUN 1
  • OUTFILEUNIT option 1
  • out-of-range decimal values 1
  • output 1
    • redirecting 1
    • saving in a file 1
  • overflow condition 1

P

  • P.M. datetime format element 1
  • padding expressions 1, 2
  • PAGE command 1
  • PAGENUM option 1
  • PAGEPRG option 1
  • PAGESIZE 1
  • paging in reports 1
    • forcing a page break 1
    • line number on current page 1
    • lines for bottom margin 1
    • lines for top margin 1
    • lines left on page 1
    • lines on a page 1
    • page number 1
    • producing a custom heading 1
    • producing a standard heading 1
    • turning on 1
  • PAGING option 1
  • PARENS option 1
  • PARSE command 1, 2
  • parsing expressions 1
  • PARTITIONCHECK function
  • partitioned variables 1, 2
    • aggregating 1
    • defining 1
    • deleting data from 1
    • maintaining 1
    • retrieving dimensions of 1
    • retrieving partitioning method 1
  • PARTITION function 1
  • partitioning methods 1
  • partitions 1, 2
    • adding values to 1, 2
    • defining 1
      • list partitions 1
    • deleting 1
    • deleting data 1
    • identifying for value 1
    • list 1
    • locking segments of 1
    • moving values 1
    • range 1, 2
    • retrieving dimensions of 1
    • retrieving names of 1
    • specifying values of 1
  • partition templates 1
    • defining 1
    • deleting 1
    • maintaining 1
    • retrieving partitioning method 1
    • retrieving partition names 1
  • pattern matching 1
  • payment schedules 1
    • for loan interest 1, 2
    • for loans 1, 2
  • PERCENTAGE function 1
  • permission programs 1, 2, 3, 4, 5
  • permissions 1
    • assigning to an object definition 1
    • recalculating permission 1
    • specifying conditions for accessing 1
    • violations of 1
  • PERMIT_READ program 1, 2
  • PERMIT_WRITE program 1, 2
  • PERMIT command 1
  • PERMITERROR option 1
  • PERMITREADERROR option 1
  • PERMITRESET command 1
  • phonetic representation, of text expression 1
  • platform, determining 1
  • PM datetime format element 1
  • POP command 1, 2, 3, 4
    • popping a whole series at once 1
  • POPLEVEL command 1
    • nesting 1
    • using 1
  • populating
    • alias dimensions 1
  • PRECOMPUTE statement 1
  • PREPARE command
    • See: SQL command in OLAP DML
  • PRGTRACE option 1
  • print buffer 1, 2
  • PRINTLOG procedure (PL/SQL) 1
  • PROCEDURE statement
    • See: SQL command in OLAP DML
  • profiles 1
  • PROGRAM command 1
  • programs
    • adding program contents to a definition 1
    • branching 1, 2, 3
    • branching in 1
    • branching labels 1
    • calling 1
    • case statement 1
    • comment lines in 1
    • compiling 1, 2, 4
    • conditional execution of commands 1, 2
    • data export 1
    • data import 1
    • debugging 1, 2, 3
    • declaring arguments in 1
    • defining 1
    • deleting 1
    • determining how invoked 1
    • error handling 1, 2, 3
    • errors in 1
    • executing 1
    • halting execution with an error 1
    • hiding 1
    • local variable 1
    • OnAttach 1, 2
    • passing arguments to 1, 2, 3, 4
    • performance cost 1
    • permission 1, 3, 5, 7, 9
    • preserving environment 1
    • preserving status 1, 2
    • repeating commands 1
    • restoring previous values 1
    • restoring status 1, 2
    • returning a value 1
    • saving compiled code 1
    • saving current values 1
    • saving status 1, 2
    • startup 1
    • suspending execution 1
    • terminating execution of 1
    • timing execution 1, 2
    • trigger 1, 2, 3, 5, 7, 9
    • unhiding 1
  • properties 1
    • copying with an object definition 1
    • creating for objects 1
    • listing for objects 1
  • PROPERTY command 1
    • event 1
    • trigger 1
  • Property event 1
  • PUSH command 1, 2, 3
    • marking start of series 1
    • placement 1
    • using 1
  • PUSHLEVEL command 1
    • nesting 1
    • placement 1

Q

  • QUAL function 1, 2
  • qualified data references
    • ampersand substitution 1, 2
    • creating 1
    • definition of 1
    • for dimensions 1
    • qualifying a relation 1
    • replacing dimension of variable 1, 2
    • specifying explicitly 1
    • using with relation 1
    • with assignment statement 1
    • with dimensions 1
    • with relations 1
    • with variables 1, 3
  • qualified object name 1
  • quotation marks
    • double 1
    • in OLAP DML 1

R

  • RANDOM.SEED.1 option 1
  • RANDOM.SEED.2 option 1
  • RANDOM function 1
  • random numbers 1, 2, 3
  • random sparsity 1
  • range partitions
    • defining 1
    • retrieving calculation for 1
  • RANK_CALLS option 1
  • RANK_CELLS option 1
  • RANK_SORTS option 1
  • RANK function 1
    • number of calls to 1
    • number of computed values 1
    • number of triggered sorts 1
  • ranking performance monitoring 1
  • RAW data type 1
  • raw values
    • converting 1
  • reading files 1
    • current record number 1
    • error diagnosis 1
    • FILEREAD command 1
    • processing a record 1
    • reading a record 1
  • RECAP command 1
  • RECNO function 1
  • RECURSIVE option 1
  • REDO command 1
  • REEDIT command 1
  • REGEXP_COUNT function 1
  • REGEXP_INSTR function 1
  • REGEXP_REPLACE function 1
  • REGEXP_SUBSTR function 1
  • REGRESS command 1, 2
  • regressions
    • linear 1
  • related dimensions 1, 2, 3
    • limiting to 1
  • relational tables See tables 1
  • RELATION command 1
  • relations
    • assigning values to 1
    • comparing to text literals 1
    • default 1, 2
    • defining 1
    • limiting to single value 1
    • QDR with 1
    • replacing dimension of 1
  • relations, in aggmaps
    • identifying changes 1
  • RELATION statement
    • for aggregation 1
    • for allocation 1
  • RELEASE command 1
  • remainder after division 1
  • REMAINDER function 1
  • REMBYTES function 1
  • REMCHARS function 1
  • REMCOLS function 1
  • REM function 1
  • REMLINES function 1
  • REMOVE_CUBE_MODEL program 1
  • REMOVE_DIMENSION_MEMBER program 1
  • REMOVE_MODEL_DIMENSION program 1
  • RENAME command 1
  • REPLACE function 1
  • replacing
    • characters 1
  • REPLBYTES function 1
  • REPLCHARS function 1
  • REPLCOLS function 1
  • REPLLINES function 1
  • REPORT command 1
  • reporting 1
  • reports
    • processing ROW command output 1
    • producing 1, 2
    • producing with ROW commands 1
  • RESERVED function 1
  • reserved words 1
  • RESYNC command 1
  • RETURN command 1
  • return value of a program 1
  • REVERT command 1
  • ROLE option 1
  • roles 1
  • root of negative number 1
  • ROOTOFNEGATIVE option 1
  • ROUND function
    • described 1
    • for datetimes 1
    • for numbers 1
  • ROW2CELL column 1, 2
  • ROW command 1
    • processing output 1
  • ROW function 1
  • ROWID data type 1
    • converting 1, 2
  • ROWIDTOCHAR function 1
  • ROWIDTONCHAR function 1
  • ROWTOHEX function 1
  • RPAD function 1
  • RR datetime format element 1
  • RTRIM function 1
  • running totals 1, 2
  • RUN procedure (PL/SQL) 1
  • run-time aggregation 1
  • RUNTOTAL function 1

S

  • scenario models 1
  • seasonal data 1
  • SECONDS option 1
  • segments
    • analytic workspace 1
    • locking 1
    • retrieving maximum size of 1
  • segment width 1
  • selecting
    • alias dimension values 1
    • data 1
  • SELECT statements (in OLAP DML) 1, 2
    • See also: SQL command in OLAP DML
  • SERVEROUTPUT option 1, 2, 3
  • SESSCACHE option 1
  • session
    • shutting down 1
    • starting up 1
  • session cache
    • See: OLAP session cache
  • session logs
    • printing 1
    • retrieving 1
  • sessions 1
    • preserving environment 1
    • recording in disk file 1
    • restoring environment 1
    • user ID 1
  • SESSIONTIMEZONE function 1
  • SET_INCLUDED_MODEL program 1
  • SET_PROPERTY program 1
  • SET1 command 1
  • SET command 1
  • SHOW command 1
  • SHUTDOWN procedure (PL/SQL) 1
  • SIGNAL command 1, 2
  • SIGN function 1
  • simultaneous equations in models 1
  • sine calculation 1, 2
  • SIN function 1
  • single-row functions 1
  • SINH function 1
  • SLEEP command 1
  • slowest-varying dimension 1
  • smaller value of two expressions 1
  • SMALLEST function 1
  • smallest value of an expression 1
  • SMOOTH function 1
  • solution variables
    • defined 1
    • example of 1
  • SORT
    • command 1
    • function 1
  • sorting
    • status list of a dimension 1, 2, 3
    • valuesets 1, 2
  • SORTLINES function 1
  • SOUNDEX function 1
  • SOURCEVAL statement 1
  • sparse data 1
    • base dimension value 1
    • changing definitions 1
    • eliminating 1
    • exporting 1
    • importing 1
    • index algorithm 1
    • obtaining information 1
    • reading from files 1
    • renaming composites 1
    • reporting 1, 2
    • specifying composites 1
  • SPARSEINDEX option 1
  • sparsity 1
    • See also: sparse data
    • controlled 1
    • random 1
  • SPARSITY_ADVICE_TABLE column descriptions 1
  • SPARSITY_ADVICE_TABLE procedure (PL/SQL) 1
  • Sparsity Advisor
  • SP datetime format element suffix 1
  • special characters 1
  • spelled numbers
    • specifying 1
  • spreadsheets 1
    • See also: worksheet objects
    • defining 1
    • exporting to 1
    • importing data from 1, 2
  • SPTH datetime format element suffix 1
  • SQL
    • embedding OLAP commands 1, 2, 3, 4, 5
    • managing analytic workspaces 1
  • SQL (in OLAP DML)
    • defining cursors 1
    • embedding statements 1, 2
    • precompiling statements 1
    • retrieving errors 1, 2
    • stored procedures 1
  • SQLBLOCKMAX option 1
  • SQLCODE option 1
  • SQLCOLUMNS procedure 1, 2
  • SQL command in OLAP DML
    • CLEANUP 1
    • CLOSE 1
    • DECLARE CURSOR 1
    • EXECUTE 1
    • FETCH 1
    • IMPORT 1
    • PREPARE 1
    • PROCEDURE 1
    • SELECT 1
  • SQLERRM option 1
  • SQLFETCH function 1
  • SQLMESSAGES option 1
  • SQLTABLES procedure 1, 3
  • SQRT command 1
  • square root 1
    • calculating 1
    • result for negative number 1
  • standard deviation calculation 1
  • STARTOF function 1
  • STARTUP procedure (PL/SQL) 1
  • STATALL function 1
  • STATCURR function 1
  • STATDEPTH function 1
  • statements
    • altering order of execution 1
    • editing previously executed 1
    • reading from a file 1
    • reexecuting 1
    • sending to file 1
  • STATEQUAL 1
  • STATFIRST function 1
  • STATIC_SESSION_LANGUAGE option 1
  • STATLAST function 1
  • STATLEN function 1
  • STATLIST function 1
  • STATMAX function 1
  • STATMIN function 1
  • STATRANK function 1
  • status
    • determining 1
    • setting 1
    • setting inside a statement 1
    • setting to null 1
  • status lists
    • base dimensions 1
    • comparing 1
    • current 1
    • default 1
    • defined 1
    • empty 1
    • first value in 1
    • last value in 1
    • looping over 1, 2, 3
    • most recent value 1
    • null values 1
    • number of values in 1
    • position in 1
    • restoring 1, 2
    • result of LIMIT command 1
    • retrieving 1
    • retrieving depth of 1
    • retrieving value by position 1
    • retrieving values from 1, 2
    • returning values 1
    • saving 1, 2, 3, 4
    • saving in a context 1
    • sending to outfile 1
    • setting to null 1
    • sorting 1, 2, 3
  • STATUS program 1
  • STATVAL function 1
  • STDDEV function 1
  • STDHDR program 1
    • line size for centering 1
  • storage
    • changing 1
    • of variables 1
  • stored procedures
    • creating 1
  • stored procedures (SQL)
    • executing 1
  • STORETRIGGERVAL property 1
  • strings
    • byte 1
    • length of 1
  • subevents, identifying 1
  • substitution expressions
  • substitution operator 1
  • SUBSTR2 function 1
  • SUBSTR4 function 1
  • SUBSTRB function 1
  • SUBSTRC function 1
  • SUBSTR function 1
  • substrings
    • counting 1
    • replacing 1
    • retrieving 1, 2, 3
    • retrieving position of 1
  • SUBTOTAL function 1
  • subtotals 1
    • in a report 1
    • resetting to zero 1
  • surrogate dimension 1
    • defining 1
  • surrogates
    • defining 1
    • deleting 1
  • SWITCH
    • conditional expression 1
  • SWITCH command 1, 2, 3
  • SYS_CONTEXT function 1
  • SYSDATE function 1
  • SYSINFO function 1
  • SYSTEM function 1
  • SYSTIMESTAMP function 1

T

  • tables
    • exporting from analytic workspaces 1
    • importing into analytic workspaces 1
  • table type 1
    • automatic 1, 2
    • predefining 1, 2
    • syntax for creating 1, 2
  • TALLY function 1
  • TAN function 1
  • tangent calculation 1
    • angle value 1
    • arc 1, 2
    • hyperbolic 1
  • TANH function 1
  • TCONVERT function 1
  • temporary members
    • adding to dimension 1
    • identifying 1
  • TEMPSTAT command 1
  • text
    • comparing values 1
    • converting to raw 1
    • data types 1
    • date and number formats 1
    • literals 1, 2
    • passing arguments as 1, 2
    • special characters 1
  • text expressions 1, 2
    • phonetic representation of 1
  • TEXTFILL function 1
  • text formatting
    • importing worksheet data 1
  • TH datetime format element suffix 1
  • THOUSANDSCHAR option 1
  • thousands marker 1
  • THSP datetime format element suffix 1
  • time format models
    • short 1
  • time of day 1, 2
  • time series 1
    • cumulative totals over 1
    • data from previous time period 1
    • data from subsequent time period 1
    • difference between time periods 1
    • maximum value in period 1
    • minimum value in period 1
    • moving totals over 1
    • percent difference between time periods 1, 2
  • timestamp
    • converting to local time zone 1
  • TIMESTAMP_LTZ data type 1
  • TIMESTAMP_TZ data type 1
  • TIMESTAMP data type 1
  • time zone
    • formatting 1
  • timezone offsets 1
  • time zones
    • converting data to particular 1
  • timing 1
    • execution of program lines 1
    • execution of programs 1
  • title for a report 1
  • TMARGIN option 1
  • TO_BINARY_DOUBLE function 1
  • TO_BINARY_FLOAT function 1
  • TO_CHAR function 1
  • TO_DATE function 1, 2
  • TO_NCHAR function 1
  • TO_NUMBER function 1
  • TO_TIMESTAMP_TZ function 1
  • TODAY function 1
  • TOD function 1
  • TOTAL function 1
  • totals
    • calculating 1
    • cumulative 1
    • in a report 1, 2, 3, 4
    • moving 1
    • over time 1
    • running 1
  • TRACE command 1
  • TRACEFILEUNIT option 1
  • tracking 1
    • cost of program lines 1
    • cost of programs 1
  • TRACKPRG command 1
  • TRACKREPORT program 1
  • TRANSLATE function 1
  • TRAP command 1, 2
  • TRIGGER_AFTER_UPDATE program 1
  • TRIGGER_AW program 1, 2
  • TRIGGER_BEFORE_UPDATE program 1
  • TRIGGER_DEFINE program 1
  • TRIGGERASSIGN command 1
  • TRIGGER command 1
  • TRIGGER function 1
  • TRIGGERMAXDEPTH option 1
  • trigger objects 1
  • trigger programs
    • Assign 1
    • Delete 1
    • designing 1
    • Maintain 1
    • Property 1
    • Update 1, 2
  • triggers
    • Assign 1, 2
    • creating 1
    • Define 1
    • Delete 1
    • deleting 1
    • events 1
    • Maintain 1
    • NA 1, 2, 3
    • objects 1
    • Property 1
    • subevents 1
    • Update 1, 2, 3
  • TRIGGERSTOREOK option 1
  • TRIM function 1
  • trimming expressions 1, 2
  • trimming strings 1
  • TRUNCATE function
    • described 1
    • for datetimes 1
    • for numbers 1
  • TRUNC function
    • See: TRUNCATE function
  • tuples 1
  • TZ_OFFSET function 1

U

  • UNHIDE command 1
  • UNIQUELINES function 1
  • unnamed composites 1
    • defining 1
    • example of 1
  • UNRAVEL function 1
  • UPCASE function 1
  • UPDATE_ATTRIBUTE_VALUE program 1
  • UPDATE_DIMENSION_MEMBER program 1
  • UPDATE command 1
    • event 1
    • events 1, 2
    • trigger 1
    • triggers 1, 3
  • UPPER function 1
  • UROWID data type 1
  • user-defined functions
    • arguments in 1
    • data type of 1
  • user ID, retrieving 1
  • USERID option 1
  • USETRIGGERS option 1
  • UTC offset
    • replacing with time zone region 1

V

  • VALSPERPAGE program 1
  • value name format 1
  • values 1
    • See also: Boolean values
    • restoring previous 1
    • saving current 1
  • valuesets
    • assigning values to 1
    • checking status of 1
    • defining 1
    • deleting 1
    • limiting 1
    • multidimensional 1
    • null 1
    • number of values in 1
    • retrieving values 1, 2, 3, 4
    • retrieving values from 1
    • setting the status of 1
    • sorting values 1, 2
  • VALUESET statement
  • VALUES function 1
  • VARCACHE option 1
  • VARIABLE command 1
  • variables
    • Aggcount 1, 2, 3, 4
    • assigning values to 1
    • defining 1
    • defining with composite 1
    • deleting 1
    • how data is stored 1
    • identifying changes 1, 2
    • limiting to single value 1, 3
    • local to a program 1
    • partitioned 1, 2
    • populating 1
    • QDR with 1, 3
    • replacing dimension of 1, 2
    • reshaping dimensionality of 1
    • session cache 1
    • storage of 1
  • version of Oracle OLAP 1
  • views
    • creating embedded total dimensions 1
    • creating embedded total measures 1
    • creating rollup form 1
    • template for creating with OLAP_TABLE 1
  • VINTSCHED function 1
  • VNF
    • See: value name format
  • VNF command 1, 2
  • VPMTSCHED function 1
  • VSIZE function 1

W

  • WEEKDAYSNEWYEAR option 1
  • WEEKOF function 1
  • WHILE command 1, 2
    • used with BREAK 1
    • used with CONTINUE 1
  • WIDTH_BUCKET function 1
  • wildcards 1
  • WKSDATA function 1
  • worksheet objects 1
    • See also: spreadsheets
    • cells 1
    • data type of cells 1
    • defining 1
    • deleting 1
    • dimensions 1
  • workspaces See analytic workspaces 1
  • WRAPERRORS option 1

Y

  • YESSPELL option 1
  • YMINTERVAL data type 1
  • YMINTERVAL function 1
  • YRABSTART option 1
  • YYOF function 1

Z

  • zero 1
    • dividing by 1, 2
    • spelling of 1
    • suppressing all-zero report rows 1
  • ZEROROW option 1
  • ZEROTOTAL command 1
  • ZSPELL option 1