Aggregation Statements

Table: General Aggregation Statements lists the OLAP DML statements that support data aggregation. The OLAP DML also provides the aggregation functions listed in Table: Aggregation Functions.

General Aggregation Statements

Statement	Description
AGGCOUNT	Retrieves the values of the Aggcount variable associated with the specified variable. Oracle OLAP use the Aggcount variable to store the non-`NA` counts of the number of leaf nodes that contributed to aggregate values calculated using one of the average operators.
AGGMAP	Marks the aggmap as an aggregation 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.
AGGROPS	Returns the keywords for all of the aggregation operators that you can specifies in a RELATION (for aggregation) statement
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.
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.