OLAP Server User Guide
MDX Documentation
MDX Functions Reference

Aggregate

(MDX)

Aggregates values for the members' measures.

Parameters

Name Type Cardinality Default value
  set-expression  one   
  numeric-expression  zero-one  [Measures].currentMember 

Return

numeric-value

Description

Aggregates values for the specified members over the numeric expression. The aggregation operator derives from the measure.

If no numeric-expression was specified the current measure is taken.

See Also

Sum Max Min Avg

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.