Mondrian 2.4.2 doesn’t return an error when crossjoining members of the same dimension.
For example the following MDX query works in Mondrian but fails in MSAS 2000 ("duplicate dimensions across independent axes" error):
) on 0 from Sales
Placing the same dimension on different axes (which theoretically should cause similar result) causes parser error in Mondrian.
Julian Hyde wrote:
"Mondrian can detect that issue at validate time, and it should. There's another case to the same bug where mondrian cannot detect the duplicate dimensions until runtime, e.g. crossjoin(dimensions(1).currentmember, dimensions(1).children)"
The above case is covered by the following MDX which also fails in MSAS but succeedes in Mondrian:
, dimensions(1).children) on 0 from Sales