Crossjoin - MDX Operator Reference
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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for