Skip Headers
Oracle® OLAP DML Reference
11g Release 2 (11.2)

E17122-08
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
PDF · Mobi · ePub

9 OLAP DML Commands: A-G

This chapter contains the following topics:

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


FETCH
SQL

OLAP DML Statement Edit Commands


EDIT
RECAP
REDO
REEDIT