* (Crossjoin) (MDX)
Updated: March 2, 2016
Performs a set operation that returns the cross product of two sets.
Set_Expression * Set_Expression
A valid Multidimensional Expressions (MDX) expression that returns a set.
A set that contains the cross product of both specified parameters.
The * (Crossjoin) operator is functionally equivalent to the Crossjoin function.
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])