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.