Allow more than 2 sets in MDX Crossjoin() function

Tim_Faitsch · May 12, 2023 1:53PM

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 · May 12, 2023 7:49PM

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

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

Oracle Analytics Cloud and Server Idea Lab