[Mondrian] NON EMPTY + exception

Julian Hyde jhyde at pentaho.org
Wed Dec 12 03:09:51 EST 2007


An error stack would help. I would like to see where
MondrianDef.Join.getAlias() is being called from.
 
I am guessing you have a snowflake schema?
 
Also, you should be able to work around this problem by setting
mondrian.native.nonempty.enable=false in mondrian.properties.
 
Julian


  _____  

From: Agustin Campos [mailto:aguscampos at gmail.com] 
Sent: Wednesday, December 12, 2007 12:04 AM
To: jhyde at pentaho.org; Mondrian developer mailing list
Subject: Re: [Mondrian] NON EMPTY + exception


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/8392c159/attachment.html 


More information about the Mondrian mailing list