AddCalculatedMembers

previous page next page

Analysis Services

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

AddCalculatedMembers(«Set»)

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

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

Expression Returns

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]}`

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

previous page start next page