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

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

Go to previous page
Go to next page
View PDF


The Oracle OLAP DML Reference provides a complete description of the OLAP Data Manipulation Language (OLAP DML) used to create analytic workspace definitions that are stored within an analytic workspace and to manipulate these object.


Oracle OLAP DML Reference is intended for programmers and database administrators who write OLAP DML programs and who create analytic workspaces and analytic workspace objects using the OLAP DML.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Deaf/Hard of Hearing Access to Oracle Support Services

To reach Oracle Support Services, use a telecommunications relay service (TRS) to call Oracle Support at 1.800.223.1711. An Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process. Information about TRS is available at, and a list of phone numbers is available at

Related Documents

For more information about working with Oracle OLAP, see these Oracle resources:


The following text conventions are used in this reference:

Convention Meaning
boldface Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace Monospace type indicates URLs, code in examples, text that appears on the screen, or text that you enter.

This reference presents OLAP DML syntax in a simple variant of Backus-Naur Form (BNF) that includes the following symbols and conventions.

Symbol or Convention Meaning
[ ] Brackets enclose optional items.
{ } Braces enclose items only one of which is required.
| A vertical bar separates alternatives.
... Ellipsis points show that the preceeding syntactic element can be repeated
delimiters Delimiters other than brackets, braces, vertical bars, and ellipses must be entered as shown
italics Words appearing in italics are placeholders for which you must substitute a name or a value. Words that are not in italics are keywords. They must be typed as shown.