<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16587" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=286335007-12122007><FONT face=Verdana
color=#000080 size=2>Heed the error message "<FONT face="Times New Roman"
color=#000000 size=3>join does not have alias</FONT>" - check all <Join>
elements in your schema and make sure that specify leftAlias and rightAlias, to
make the join unambiguous.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Agustin
Campos<BR><B>Sent:</B> Tuesday, December 11, 2007 11:15 PM<BR><B>To:</B>
Mondrian developer mailing list<BR><B>Subject:</B> [Mondrian] NON EMPTY +
exception<BR></FONT><BR></DIV>
<DIV></DIV>Hello all:<BR><BR>I am having a little problem with my cube. It has
3 dimensions.<BR><BR>The case is that, when I ask something like
this:<BR><BR>select NON EMPTY Crossjoin(Hierarchize(Union({[Dim1].[All]},
[Dim1].[All].Children)), {[Dim2].[All]}) ON COLUMNS, <BR> NON EMPTY
{[Dim3].[All]} ON ROWS<BR>from [MyCube]<BR><BR>and then, I expand Dim1 I get
an exception like this:<BR><BR>SqlMemberSource.getMemberChildren: executing
sql [<SPAN style="FONT-STYLE: italic"> SQL query</SPAN> ], exec 46 ms,
exec+fetch 46 ms, 7 rows<BR>com.tonbeller.jpivot.olap.model.OlapException:
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while
executing query: <SPAN style="FONT-STYLE: italic">MDX query which should work
</SPAN><BR clear=all><BR>...<BR>...<BR>...<BR>...<BR><BR>Caused by:
mondrian.olap.MondrianException: Mondrian Error:Internal error: join does not
have alias<BR>...<BR>...<BR>...<BR><BR>Do you have any idea about what could
cause this problem? I know that I have not sent the complete log but, I hope
this could help to troubleshoot the problem. <BR><BR>I remind: It ONLY
happends when I ask for non empty cells. It DOES WORK when they are
allowd.<BR><BR><BR>Thank you a
lot:<BR><BR>Agustín<BR></BLOCKQUOTE></BODY></HTML>