OLAP Server User Guide
MDX Documentation
MDX Functions Reference

Extract

(MDX)

Returns a set of tuples extracting the specified hierarchies

Parameters

Name Type Cardinality Default value
  set-expression  one   
  hierarchy-expression  one-n   

Return

set

Description

For each tuple in the specified set, this functions extracts the members of the specified hierarchies into a new tuple. These new tuples are combined into a new set returned by this function.

Note that this function removes duplicate elements.

See Also

ExtractOthers Crossjoin

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.