EXTRACTOTHERS
Description:
This function is used to return a set of tuples extracting the not specified hierarchies (others as specified).
Syntax:
ExtractOthers(Set_Expression, Hierarchy_Expression1 [,Hierarchy_Expression2, ...n] )
Return Type:
SET
Parameters:
Parameter | Description |
|
|---|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
|
Hierarchy_Expression1 | It is a valid MDX expression that returns a hierarchy. | It is a valid MDX expression that returns a set. |
Hierarchy_Expression2 | It is a valid MDX expression that returns a hierarchy. |
|
Example:
select
[Measures].[Internet Order Count] on columns,
EXTRACTOTHERS(([Customer].[Geography].[Country],[Product].[Product Categories].[Category]), [Product].[Product Categories]) on rows
FROM [AdventureWorksMF_latest]