Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-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
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

A.9 Aggregation Statements

Table A-16, "General Aggregation Statements" lists the OLAP DML statements that support data aggregation. The OLAP DML also provides the aggregation functions listed in Table A-13, "Aggregation Functions".

Table A-16 General Aggregation Statements

Statement Description
AGGMAP
Marks the aggmap as anaggregation specification and enters or changes the aggregation specification.
AGGMAP ADD or REMOVE model
Adds or removes a model from a previously defined aggmap object of type AGGMAP.
AGGMAP SET
Specifies the default aggmap for a variable.
AGGMAPINFO
Returns information about the specification for an aggmap object in your analytic workspace.
AGGREGATE command
Calculates data for one or more variables as specified by the specified aggmap object.
AGGREGATE function
Calculates the data of a variable at runtime, in response to a user's request. Often used as the expression of a $NATRIGGER property.
AGGREGATION
Within a model, creates a custom aggregation.
ALLCOMPILE
A program that compiles every compilable object in your current analytic workspace, one at a time.
COMPILE
Generates compiled code for a compilable object, such as an OLAP DML program, formula, model, or aggmap without running it and saves the compiled code in the analytic workspace.
DEFINE AGGMAP
Creates a new aggmap object.
MAINTAIN ADD
Adds a new temporary calculated member as a custom aggregation to a dimension or adds new values to a non-concat dimension or a composite.
PARTITIONCHECK
Identifies whether an aggmap object is compatible with the partitioning specified by a partition template object.
ROLLUP
Without the use of an aggmap object, calculates totals for a hierarchy of values where each level of the hierarchy is an aggregation of the values in the level below it and the members of the hierarchy are contained in a single "embedded-total" dimension, so called because it contains both a detail (lowest) level and levels that are aggregations of lower levels.
TCONVERT
Converts data from one dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR to another dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR. You can specify an aggregation method or an allocation method to use in the conversion.