Hi Friends,

CROSSJOIN is a very powerful function in MDX, returning you the cross product of one more sets. Let us see some examples:

Example 1: Returns on the cross join of Year & month on rows axis

Example 2: You can definitely add more measures to your code above:

Example 3: Things get interesting when you are cross-joining on both the axes:

Example 4: The beast of all – CROSSJOIN within CROSSJOIN

There are alternate syntax also for CROSSJOIN as follows:

Example 5: Alternate syntax