AddCalculatedMembers (MDX)

 

Updated: March 2, 2016

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

  
AddCalculatedMembers(Set_Expression)   

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

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.

System_CAPS_ICON_note.jpg Note


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

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  
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  
FROM   
   [Adventure Works]  

MDX Function Reference (MDX)

Community Additions

ADD
Show: