* (Crossjoin) (MDX)

Performs a set operation that returns the cross product of two sets.

Syntax

Set_Expression * Set_Expression

Parameter

  • Set_Expression
    A valid Multidimensional Expressions (MDX) expression that returns a set.

Return Value

A set that contains the cross product of both specified parameters.

Remarks

The * (Crossjoin) operator is functionally equivalent to the Crossjoin function.

Examples

The following example demonstrates the use of this operator.

-- This query returns the gross profit margin for product types
-- and reseller types crossjoined by year.
SELECT 
    [Date].[Calendar].[Calendar Year].Members *
    [Reseller].[Reseller Type].Children ON 0,
    [Product].[Category].[Category].Members ON 1
FROM
    [Adventure Works]
WHERE
    ([Measures].[Gross Profit Margin])

See Also

Reference