ExtractOthers (MDX+)

Returns a set of tuples extracting the not specified hierarchies (others as specified)


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




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

This function works as the Extract() function but by extracting the 'others' hierarchies. For example, if you want to remove the measures from your set-expression you would use [Measures] as second parameter.

Note that this function removes duplicate elements.

See Also

Extract Crossjoin


Special Examples (errors, null, ...)

Since Version


XMLA Properties

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