A number of aggregation functions are supported, including several of a statistical nature. Note that aggregation functions are not allowed in a Dimension value expression, but may be used in a Variable expression that is being dimensioned. They are not allowed in a Where clause or Qualify clause either. Double-click on Aggregations to view the supported functions.
Teradata Database
The following figure shows the Aggregate functions available when connected to a Teradata database.
Variable Creation > Input > Variables: SQL Elements pane - Aggregation (Teradata)
Aster Database
The following figure shows the Aggregate functions available when connected to an Aster database.
Variable Creation > Input > Variables: SQL Elements pane - Aggregation (Aster)
