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 2.3.8.6.1
  • ((amp)) operator 2.3.10
  • $AGGMAP property 4.4
  • $AGGREGATE_FORCECALC property 4.5
  • $AGGREGATE_FORCEORDER property 4.6
  • $AGGREGATE_FROM property 4.7, 9.9.9
  • $AGGREGATE_FROMVAR property 4.8
  • $ALLOCMAP property 4.9
  • $COUNTVAR property 4.10
  • $DEFAULT_LANGUAGE property 4.11
  • $GID_DEPTH property 4.12
  • $GID_LIST property 4.13
  • $GID_TYPE property 4.14
  • $LOOP_AGGMAP property 4.15
  • $LOOP_DENSE property 4.16
    • for derived measures in cubes 10.53
  • $LOOP_TYPE property 4.17
  • $LOOP_VAR property 4.18
    • for derived measures in cubes 10.53
  • $NATRIGGER property
    • calling recursively 5.88
    • executing simultaneously 5.104
  • $STORETRIGGERVAL property 4.20
  • $VARCACHE property
  • % wildcard 2.3.8.6.1
  • = command 10.50

Numerics


A

  • A.D. datetime format element 9.33
  • A.M. datetime format element 9.33
  • ABS function
  • abstract data types A.1.2, A.3
  • ACQUIRE command
  • ACROSS command
  • ADD_ALTER_SESSION procedure (PL/SQL) C.3.1
  • ADD_CUBE_MODEL program 9.6
  • ADD_DIMENSION_MEMBER program 9.7
  • ADD_DIMENSION_SOURCE procedure (PL/SQL) B.6
  • ADD_MODEL_DIMENSION program 9.8
  • ADD_MONTHS command
  • AD datetime format element 9.33
  • ADT
  • ADVISE_CUBE procedure (PL/SQL) B.7
  • ADVISE_DIMENSIONALITY function (PL/SQL) B.8
  • ADVISE_DIMENSIONALITY procedure (PL/SQL) B.9
  • ADVISE_REL procedure B.4.2
  • ADVISE_REL procedure (PL/SQL) B.12
  • ADVISE_SPARSITY procedure (PL/SQL) B.13
  • Aggcount variables 7.6, 8.53, 9.24, 9.35.11
  • AGGINDEX statement
  • AGGMAP ADD model command
  • AGGMAP command
  • AGGMAPINFO command
  • aggmap objects
    • identifying changes 7.39
  • AGGMAP REMOVE model command
  • aggmaps 9.35.1
    • See also: aggregation specifications, allocation specifications
  • AGGMAP SET command
  • Aggregate Advisor 3.4.4, 9.9.8, 9.9.9
  • AGGREGATE command
  • AGGREGATE function
  • aggregating data 3.4.1
    • See also: aggregation specifications
    • caching 5.108
    • formulas for 7.8
    • on-the-fly 3.4.4
    • partitioned variables 8.59
    • precomputing 3.4.4
    • specifying a relation for 9.9.9
    • using an Aggcount variable 7.6
    • using an aggmap object 3.4.1
    • using TCONVERT 8.124
  • aggregation
    • in analytic workspaces B.4
  • AGGREGATION function
  • aggregations
  • aggregation specifications 3.4.3
    • See also: aggregating data
  • algorithm for composite values 5.94
  • alias dimensions
  • aliases
    • for analytic workspaces 2.3.2.2
    • for analytic workspaces. See analytic workspace aliases 2.3.2.2
    • for dimensions. See alias dimensions 9.35.3.5
  • ALLCOMPILE program
  • ALLOCATE command
  • allocating data 3.5
    • See also: allocation specifications
    • using an aggmap object 3.5
    • using TCONVERT 8.124
  • allocation specifications 9.15
    • See also: allocating data
  • ALLOCERRLOGFORMAT option 5.4
  • ALLOCERRLOGHEADER option
  • ALLOCMAP command
  • ALLSTAT command
  • AM datetime format element 9.33
  • ampersand (((amp))) operator 2.3.10
  • ampersand substitution
  • analytic workspace aliases
  • analytic workspace objects
    • underlying cubes and cube dimensions 8.55
  • analytic workspaces
  • ANTILOG10 function
  • ANTILOG function
  • ANY function
  • ARCCOS function
  • ARCSIN function
  • ARCTAN2 function 7.18
  • ARCTAN function 7.17
  • arc tangent calculation 7.18
  • ARG command
    • See: ARGUMENT command
  • ARGCOUNT function
  • ARGFR function
  • ARG function
  • ARGS function
  • ARGUMENT command
  • arguments 7.19
  • arithmetic
  • ASCII function 7.23
  • ASCIISTR function 7.24
  • Assign event 10.66
  • assignment statements
  • authentication 8.56
    • encoding text expressions 8.56
    • within Oracle OLAP 10.26
  • AUTOGO program 6.8.1
  • AVERAGE function 7.25
  • AW_ATTACH procedure (PL/SQL) B.14
  • AW_COPY procedure (PL/SQL) B.15
  • AW_CREATE procedure (PL/SQL) B.16
  • AW_DELETE procedure (PL/SQL) B.17
  • AW_DETACH procedure (PL/SQL) B.18
  • AW_RENAME procedure (PL/SQL) B.19
  • AW_TABLESPACE function (PL/SQL) B.20
  • AW_UPDATE procedure (PL/SQL) B.21
  • AW command
  • AWDESCRIBE program
  • AW function
  • AW PURGE 9.18.8
  • AWWAITTIME option 5.6

