Description:
This function is used to return the cross product of one or more sets.
Syntax:
Crossjoin(Set_Expression1 ,Set_Expression2 [,...n] )
Set_Expression1 * Set_Expression2 [* ...n]
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:
| Code Block | ||
|---|---|---|
| ||
SELECT
[Measures].[Internet Order Quanlity] on 0,
NONEMPTY(CROSSJOIN({[Product].[Product Categories].children},
{[Customer].[Geography].[State-Province].Members}
), [Measures].[Average RateM]
) ON 1
FROM [AdventureWorksMF] |