Extract (MDX)

Returns a set of tuples from extracted hierarchy elements.

Syntax

Extract(Set_Expression, Hierarchy_Expression1 [,Hierarchy_Expression2, ...n] )

Arguments

• Set_Expression
  A valid Multidimensional Expressions (MDX) expression that returns a set.

• Hierarchy_Expression1
  A valid Multidimensional Expressions (MDX) expression that returns a hierarchy.

• Hierarchy_Expression2
  A valid Multidimensional Expressions (MDX) expression that returns a hierarchy.

Remarks

The Extract function returns a set that consists of tuples from the extracted hierarchy elements. For each tuple in the specified set, the members of the specified hierarchies are extracted into new tuples in the result set. This function always removes duplicate tuples.

The Extract function performs the opposite action of the Crossjoin function.

See Also

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
17 July 2006	Changed content: Updated syntax and arguments to improve clarity.