CrossJoin

The MDX CrossJoin function returns the cross-product of two sets from different dimensions.

Syntax

CrossJoin ( set1, set2 )

Arguments

set1

A set to cross with set2.

set2

A set to cross with set1. Must not include any dimension used in set1.

Notes

Examples

select
{ (measure.[sales amount]), (measure.[sales quantity]) } on 10,
crossjoin(members([Store Type], LEAFS), members([Payment Method], ALL)) on 100
from [Online Store];

			sales amount	sales quantity
Platform Self-operated Store	ALL	2900984	302741
Platform Self-operated Store	Credit Card	966945	101034
Platform Self-operated Store	Debit Card	967021	100552
Platform Self-operated Store	Account Balance	967018	101155
Platform Self-operated Store	Other	0	0
Brand Flagship Store	ALL	2899837	302895
Brand Flagship Store	Credit Card	967012	101209
Brand Flagship Store	Debit Card	966293	100722
Brand Flagship Store	Account Balance	966532	100964
Brand Flagship Store	Other	0	0
Other	ALL	2899778	302948
Other	Credit Card	966646	101168
Other	Debit Card	966902	100849
Other	Account Balance	966230	100931
Other	Other	0	0