ExtractOthers (MDX+)

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

Parameters

Return

set

Description

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

Examples

ExtractOthers( { ([Geography].[Geo].[Canada],[Geography].[Economy].[Canada])} * {[Measures].[Amount]}, [Measures] )

{
  ( [Geography].[Geo].[Country].[Canada], [Geography].[Economy].[Country].[Canada] )
}

{([Geography].[Geo].[Canada],[Geography].[Economy].[Canada])}

ExtractOthers( { ([Geography].[Geo].[Canada],[Geography].[Economy].[Canada])}+{([Geography].[Geo].[Canada],[Geography].[Economy].[Canada])}, [Geography].[Geo] )

{ 
  [Geography].[Economy].[Country].[Canada]
}

{[Geography].[Geo].[Canada]}

ExtractOthers( {([Geography].[Geo].[Canada],[Geography].[Economy].[Canada])}, [Geography].[Geo],[Geography].[Economy] )

{}

Special Examples (errors, null, ...)

ExtractOthers( {}, [Geography].[Geo] )

{}

Since Version

4.7

XMLA Properties

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