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 functions that begins with the letters A - K, beginning with ABS.
Reference topics for the remaining OLAP DML functions appear in alphabetical order in Chapter 8, "OLAP DML Functions: L - Z".
For other OLAP DML reference topics, see Chapter 4, "OLAP DML Properties", Chapter 5, "OLAP DML Options", Chapter 9, "OLAP DML Commands: A-G", and Chapter 10, "OLAP DML Commands: H-Z".
OLADM458OLAP functions work in much the same way as functions work in other programming languages. They initiate action and return a value. The one exception is the looping nature of OLAP DML functions as discussed in "OLAP DML Statements Apply to All of the Values of a Data Object".
Most of the OLAP DML functions are standard text and calculation functions. Other OLAP DML functions return more complex information. For example, the OLAP DML provides the AW and OBJ functions that you can use to retrieve many different types of information about an analytic workspace and its objects and the AGGREGATE function that you can use to calculate aggregate data on-the-fly at user request.
Additionally, you can augment the functionality of the OLAP DML by writing an OLAP DML program for use as a function.
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.A B C D E F G H I J K L M N O P Q R S T U V W Y
The OLAP DML provides the typical numeric and text functions:
It also has functions that are unique to its data model:
OLADM1465Analytic workspace and object information functions
OLADM1466Aggregation, allocation, and model specification functions
OLADM1467Conversion functions
OLADM1468System and Database information functions
OLADM1469Datetime functions
OLADM1470Date-only functions
OLADM1471Financial functions
OLADM1472File management functions
OLADM1473NA functions
OLADM1474Numeric (general) functions
OLADM1475Numeric aggregation functions
OLADM1476Object value retrieval functions
OLADM1477Program argument and context functions
OLADM1478Reporting functions
OLADM1479Statistical and forecasting functions
OLADM1480Status manipulation functions
OLADM1481Text functions
OLADM1482Time-series functions