all <join ...> has their own alias (tables' names on database) <br><join leftAlias... rightAlias... ><br> < table name="table1" /><br> <join ...><br> ...<br> ....<br> </join>
<br></join><br><br>All <join > has their own alias (left and right). <br><Table ....> doesn't.<br><br>Thanks for your answer, but, do you have any more ideas?<br><br><br><br><div><span class="gmail_quote">
2007/12/12, Julian Hyde <<a href="mailto:jhyde@pentaho.org">jhyde@pentaho.org</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#000080" face="Verdana" size="2">Heed the error message "<font color="#000000" face="Times New Roman" 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="border-left: 2px solid rgb(0, 0, 128); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b> <a href="mailto:mondrian-bounces@pentaho.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mondrian-bounces@pentaho.org</a>
[mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mondrian-bounces@pentaho.org</a>] <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><span class="e" id="q_116cd594056eb77a_1">
<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></span></div></blockquote></div>
<br>_______________________________________________<br>Mondrian mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">
http://lists.pentaho.org/mailman/listinfo/mondrian</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>Agustín Campos Muñoz<br><a href="http://www.acampos.net">http://www.acampos.net</a><br><br>Email: aguscamposENgmailPUNTOcom
<br> acamposENiiesPUNTOes<br>MSN Messenger: acampozENhotmailPUNTOcom<br>Skype: acamposnet