[Mondrian] Illegal access to members of hierarchy error

Meral Ozkaya meral.ozkaya at gmail.com
Tue Dec 3 09:12:39 EST 2013

Do you try use "NON EMPTY"

2013/12/3 Matt Campbell <mcampbell at pentaho.com>

> Hi Dejan,
> Can you repost this question in the Mondrian group in the forums (
> http://forums.pentaho.com)?  That's a better place for questions like
> this, and others might chime in with similar experiences.
> Also, when you post, attach your schema and the full stack trace of the
> error you saw.  It does sound like there's a bug involving native
> evaluation here, but it's very hard to figure out what's going on without
> the stacktrace.
> Thanks,
> Matt
> On 12/03/2013 05:02 AM, Dejan Gambin wrote:
> Hi,
>  I am struggling with it for a couple of days. I thought about reporting
> on JIRA but not sure it's a bug, so maybe someone can help
>  I have a dimension with one parent-child hierarchy. Closure table is
> created in Kettle with closure generator and everything seems ok. But
> queries involving crossjoin of this hierarchy members (All member works ok)
>  with any other dimension/members raises "MondrianException: Mondrian
> Error:Internal error: Illegal access to members of hierarchy
> my_parent_child_hierarchy" error.
>  The error seems to be related to role access but I have a role with all
> the privileges to all the cubes in schema. The most interesting thing -
> when I set mondrian.native.crossjoin.enable to false everything works ok
> (but I can't do that because I have some other crossjoin queries which
> require this parameter to be true otherwise I get OutOfMemory error).
>  I have also tried to reproduce the problem with foodmart database (using
> parent-child hierarchy from Employees dimension) but unfortunatelly I
> couldn't as it all works ok
>  I would appreciate any help as this is becoming pretty critical to me
>  Thanks very much
>  regards, dejan
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

Meral Özkaya
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20131203/f0dcb234/attachment.html 

More information about the Mondrian mailing list