Skip Headers
Oracle® OLAP DML Reference
10g Release 2 (10.2)

Part Number B14346-02
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
View PDF

Basic Syntactical Units of the OLAP DML

The basic syntactic units of the OLAP DML are:

OLAP DML commands, functions, options, programs, and properties are collectively referred to as OLAP DML statements. Part I, "OLAP DML Basics" introduces basic elements of the OLAP DML. The complete syntax of each statement, usage notes, and examples is provided in Part II, "Alphabetic Reference". Lists of statements, arranged by functional category are presented in Appendix A, "Statements by Functional Category".

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.

OLAP DML Options

An option is a special type of analytic workspace object that specifies the characteristic of some aspect of how Oracle OLAP calculates or formats data or what Oracle OLAP operations are activated. You cannot define your own options as part of a workspace. However, you can use any of the options that are defined as part of the Oracle OLAP DML. The options defined for the Oracle OLAP DML are outlined in "OLAP DML Options by Category".

Some options are read-only, while others are read/write options for which you can specify values. Read/write options have default values.

The general syntax for specifying and retrieving option values is shown in Table 1-1, "Syntax for Specifying and Retrieving Option Values".

Table 1-1 Syntax for Specifying and Retrieving Option Values

Action Syntax

To specify an option value

option-name = value

To display an option value

SHOW option-name

To retrieve an option value into a predefined variable

variable-name = option-name


OLAP DML Properties

A property is a named value that is associated with a definition of an analytic workspace object. You name, create, and assign properties to an object using a PROPERTY statement.

Properties that begin with a $ (dollar sign) are recognized by Oracle OLAP as system properties. You assign system properties to objects the same way that you create other properties; however, you must give them the appropriate name in order for Oracle OLAP to recognize them.

Some system properties are key to the use of the OLAP DML. For example there are system properties that you can use in place of keywords in DML statements. These system properties are listed in"System Properties by Category" and documented as reference topics in Part II, "Alphabetic Reference".

OLAP DML Commands and Functions

Most OLAP DML statements are either OLAP DML commands and functions. OLAP DML commands and commands work in much the same way as commands and functions in other programming languages—the one exception is the looping nature of OLAP DML commands and functions discussed in "Looping Nature of OLAP DML Statements".

OLAP DML Commands

Many OLAP DML statements are commands that perform complex actions. Some of these commands are data definition commands that you use to create an analytic workspace or define objects within an analytic workspace. Data definition commands are introduced in "Creating New Workspaces and Objects".

Other OLAP DML commands are complex data manipulation commands. For example, you can use the OLAP DML SQL command to embed SQL statements in an OLAP DML program in order to copy data from relational tables into analytic workspace data objects, or you can use the AGGREGATE command to calculate summary data. You can also augment the functionality of the OLAP DML by writing an OLAP DML program for use as a command.

OLAP DML Functions

Most of the OLAP DML functions are text or calculation functions. For tables listing these standard functions, see:

"Text Functions"
"Date and Time Functions"
"General Numeric Functions"
"Financial Functions"
"Statistical Functions"
"Time-Series Functions"
"Aggregation Functions"
"Data Type Conversion"

Other OLAP DML functions return more complex information. For example, the OLAP DML provides the AW function that you can use to retrieve many different types of information about an analytic workspace and the AGGREGATE function that you can use to calculate aggregate data on-the-fly at user request.

You can also augment the functionality of the OLAP DML by writing an OLAP DML program for use as a function.

OLAP DML Programs

Some OLAP DML statements are actually the names of OLAP DML programs provided as part of the OLAP DML. Some of these programs produce reports that you can print or see online. For example, the AWDESCRIBE program produces a report that consists of a summary page; an alphabetic list of analytic workspace objects showing name, type, and description; and a list of object definitions by object type. Other programs provided as part of the OLAP DML perform standard calculations of use to programmers and database administrators. For example, VALSPERPAGE program calculates the maximum number of values for a variable of a given width that will fit on one analytic workspace page. You execute programs provided as part of the OLAP DML the same way that you do any other OLAP DML statement.

You can also write your own OLAP DML programs to augment the functionality of the OLAP DML as described in Chapter 7, "Programs".