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

Creating OLAP DML Programs

An OLAP DML program is written in the OLAP DML. It acts on data in the analytic workspace and helps you accomplish some workspace management or analysis task. You can write OLAP DML programs to perform tasks that you must do repeatedly in the analytic workspace, or you can write them as part of an application that you are developing.

To create an OLAP DML program, take the following steps:

  1. Issue a DEFINE PROGRAM statement to define the program object. When the program that you are defining will be used is a function, include the datatype or the dimension argument.

  2. Add contents to the program that specify the processing that you want performed as described in "Specifying Program Contents".

  3. Compile the program as described in "Compiling Programs".

  4. Test and debug the program as described in "Testing and Debugging Programs".

  5. Execute the program as described in "Executing Programs".