[Mondrian] Illegal access to members of hierarchy error

Matt Campbell mcampbell at pentaho.com
Tue Dec 3 08:54:17 EST 2013


Hi Dejan,
Can you repost this question in the Mondrian group in the forums ( http://forums.pentaho.com<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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20131203/9a01d32b/attachment.html 


More information about the Mondrian mailing list