Professional SQL Server™ Analysis Services 2005 with MDX

A.3. Function and Operator Reference

A.3.1. A

AddCalculatedMembers(set) Returns: set

Extension: AS2000, AS2005

By default, when a set of members is specified using a function that retrieves a set based on metadata (such as .Members, .Children, Descendants(), and so on), only base members are returned, even though calculated members may be within that range. The AddCalculatedMembers() function adds in all of the calculated members that are siblings of the members specified within the set. Each calculated member that was not already in the set is added in database order after its last sibling member in the set. The set is limited to only one dimension. Note that this function adds all calculated members defined, whether they were defined by CREATE MEMBER at the server or at the client, or in the query through WITH MEMBER.

See also: .AllMembers, StripCalculatedMembers()

Aggregate(set [, numeric value expression]) Returns: number

Standard

This function aggregates the cells formed by the set according to the default aggregation operator for any measures in context. If a numeric value expression is provided, then this function sums the expression's set of values over the cells. In the event that the cells are of a base measure, the aggregation function specified for the measure is used. In AS2000, if the aggregation functions of the measure are COUNT, MIN, or MAX, then COUNT, MIN, or MAX, respectively, is the aggregation operation used; otherwise, the aggregation operation used is ...