B


C


D


E


F


G


H

  • handling errors in programs 10.65
  • hash partitions 9.18.3
  • hash values 8.57
  • heading 10.1
    • for a report 10.1
    • for output pages 5.80
    • including a page number 5.79
    • producing standard report heading 10.60
  • HEADING command
  • hexadecimal digits
    • converting to raw 7.94
  • HEXTORAW function 7.94
  • HIDE command 10.2
  • hierarchies
  • hierarchy shape 7.97
  • HIERHEIGHT command 10.4
  • HIERHEIGHT function 7.96
  • HIERSHAPE function 7.97
  • Holt-Winters forecasting 9.56
  • hyperbolic
    • cosine calculation 7.51
    • sine calculation 8.92
    • tangent calculation 8.123

I


J

  • JOINBYTES function 7.115
  • JOINCHARS function 7.116
  • JOINCOLS function 7.117
  • JOINLINES function 7.118

K


L


M


N

  • NA2 bits 2.3.3, 9.35.11
  • NA2 function 8.34
  • NA2 values 8.34, 8.36
  • NAFILL function 8.35
  • NAFLAG function 8.36
  • name 10.13
    • changing object name 10.44
    • dimension 10.13
    • listing names of dictionary entries 10.13
  • NAME dimension
  • names
  • NaN values
  • NASKIP2 option 5.62
  • NASKIP option 5.61
  • NASPELL option 5.63, 9.17
  • NATRIGGER
    • See: $NATRIGGER
  • natural logarithm 8.14
  • NA values
  • negative value 5.83
    • in output 5.83
    • obtaining the root 5.90
  • net present value 8.44
  • NEW_TIME function 8.37
  • NEXT_DAY function 8.38
  • NLS_CALENDAR option 5.64
  • NLS_CHARSET_ID function 8.39
  • NLS_CHARSET_NAME function 8.40
  • NLS_CURRENCY option 5.65
  • NLS_DATE_FORMAT option 5.66
  • NLS_DATE_LANGAUGE option 5.67
  • NLS_DATE_LANGUAGE initialization parameter 9.33
  • NLS_DUAL_CURRENCY option 5.68
  • NLS_ISO_CURRENCY option 5.69
  • NLS_LANG option 5.70
  • NLS_LANGUAGE initialization parameter 9.33
  • NLS_LANGUAGE option 5.71
  • NLS_NUMERIC_CHARACTERS option 5.72
  • NLS_SORT option 5.73
  • NLS_TERRITORY initialization parameter 9.33
  • NLS_TERRITORY option 5.74
  • NLSSORT function 8.41
  • NONE function 8.42
  • NORMAL function 8.43
  • NOSPELL option 5.75
  • NPV function 8.44
  • NULLIF function 8.45
  • null values
    • See: NA values
  • numbers
    • assigning random numbers 8.62
    • commas in output 5.11
    • decimal marker for output 5.18
    • decimal places in output 5.20
    • determining sign of 8.90
    • negative values in output 5.83
    • rounding 8.82
    • spelling out 9.33
    • thousands marker for output 5.101
  • NUMBYTES function 8.46
  • NUMCHARS function 8.47
  • numeric conversion 8.126, 8.127
  • numeric data types 2.1.1
  • numeric expressions
  • numeric values
  • NUMLINES function 8.48
  • NUMTODSINTERVAL function 8.49
  • NUMTOYMNTERVAL function 8.50
  • NVL2 function 8.52
  • NVL function 8.51

