Skip Headers
Oracle® OLAP DML Reference
11g Release 1 (11.1)

Part Number B28126-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

Commands by Category

Aggregating Data


AGGMAP
AGGMAP ADD or REMOVE model
AGGMAP SET
AGGREGATE command
DEFINE AGGMAP
HIERDEPTH
HIERHEIGHT command

Allocating Data


ALLOCATE
ALLOCMAP
DEFINE AGGMAP

Assigning Values to Objects


CLEAR
MAINTAIN
SET
SET1
TRIGGER command
TRIGGERASSIGN

Debugging


DBGOUTFILE
LOG command
MONITOR
SIGNAL
TRACKPRG
TRAP

Defining Analytic Workspace Objects


CHGDFN
CONSIDER
COPYDFN
DEFINE
DELETE
DESCRIBE
FULLDSC
GROUPINGID command
HIDE
HIERHEIGHT command
LD
LISTBY
LISTNAMES
LOAD
PROPERTY
RELATION command
RENAME
TRIGGER command
UNHIDE

Dimension Status


ACROSS
ALLSTAT
LIMIT command
LIMIT BASEDIMS
STATUS
TEMPSTAT

Forecasts and Regressions


FCCLOSE
FCEXEC
FCSET
FORECAST
FORECAST.REPORT
REGRESS
REGRESS.REPORT

Formatting Dates


DATE_FORMAT
VNF

Formulas


DEFINE FORMULA
EQ

Managing Analytic Workspaces


AW command
COMMIT
EXPORT (EIF)
IMPORT (EIF)
PERMIT
PERMITRESET
RENAME
UPDATE

Managing Analytic Workspaces - Multiwriter Mode


ACQUIRE
RELEASE
RESYNC
REVERT

Managing Files


CDA
FILECLOSE
FILECOPY
FILEDELETE
FILEMOVE
FILEPAGE
FILEPUT
FILEREAD
FILESET
FILEVIEW
IMPORT (text)
INFILE
LISTFILES
OUTFILE

Modeling Data


AGGMAP ADD or REMOVE model
DEFINE MODEL
DIMENSION (in models)
INCLUDE
MODEL
MODEL.COMPRPT
MODEL.DEPRT
MODEL.XEQRPT
SET

Programming


ALLCOMPILE
ARGUMENT
BREAK
BREAK
CALL
CONTINUE
CONTINUE
DEFINE PROGRAM
DO ... DOEND
FOR
GOTO
HIDE
IF...THEN...ELSE command
PARSE
PROGRAM
RETURN
SLEEP
SWITCH command
TRIGGER command
TRIGGERASSIGN
UNHIDE
VARIABLE
WHILE

Reporting


BLANK
HEADING
PAGE
REPORT
ROW command
SHOW
STDHDR
ZEROTOTAL

Saving and Restoring Values


CONTEXT command
POP
POPLEVEL
PUSH
PUSHLEVEL

Sorting Values


MOVE
SORT command

Working with Spreadsheets


DEFINE WORKSHEET
EXPORT (spreadsheet)
IMPORT (spreadsheet)

Working with SQL


FETCH
SQL

Working with OLAP DML Statements


EDIT
RECAP
REDO
REEDIT