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