Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle OLAP DML Reference
-
1
OLAP DML Basic Concepts
- What is the OLAP DML?
- Basic Syntactic Units of the OLAP DML
- How to Execute OLAP DML Statements
- Introduction to Analytic Workspaces
- Introduction to Analytic Workspace Data Objects
- OLAP DML Statements Apply to All of the Values of a Data Object
- How to Specify the Set of Data that OLAP DML Operations Work Against
- Populating Multidimensional Hierarchical Data Objects
-
2
Data Types, Operators, and Expressions
- OLAP DML Data Types
- OLAP DML Operators
-
OLAP DML Expressions
- About OLAP DML Expressions
- Using Workspace Objects in Expressions
- Working with Empty Cells in Expressions
- Numeric Expressions
- Text Expressions
- Datetime and Interval Expressions
- Date-only Expressions
- Boolean Expressions
- Conditional Expressions
- Substitution Expressions
- 3 Formulas, Models, Aggregations, and Allocations
-
4
OLAP DML Properties
- About OLAP DML Properties
- System Properties: Alphabetical Listing
- System Properties by Category
- $AGGMAP
- $AGGREGATE_FORCECALC
- $AGGREGATE_FORCEORDER
- $AGGREGATE_FROM
- $AGGREGATE_FROMVAR
- $ALLOCMAP
- $COUNTVAR
- $DEFAULT_LANGUAGE
- $GID_DEPTH
- $GID_LIST
- $GID_TYPE
- $LOOP_AGGMAP
- $LOOP_DENSE
- $LOOP_TYPE
- $LOOP_VAR
- $NATRIGGER
- $STORETRIGGERVAL
- $VARCACHE
-
5
OLAP DML Options
- About Options
- Options: Alphabetical Listing
- Options by Category
- ALLOCERRLOGFORMAT
- ALLOCERRLOGHEADER
- AWWAITTIME
- BADLINE
- BMARGIN
- CALENDARWEEK
- COLWIDTH
- COMMAS
- COMPILEMESSAGE
- COMPILEWARN
- DATEFORMAT
- DATEORDER
- DAYABBRLEN
- DAYNAMES
- DECIMALCHAR
- DECIMALOVERFLOW
- DECIMALS
- DEFAULTAWSEGSIZE
- DIVIDEBYZERO
- DSECONDS
- ECHOPROMPT
- EIFBYTES
- EIFEXTENSIONPATH
- EIFNAMES
- EIFSHORTNAMES
- EIFTYPES
- EIFUPDBYTES
- EIFVERSION
- ERRNAMES
- ERRORNAME
- ERRORTEXT
- ESCAPEBASE
- EXPTRACE
- INF_STOP_ON_ERROR
- LCOLWIDTH
- LIKECASE
- LIKEESCAPE
- LIKENL
- LIMIT.SORTREL
- LIMITSTRICT
- LINENUM
- LINESLEFT
- LOCK_LANGUAGE_DIMS
- LSIZE
- MAXFETCH
- MODDAMP
- MODERROR
- MODGAMMA
- MODINPUTORDER
- MODMAXITERS
- MODOVERFLOW
- MODSIMULTYPE
- MODTOLERANCE
- MODTRACE
- MONTHABBRLEN
- MONTHNAMES
- MULTIPATHHIER
- NASKIP
- NASKIP2
- NASPELL
- NLS_CALENDAR
- NLS_CURRENCY
- NLS_DATE_FORMAT
- NLS_DATE_LANGUAGE
- NLS_DUAL_CURRENCY
- NLS_ISO_CURRENCY
- NLS_LANG
- NLS_LANGUAGE
- NLS_NUMERIC_CHARACTERS
- NLS_SORT
- NLS_TERRITORY
- NOSPELL
- OKFORLIMIT
- OKNULLSTATUS
- OUTFILEUNIT
- PAGENUM
- PAGEPRG
- PAGESIZE
- PAGING
- PARENS
- PERMITERROR
- PERMITREADERROR
- PRGTRACE
- RANDOM.SEED.1 and RANDOM.SEED.2
- RECURSIVE
- ROLE
- ROOTOFNEGATIVE
- SECONDS
- SESSCACHE
- SESSION_NLS_LANGUAGE
- SPARSEINDEX
- SQLBLOCKMAX
- SQLCODE
- SQLERRM
- SQLMESSAGES
- STATIC_SESSION_LANGUAGE
- THIS_AW
- THOUSANDSCHAR
- TMARGIN
- TRACEFILEUNIT
- TRIGGERMAXDEPTH
- TRIGGERSTOREOK
- USERID
- USETRIGGERS
- VARCACHE
- WEEKDAYSNEWYEAR
- WRAPERRORS
- YESSPELL
- YRABSTART
- ZEROROW
- ZSPELL
-
6
OLAP DML Programs
- Programs Provided With the OLAP DML
- Creating OLAP DML Programs
- Specifying Program Contents
- Compiling Programs
- Testing and Debugging Programs
- Executing Programs
- Common Types of OLAP DML Programs
- User-Written Programs Looked For by Oracle OLAP
-
7
OLAP DML Functions: A - K
- About OLAP DML Functions
- Functions: Alphabetical Listing
- Functions by Category
- ABS
- ADD_MONTHS
- AGGCOUNT
- AGGMAPINFO
- AGGREGATE function
- AGGREGATION
- AGGROPS
- ALLOCOPS
- ANTILOG
- ANTILOG10
- ANY
- ARCCOS
- ARCSIN
- ARCTAN
- ARCTAN2
- ARG
- ARGCOUNT
- ARGFR
- ARGS
- ASCII
- ASCIISTR
- AVERAGE
- AW function
- BACK
- BASEDIM
- BASEVAL
- BEGINDATE
- BIN_TO_NUM
- BITAND
- BLANKSTRIP
- CALLTYPE
- CATEGORIZE
- CEIL
- CHANGEBYTES
- CHANGECHARS
- CHANGEDRELATIONS
- CHANGEDVALUES
- CHARLIST
- CHARTOROWID
- CHGDIMS
- CHR
- COALESCE
- COLVAL
- CONTEXT function
- CONVERT
- CORRELATION
- COS
- COSH
- COUNT
- CUMSUM
- CURRENT_DATE
- CURRENT_TIMESTAMP
- DAYOF
- DBTIMEZONE
- DDOF
- DECODE
- DEPRDECL
- DEPRDECLSW
- DEPRSL
- DEPRSOYD
- ENDDATE
- ENDOF
- EVERY
- EXISTS
- EXP
- EVERSION
- EXTBYTES
- EXTCHARS
- EXTCOLS
- EXTLINES
- EXTRACT
- FCOPEN
- FCQUERY
- FILEERROR
- FILEGET
- FILENEXT
- FILEOPEN
- FILEQUERY
- FILTERLINES
- FINDBYTES
- FINDCHARS
- FINDLINES
- FINTSCHED
- FLOOR
- FPMTSCHED
- FROM_TZ
- GET
- GREATEST
- GROUPINGID function
- GROWRATE
- HEXTORAW
- HIERCHECK
- HIERHEIGHT
- HIERSHAPE
- INFO
- INITCAP
- INLIST
- INSBYTES
- INSCHARS
- INSCOLS
- INSLINES
- INSTAT
- INSTR functions
- INTPART
- IRR
- ISDATE
- ISINFINITE
- ISEMPTY
- ISNAN
- ISSESSION
- ISVALUE
- JOINBYTES
- JOINCHARS
- JOINCOLS
- JOINLINES
- KEY
-
8
OLAP DML Functions: L - Z
- LAG
- LAGABSPCT
- LAGDIF
- LAGPCT
- LARGEST
- LAST_DAY
- LEAD
- LEAST
- LENGTH functions
- LIMIT function
- LIMITMAPINFO
- LNNVL
- LOCALTIMESTAMP
- LOG function
- LOG10
- LOWCASE
- LOWER
- LPAD
- LTRIM
- MAKEDATE
- MAX
- MAXBYTES
- MAXCHARS
- MEDIAN
- MIN
- MMOF
- MODE
- MODULO
- MONTHS_BETWEEN
- MOVINGAVERAGE
- MOVINGMAX
- MOVINGMIN
- MOVINGTOTAL
- NA2
- NAFILL
- NAFLAG
- NEW_TIME
- NEXT_DAY
- NLS_CHARSET_ID
- NLS_CHARSET_NAME
- NLSSORT
- NONE
- NORMAL
- NPV
- NULLIF
- NUMBYTES
- NUMCHARS
- NUMLINES
- NUMTODSINTERVAL
- NUMTOYMINTERVAL
- NVL
- NVL2
- OBJ
- OBJLIST
- OBJORG
- OBSCURE
- ORA_HASH
- PARTITION
- PARTITIONCHECK
- PERCENTAGE
- QUAL
- RANDOM
- RANK
- RAWTOHEX
- RECNO
- REGEXP_COUNT
- REGEXP_INSTR
- REGEXP_REPLACE
- REGEXP_SUBSTR
- REM
- REMAINDER
- REMBYTES
- REMCHARS
- REMCOLS
- REMLINES
- REPLACE
- REPLBYTES
- REPLCHARS
- REPLCOLS
- REPLLINES
- RESERVED
- ROUND
- ROW function
- ROWIDTOCHAR
- ROWIDTONCHAR
- RPAD
- RTRIM
- RUNTOTAL
- SESSIONTIMEZONE
- SIGN
- SIN
- SINH
- SMALLEST
- SMOOTH
- SORT function
- SORTLINES
- SOUNDEX
- SQLFETCH
- SQRT
- STARTOF
- STATALL
- STATCURR
- STATDEPTH
- STATEQUAL
- STATFIRST
- STATLAST
- STATLEN
- STATLIST
- STATMAX
- STATMIN
- STATRANK
- STATVAL
- STDDEV
- SUBSTR functions
- SUBTOTAL
- SYS_CONTEXT
- SYSDATE
- SYSINFO
- SYSTEM
- SYSTIMESTAMP
- TALLY
- TAN
- TANH
- TCONVERT
- TEXTFILL
- TO_BINARY_DOUBLE
- TO_BINARY_FLOAT
- TO_CHAR
- TO_DATE
- TO_DSINTERVAL
- TO_NCHAR
- TO_NUMBER
- TO_TIMESTAMP
- TO_TIMESTAMP_TZ
- TO_YMINTERVAL
- TOD
- TODAY
- TOTAL
- TRANSLATE
- TRIGGER function
- TRIM
- TRUNCATE
- TZ_OFFSET
- UNIQUELINES
- UNRAVEL
- UPPER
- UPPER
- VALSPERPAGE
- VALUES
- VINTSCHED
- VPMTSCHED
- VSIZE
- WEEKOF
- WIDTH_BUCKET
- WKSDATA
- WRITABLE
- YYOF
-
9
OLAP DML Commands: A-G
- About OLAP DML Commands
- Commands: Alphabetical Listing
- Commands by Category
- ACQUIRE
- ACROSS
- ADD_CUBE_MODEL
- ADD_DIMENSION_MEMBER
- ADD_MODEL_DIMENSION
- AGGMAP
- AGGMAP ADD or REMOVE model
- AGGMAP SET
- AGGREGATE command
- ALLCOMPILE
- ALLOCATE
- ALLOCMAP
- ALLSTAT
- ARGUMENT
- AW command
- AWDESCRIBE
- BLANK
- BREAK
- CALL
- CDA
- CHGDFN
- CLEAR
- COMMIT
- COMPILE
- CONSIDER
- CONTEXT command
- CONTINUE
- COPYDFN
- CREATE_LOGICAL_MODEL
- DATE_FORMAT
- DBGOUTFILE
- DEFINE
- DELETE
- DESCRIBE
- DO ... DOEND
- EDIT
- EQ
- EXPORT
- FCCLOSE
- FCEXEC
- FCSET
- FETCH
- FILECLOSE
- FILECOPY
- FILEDELETE
- FILEMOVE
- FILEPAGE
- FILEPUT
- FILEREAD
- FILESET
- FILEVIEW
- FOR
- FORECAST
- FORECAST.REPORT
- FULLDSC
- GOTO
- GROUPINGID command
-
10
OLAP DML Commands: H-Z
- HEADING
- HIDE
- HIERDEPTH
- HIERHEIGHT command
- IF...THEN...ELSE command
- IMPORT
- INFILE
- LD
- LIMIT command
- LIMIT BASEDIMS
- LISTBY
- LISTFILES
- LISTNAMES
- LOAD
- LOG command
- MAINTAIN
- MODEL
- MODEL.COMPRPT
- MODEL.DEPRT
- MODEL.XEQRPT
- MONITOR
- MOVE
- OUTFILE
- PAGE
- PARSE
- PERMIT
- PERMITRESET
- POP
- POPLEVEL
- PROGRAM
- PROPERTY
- PUSH
- PUSHLEVEL
- RECAP
- REDO
- REEDIT
- REGRESS
- REGRESS.REPORT
- RELATION command
- RELEASE
- REMOVE_CUBE_MODEL
- REMOVE_DIMENSION_MEMBER
- REMOVE_MODEL_DIMENSION
- RENAME
- REPORT
- RESYNC
- RETURN
- REVERT
- ROW command
- SET
- SET1
- SET_INCLUDED_MODEL
- SET_PROPERTY
- SHOW
- SIGNAL
- SLEEP
- SORT command
- SQL
- STATUS
- STDHDR
- SWITCH command
- TEMPSTAT
- TRACE
- TRACKPRG
- TRAP
- TRIGGER command
- TRIGGERASSIGN
- UNHIDE
- UPDATE
- UPDATE_ATTRIBUTE_VALUE
- UPDATE_DIMENSION_MEMBER
- VARIABLE
- VNF
- WHILE
- ZEROTOTAL
- A OLAP_TABLE SQL Functions
-
B
DBMS_AW PL/SQL Package
- Managing Analytic Workspaces
- Embedding OLAP DML in SQL Statements
- Using the Sparsity Advisor
- Using the Aggregate Advisor
- Summary of DBMS_AW Subprograms
- ADD_DIMENSION_SOURCE Procedure
- ADVISE_CUBE Procedure
- ADVISE_DIMENSIONALITY Function
- ADVISE_DIMENSIONALITY Procedure
- ADVISE_PARTITIONING_DIMENSION Function
- ADVISE_PARTITIONING_LEVEL Function
- ADVISE_REL Procedure
- ADVISE_SPARSITY Procedure
- AW_ATTACH Procedure
- AW_COPY Procedure
- AW_CREATE Procedure
- AW_DELETE Procedure
- AW_DETACH Procedure
- AW_RENAME Procedure
- AW_TABLESPACE Function
- AW_UPDATE Procedure
- CONVERT Procedure
- EVAL_NUMBER Function
- EVAL_TEXT Function
- EXECUTE Procedure
- GETLOG Function
- INFILE Procedure
- INTERP Function
- INTERPCLOB Function
- INTERP_SILENT Procedure
- OLAP_ON Function
- OLAP_RUNNING Function
- PRINTLOG Procedure
- RUN Procedure
- SHUTDOWN Procedure
- SPARSITY_ADVICE_TABLE Procedure
- STARTUP Procedure
- C OLAP_API_SESSION_INIT PL/SQL Package
- D Changes in Previous Releases
- Index