[Mondrian] NON EMPTY + exception

Agustin Campos aguscampos at gmail.com
Wed Dec 12 03:04:13 EST 2007


all <join ...> has their own alias (tables' names on database)
<join leftAlias... rightAlias... >
   < table name="table1" />
  <join ...>
       ...
      ....
   </join>
</join>

All <join > has their own alias (left and right).
<Table ....> doesn't.

Thanks for your answer, but, do you have any more ideas?



2007/12/12, Julian Hyde <jhyde at pentaho.org>:
>
>  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
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>


-- 
Agustín Campos Muñoz
http://www.acampos.net

Email: aguscamposENgmailPUNTOcom
           acamposENiiesPUNTOes
MSN Messenger: acampozENhotmailPUNTOcom
Skype: acamposnet
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20071212/1a9efd6f/attachment.html 


More information about the Mondrian mailing list