Allow more than 2 sets in MDX Crossjoin() function

Tim_Faitsch

Nesting multiple Crossjoin functions makes MDX code very difficult to read. It seems unnecessary. Instead, allow more than two sets in a Crossjoin().

Existing:

Crossjoin({Set 1}, Crossjoin({Set 2}, Crossjoin({Set 3}, {Set 4})))

New:

Crossjoin({Set 1}, {Set 2}, {Set 3}, {Set 4})

Tim_Faitsch

Microsoft allows this. They also allow a very concise syntax short-cut:

{Set 1} * {Set 2} * {Set 3}

https://learn.microsoft.com/en-us/sql/mdx/crossjoin-mdx?view=sql-server-ver16