[Mondrian] The same dimensions in crossjoin

[Anton Nikitin]

Done!

 

http://sourceforge.net/tracker/index.php?func=detail
<http://sourceforge.net/tracker/index.php?func=detail&aid=1807646&group_id=3
5302&atid=414613> &aid=1807646&group_id=35302&atid=414613

 

 

  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Julian Hyde
Sent: Thursday, October 04, 2007 8:53 PM
To: 'Mondrian developer mailing list'
Subject: RE: [Mondrian] The same dimensions in crossjoin

 

Yes, that's a bug. Please log it.

 

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). It should give a runtime error, but I'm not sure
that it does. Can you devise a query to test this scenario, compare with
ssas, and add to the bug.

 

Julian

 


  _____  


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Anton Nikitin
Sent: Thursday, October 04, 2007 7:27 AM
To: 'Mondrian developer mailing list'
Subject: [Mondrian] The same dimensions in crossjoin

It seems that I've found one bug:

 

Mondrian 2.4.2 doesn't complain about crossjoining members of the same
dimension.

 

For example the following query works in Mondrian but fails in MSAS 2000:

 

select
Crossjoin({[Product].defaultMember},{[Product].defaultMember.firstChild}) on
0 from Sales

 

Interesting that placing the same dimension on different axes (which
theoretically should cause similar result) causes parser error in Mondrian.

 

I haven't tested it but I assume this issue is also actual in case of using
different hierarchies of the same dimension in one MDX.

 

Please confirm this is a bug and I will add bug report to SourceForge.

 

Anton

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20071004/1c2331f7/attachment.html