Crossjoin is a function which, for obvious reasons, is dear to my heart
. It’s been at least a year since I last found a feature in AS2005 MDX that I wasn’t aware of, but the other day I found out that the Crossjoin function can now take more than two sets as parameters, much in the same way that NonEmptyCrossjoin can. Here’s an example:
measures.[internet sales amount] on 0,
[Date].[Day Name].[Day Name].members,
[Date].[Day of Week].[Day of Week].members,
from [Adventure Works]
Not exactly revolutionary (and anyway I use the * operator instead nowadays) but fun to note.