9 OLAP DML Commands: A-G

This chapter contains the following topics:

About OLAP DML Commands
Commands: Alphabetical Listing
Commands by Category
One topic for each of the OLAP DML commands that begins with the letters A - G, beginning with ACQUIRE.

Reference topics for the remaining OLAP DML commands appear in alphabetical order in Chapter 10, "OLAP DML Commands: H-Z".

For other OLAP DML reference topics, see Chapter 4, "OLAP DML Properties", Chapter 5, "OLAP DML Options", Chapter 7, "OLAP DML Functions: A - K", and Chapter 8, "OLAP DML Functions: L - Z".

About OLAP DML Commands

OLAP DML commands work in much the same way as commands in other programming languages—the one exception is the looping nature of OLAP DML commands as discussed in "OLAP DML Statements Apply to All of the Values of a Data Object".

Many OLAP DML commands perform complex actions. Some of these commands are data definition commands like the AW command which you use to create an analytic workspace and the DEFINE command which you use to define objects within an analytic workspace. Other OLAP DML commands are data manipulation commands. For example, you can use the OLAP DML SQL command to embed SQL statements in an OLAP DML program to copy data from relational tables into analytic workspace data objects, or you can use the AGGREGATE command to calculate summary data. Additionally, the DEFINE, MAINTAIN, PROPERTY, SET (=) UPDATE, and AW commands are recognized by Oracle OLAP as events that can trigger the execution of OLAP DML programs. (See "Trigger Programs" for more information.)

Tip:

Many OLAP DML statements can be coded as a 3-character abbreviation that consists of the first letter of the statement plus the next two consonants.

Additionally, you can augment the functionality of the OLAP DML by writing an OLAP DML program for use as a command.

Commands: Alphabetical Listing

A B C D E F G H I L M O P R S T U V W Z

A

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

B

C

CALL
CDA
CHGDFN
CLEAR
COMMIT
COMPILE
CONSIDER
CONTEXT command
CONTINUE
COPYDFN
CREATE_LOGICAL_MODEL

D

DATE_FORMAT
DBGOUTFILE
DEFINE
DELETE
DESCRIBE
DO ... DOEND

E

F

FCCLOSE
FCEXEC
FCSET
FETCH
FILECLOSE
FILECOPY
FILEDELETE
FILEMOVE
FILEPAGE
FILEPUT
FILEREAD
FILESET
FILEVIEW
FOR
FORECAST
FORECAST.REPORT
FULLDSC

G

GOTO
GROUPINGID command
HEADING

H

HIDE
HIERDEPTH
HIERHEIGHT command

I

IF...THEN...ELSE command

I

L

LD
LIMIT command
LIMIT BASEDIMS
LISTBY
LISTFILES
LISTNAMES
LOAD
LOG command

M

MAINTAIN
MODEL
MODEL.COMPRPT
MODEL.DEPRT
MODEL.XEQRPT
MONITOR
MOVE

O

P

PAGE
PARSE
PERMIT
PERMITRESET
POP
POPLEVEL
PROGRAM
PROPERTY
PUSH
PUSHLEVEL

R

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

S

SET
SET1
SET_INCLUDED_MODEL
SET_PROPERTY
SHOW
SIGNAL
SLEEP
SORT command
SQL
STATUS
STDHDR
SWITCH command

T

TEMPSTAT
TRACE
TRACKPRG
TRAP
TRIGGER command
TRIGGERASSIGN

U

UNHIDE
UPDATE
UPDATE_ATTRIBUTE_VALUE
UPDATE_DIMENSION_MEMBER

V

W

Z

Commands by Category

OLAP Cube and Cube Dimension Modification Commands

ADD_CUBE_MODEL
ADD_DIMENSION_MEMBER
ADD_MODEL_DIMENSION
CREATE_LOGICAL_MODEL
REMOVE_CUBE_MODEL
REMOVE_DIMENSION_MEMBER
REMOVE_MODEL_DIMENSION
SET_INCLUDED_MODEL
SET_PROPERTY
UPDATE_ATTRIBUTE_VALUE
UPDATE_DIMENSION_MEMBER

See also OBJORG function

Aggregation Commands

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

Allocation Commands

ALLOCATE
ALLOCMAP
DEFINE AGGMAP

Assigment Commands

CLEAR
MAINTAIN
SET
SET1
TRIGGER command
TRIGGERASSIGN

Debugging Commands

DBGOUTFILE
LOG command
MONITOR
SIGNAL
TRACKPRG
TRAP

Analytic Workspace Object Definition Commands

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 Commands

ACROSS
ALLSTAT
LIMIT command
LIMIT BASEDIMS
STATUS
TEMPSTAT

Forecast and Regression Commands

FCCLOSE
FCEXEC
FCSET
FORECAST
FORECAST.REPORT
REGRESS
REGRESS.REPORT

Date Formatting Commands

DATE_FORMAT
VNF

Formula Commands

DEFINE FORMULA
EQ
TRACE

Analytic Workspace Management Commands

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

Analytic Workspace Multiwriter Management Commands

ACQUIRE
RELEASE
RESYNC
REVERT

File Management Commands

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

Data Model Commands

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

Programming Commands

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

Reporting Commands

BLANK
HEADING
PAGE
REPORT
ROW command
SHOW
STDHDR
ZEROTOTAL

Save and Restore Value Commands

CONTEXT command
POP
POPLEVEL
PUSH
PUSHLEVEL

Sorting Commands

MOVE
SORT command

Spreadsheet Commands

DEFINE WORKSHEET
EXPORT (spreadsheet)
IMPORT (spreadsheet)

SQL Execution Commands

OLAP DML Statement Edit Commands

EDIT
RECAP
REDO
REEDIT