fbpx

UpperCrossjoin (MDX+)

Returns the upper cross product of the specified sets.

Parameters

Name Type Cardinality Default value
  set-expression  one   
  set-expression  zero-one   

Return

set

Description

Returns a list of tuples as a result of the upper cross product of the specified sets.

UpperCrossjoin(A,B) = { (Ai,Bj) }, for all i,j where j > i

and

UpperCrossjoin(A) = { (Ai,Aj) }, for all i,j where j > i

Same hierarchy on both tuple set is allowed. No autoexist is performed on the tuples.

If you see A and B as a matrix with in the cells tuples, it will return the upper triangle of the matrix
without the diagonal. It is an easy function to get all combinations

See Also

Crossjoin

Examples

Since Version

5.0

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.