[Mondrian] NON EMPTY + exception
Julian Hyde
jhyde at pentaho.org
Wed Dec 12 02:54:37 EST 2007
Heed the error message "join does not have alias" - check all <Join>
elements in your schema and make sure that specify leftAlias and rightAlias,
to make the join unambiguous.
_____
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Agustin Campos
Sent: Tuesday, December 11, 2007 11:15 PM
To: Mondrian developer mailing list
Subject: [Mondrian] NON EMPTY + exception
Hello all:
I am having a little problem with my cube. It has 3 dimensions.
The case is that, when I ask something like this:
select NON EMPTY Crossjoin(Hierarchize(Union({[Dim1].[All]},
[Dim1].[All].Children)), {[Dim2].[All]}) ON COLUMNS,
NON EMPTY {[Dim3].[All]} ON ROWS
from [MyCube]
and then, I expand Dim1 I get an exception like this:
SqlMemberSource.getMemberChildren: executing sql [ SQL query ], exec 46 ms,
exec+fetch 46 ms, 7 rows
com.tonbeller.jpivot.olap.model.OlapException:
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while
executing query: MDX query which should work
...
...
...
...
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error:
join does not have alias
...
...
...
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.
I remind: It ONLY happends when I ask for non empty cells. It DOES WORK when
they are allowd.
Thank you a lot:
Agustín
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20071211/c4353973/attachment.html
More information about the Mondrian
mailing list