Preface

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

http://www.oracle.com/accessibility/

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.

Structure

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 15, " INF_STOP_ON_ERROR to LIKEESCAPE"

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 21, " RESERVED to SPARSEINDEX "

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.

Conventions

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.