Crossjoin

Return to: Calculated Member Builder Function List

Returns the cross product of two sets.

Syntax

Crossjoin(«Set1», «Set2»)

Remarks

The order of tuples in the resulting set is as follows:

If «Set1» = {x1, x2,...,xn} and «Set2» = {y1, y2, ..., yn}, then Crossjoin(Set1, Set2) is:

{(x1, y1), (x1, y2),...,(x1, yn), (x2, y1), (x2, y2),...,

 (x2, yn),..., (xn, y1), (xn, y2),..., (xn, yn)}

Example

Crossjoin({[1994], [1995]}, {USA, Japan})

returns

{([1994], USA), ([1994], Japan), ([1995], USA), ([1995], Japan)}.

Alternate Syntax

«Set1» * «Set2»

Note This alternate syntax is a Microsoft® SQL Server™ OLAP Services multidimensional expression (MDX) extension to OLE DB 2.0 and later.