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.