AddCalculatedMembers (MDX)

Returns a set generated by adding calculated members to a specified set.

Syntax

AddCalculatedMembers(Set_Expression) 

Arguments

  • Set_Expression
    A valid Multidimensional Expressions (MDX) expression that returns a set.

Remarks

By default, MDX excludes calculated members when it resolves set functions. The AddCalculatedMembers function examines the set expression specified in Set_Expression, and includes calculated members that are siblings of the members contained within the scope of that set expression.

Note

This function can be used only with one-dimensional set expressions.

Examples

The following example demonstrates the use of this function.

-- This query returns the calculated members for the cube
-- by retrieving all members, and then excluding non-calculated members.
SELECT 
   AddCalculatedMembers(
      {[Measures].Members}
      )-[Measures].Members ON COLUMNS,
   [Product].[Product Name].Members ON ROWS
FROM [Adventure Works] 

The following example returns the Measures.[Unit Price] member, in addition to all the calculated members in the Measures dimension, from the Adventure Works cube.

SELECT
   AddCalculatedMembers({Measures.[Unit Price]}) ON COLUMNS,
   Product.Product.Children ON ROWS
FROM 
   [Adventure Works]

See Also

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.