[Mondrian] Illegal access to members of hierarchy error
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.
> On 12/03/2013 05:02 AM, Dejan Gambin wrote:
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian