| title | AddCalculatedMembers (MDX) |
|---|---|
| description | AddCalculatedMembers (MDX) |
| ms.date | 02/17/2022 |
| ms.service | sql |
| ms.subservice | analysis-services |
| ms.topic | reference |
| ms.custom | 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
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]