Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
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

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 define and manipulate analytic workspace objects. Part I briefly describes how to use the OLAP DML. Part II consists of a reference topic for each of the OLAP DML statements.

Intended Audience

This manual is intended for programmers and database administrators who create and modify analytic workspaces and analytic workspace objects using the OLAP DML.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. 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. 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 additional information, visit the Oracle Accessibility Program Web site at
Accessibility of Code Examples in Documentation

JAWS, a Windows screen reader, 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, JAWS 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.


This document is structured in the following three parts.

Part I, " Using the OLAP DML "

Introduces the basic concepts of analyzing data using the OLAP DML.

Chapter 1, " Introduction to the OLAP DML"
Provides an introduction to the OLAP DML and provides some basic information that you need to know to effectively use the OLAP DML.
Chapter 2, " Data Types and Operators"
Introduces the OLAP DML data types and operators.
Chapter 3, " Expressions "
Explains how to create and use OLAP DML expressions.
Chapter 4, " Formulas, Aggregations, Allocations, and Models"
Explains how to create and execute OLAP DML calculation specification objects.
Chapter 5, " OLAP DML Programs"
Explains how to create, test, and execute OLAP DML programs.

Part II, " Alphabetic Reference "

Consists of a topic for each of the OLAP DML statements, arranged alphabetically. Each topic provides a description, syntax, notes, and example for an OLAP DML statement.

Chapter 6, " $AGGMAP to AGGMAP "
Chapter 7, " AFFMAPINFO to ARCCOS "
Chapter 8, " ARCSIN to CHARLIST"
Chapter 9, " CHGDFN to DDOF"
Chapter 10, " DECIMALCHAR to DELETE"
Chapter 11, " DEPRDECL to EXISTS"
Chapter 12, " EXPORT to FILEMOVE"
Chapter 13, " FILENEXT to FULLDSC"
Chapter 14, " GET to IMPORT"
Chapter 16, " LIKENL to MAX"
Chapter 17, " MAXBYTES to MODTRACE"
Chapter 18, " MONITOR to NVL2"
Chapter 19, " OBJ to QUAL"
Chapter 20, " RANDOM to REPORT"
Chapter 22, " SQL to STATVAL "
Chapter 23, " STDDEV to TRACKPRG"
Chapter 24, " TRAP to ZSPELL"

Part III, "Appendixes "

Provides summary information about OLAP DML statements.

Appendix A, " Functions and Commands by Functional Category"
This appendix lists the OLAP DML functions, commands, and programs by functional category.
Appendix B, " OLAP DML Statement Changes"
This appendix provides information about recent changes to the OLAP DML.

Related Documents

The following documents provide additional information about using Oracle OLAP:


The following conventions are used in this manual.

Convention Meaning
... Horizontal ellipsis points in examples mean that information not directly related to the example has been omitted.

Horizontal ellipsis points in syntax indicate a repeating argument or clause.

boldface text Boldface type in text indicates a term defined in the text.
italic text Italicized type in text indicates emphasis.

Italicized type in syntax indicates or a user-supplied name.

Brackets in syntax enclose optional clauses from which you can choose one or none.
Braces in syntax enclose required clauses from which you must chose one.