Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

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