CROSSJOIN

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

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 Order Quanlity] on 0,
  NONEMPTY(CROSSJOIN({[Product].[Product Categories].children}, 
                           {[Customer].[Geography].[State-Province].Members} 
                          ), [Measures].[Average RateM]
                 ) ON 1
FROM [AdventureWorksMF]