INTERSECT
Description:
This function is used to return the intersection of two input sets, optionally retaining duplicates.
Syntax:
Intersect(Set_Expression1 , Set_Expression2 [ , ALL ] )
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression1 | It is a valid MDX expression that returns a set. |
Set_Expression2 | It is a valid MDX expression that returns a set. |
Example:
SELECT [Measures].[Internet Sales Amount] ON COLUMNS, Intersect(TopCount([Product].[Product Categories].[Product].Members, 10, [Measures].[Internet Sales Amount]), Descendants([Product].[Product Categories].[Category].&[Bikes],[Product].[Product Categories].[Product])) ON ROWS FROM [AdventureWorksMF_ValueBased]