| Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
| Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
This chapter contains the following topics:
One topic for each of the OLAP DML commands that begins with the letters A - G, beginning with ACQUIRE.
Reference topics for the remaining OLAP DML commands appear in alphabetical order in Chapter 10, "OLAP DML Commands: H-Z".
For other OLAP DML reference topics, see Chapter 4, "OLAP DML Properties", Chapter 5, "OLAP DML Options", Chapter 7, "OLAP DML Functions: A - K", and Chapter 8, "OLAP DML Functions: L - Z".
OLADM722OLAP DML commands work in much the same way as commands in other programming languages—the one exception is the looping nature of OLAP DML commands as discussed in "OLAP DML Statements Apply to All of the Values of a Data Object".
Many OLAP DML commands perform complex actions. Some of these commands are data definition commands like the AW command which you use to create an analytic workspace and the DEFINE command which you use to define objects within an analytic workspace. Other OLAP DML commands are data manipulation commands. For example, you can use the OLAP DML SQL command to embed SQL statements in an OLAP DML program to copy data from relational tables into analytic workspace data objects, or you can use the AGGREGATE command to calculate summary data. Additionally, the DEFINE, MAINTAIN, PROPERTY, SET (=) UPDATE, and AW commands are recognized by Oracle OLAP as events that can trigger the execution of OLAP DML programs. (See "Trigger Programs" for more information.)
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.Additionally, you can augment the functionality of the OLAP DML by writing an OLAP DML program for use as a command.
A B C D E F G H I L M O P R S T U V W Z
OLADM2065OLAP Cube and Cube Dimension Modification Commands
OLADM2066Aggregation Commands
OLADM2067Allocation Commands
OLADM2068Assigment Commands
OLADM2069Debugging Commands
OLADM2070Analytic Workspace Object Definition Commands
OLADM2071Dimension Status Commands
OLADM2072Forecast and Regression Commands
OLADM2073Date Formatting Commands
OLADM2074Formula Commands
OLADM2075Analytic Workspace Management Commands
OLADM2076Analytic Workspace Multiwriter Management Commands
OLADM2077File Management Commands
OLADM2078Data Model Commands
OLADM2079Programming Commands
OLADM2080Reporting Commands
OLADM2081Save and Restore Value Commands
OLADM2082Sorting Commands
OLADM2083Spreadsheet Commands
OLADM2084SQL Execution Commands
OLADM2085OLAP DML Statement Edit Commands
|
 Copyright © 1994, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
HTML