Create offline cube files (.cub) with OlapCube. Download Now!

table of contents


Returns a calculated value using the appropriate aggregate function, based on the aggregation type of the member.


Aggregate(«Set»[, «Numeric Expression»])


This function cannot be used on calculated members.


In the following expression, the calculated member Total is displayed first against the measure SumSales and then against the measure MaxSales. In the former case, Total is calculated by adding (with Sum). In the latter case, Total is calculated by taking the maximum.

WITH MEMBER Geography.Total AS  'AGGREGATE({USA, France})'
SELECT {Measures.SumSales, Measures.MaxSales} ON COLUMNS,
      {USA, France, Total} ON ROWS
FROM SalesCube
WHERE ([1998])