Skip to main content
Version: I2024.2.x

ExtractMember

Returns a specific tuple from a set.

Syntax

ExtractMember(Set_Expression, Index)

Input parameters

Set_Expression

An MDX expression that returns a set.

Index

Zero-based index to determine which tuple of the set is returned.

Return value

The member of the set specified by the Index value.

Example

The following expression extracts the first tuple from the specified set:

ExtractMember( Descendants( [DateCustom].[StandardMonth].CurrentMember, [DateCustom].[StandardMonth].[Month] ), 0 )