O

  • object definitions
    • adding descriptions to 10.8
    • deleting descriptions from 10.8
  • objects 9.31
    • checking for changes 8.53
    • compiling 5.13
    • creating by copying 9.31
    • creating properties 10.31
    • data type of (determining) 8.53
    • defining 9.35
    • definition (retrieving) 8.53
    • deleting 9.36
    • describing its definition 9.37
    • describing its properties 9.58
    • dimensions of (retrieving) 8.53
    • dropping changes 10.48
    • exporting from analytic workspace 9.41
    • identifying triggers 8.140
    • importing into analytic workspace 10.6
    • in expressions 2.3.2
    • listing 8.54
    • listing names of 10.11, 10.13
    • loading 10.14
    • making current 9.28
    • obtaining information 8.53
    • pages used to store (determining) 8.53
    • qualified name 2.3.2.2
    • recalculating permissions 10.27
    • renaming 10.44
    • restrictions on name 9.35
    • storage class (determining) 8.53
    • testing for existence 7.67
  • object types
  • OBJ function 8.53
  • OBJLIST function 8.54
  • OBJORG function 8.55
  • OBSCURE function 8.56
  • OESEIFVERSION option
    • See: EIFVERSION option
  • OKFORLIMIT option 5.76
  • OKNULLSTATUS option 5.77, 10.9
  • OLAP_API_SESSION_INIT PL/SQL package
    • ADD_ALTER_SESSION procedure C.3.1
    • CLEAN_ALTER_SESSION procedure C.3.2
    • DELETE_ALTER_SESSION procedure C.3.3
  • OLAP_CONDITION function (SQL) A.3
  • OLAP_EXPRESSION_BOOL function (SQL) A.6
  • OLAP_EXPRESSION_DATE function (SQL)
  • OLAP_EXPRESSION_TEXT function (SQL)
  • OLAP_EXPRESSION function (SQL) B.2.1
  • OLAP_ON function (PL/SQL) B.31, B.32
  • OLAP_TABLE
  • OLAP_TABLE function (SQL)
    • custom measures A.5, A.6, A.7, A.8
    • data map parameter A.3
    • data type conversions A.3
    • examples A.3
    • FETCH command A.3
    • limit map A.1, A.3
    • retrieving session log B.26
    • specifying an OLAP DML command A.3
    • specifying a ROW2CELL column A.3
    • specifying the analytic workspace A.3
    • specifying the logical table A.3
  • OLAP API
    • optimization C
  • OLAP DML
  • OLAP session cache
    • blocking creation of 5.92
    • checking if empty 8.53
    • defined 5.92
    • for variable 8.53
    • non-NA values 8.53
    • populating with aggregated values 5.108, 9.9.3
    • populating with NA values 5.108
  • ONATTACH program 6.8.2
  • ONDETACH program 6.8.3
  • OPEN command See SQL command in OLAP DML 10.58.7
  • operating system, identifying 8.119
  • operators 5.41
  • optimization
  • options
    • displaying value of 5.1
    • restoring previous values 6.3.4.3
    • retrieving 5.1
    • saving current values 6.3.4.3
    • specifying 5.1
  • ORA_HASH function 8.57
  • Oracle OLAP
    • internal build number 7.69
  • ordinal numbers
  • outfile
  • OUTFILE command 10.23
    • affect on DBMS_AW.EXECUTE B.25
    • affect on DBMS_AW.RUN B.34
  • OUTFILEUNIT option 5.78
  • out-of-range decimal values 5.19
  • output 10.23
  • overflow condition 5.19

P


Q


R


S


T


U


V


W


Y


Z