Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
AddCalculatedMembers
Collapse the table of content
Expand the table of content

AddCalculatedMembers

SQL Server 2000

AddCalculatedMembers

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

Syntax

AddCalculatedMembers(«Set»)

Remarks

This function includes only the calculated members that are siblings in the set.

Example

In the preceding diagram, the following functions return the following values.

Expression Returns
AddCalculatedMembers({GrandParent.Children})
{[Parent 1],[Parent 2],[Calculated member 0]}
AddCalculatedMembers({[Parent 1].Children})
{[Member 1.1], [Member 1.2], [Member 1.3], [Calculated member 1.4]}
AddCalculatedMembers({[Parent 2].[Member 2.1]})
{[Member 2.1], [Calculated member 2.4]}

Show:
© 2015 Microsoft