Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

AddCalculatedMembers (MDX)

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.

Note 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]

Community Additions

ADD
Show:
© 2014 Microsoft