<div dir="ltr">Do you try "NON EMPTY" as manually for other crossjoins. I think They have very large
data-sets and you must use NON EMPTY. You set
mondrian.native.crossjoin.enable to false.<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/12/3 Matt Campbell <span dir="ltr"><<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<br>
Hi Dejan,<br>
Can you repost this question in the Mondrian group in the forums (
<a href="http://forums.pentaho.com/" target="_blank">http://forums.pentaho.com</a>)?
That's a better place for questions like this, and others might
chime in with similar experiences.<br>
<br>
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.<br>
<br>
Thanks,<br>
Matt<br>
<br>
<div>On 12/03/2013 05:02 AM, Dejan Gambin
wrote:<br>
</div>
<blockquote type="cite">
Hi,
<div><br>
</div>
<div>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</div>
<div><br>
</div>
<div>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 "<span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:left;font-style:normal;display:inline!important;font-weight:normal;float:none;line-height:16px;color:rgb(34,34,34);text-transform:none;font-size:11px;white-space:normal;font-family:'Helvetica Neue',Arial,Helvetica,sans-serif;word-spacing:0px">MondrianException:
Mondrian Error:Internal error: Illegal access to members of
hierarchy my_parent_child_hierarchy" </span>error. </div>
<div><br>
</div>
<div>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).</div>
<div><br>
</div>
<div>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</div>
<div><br>
</div>
<div>I would appreciate any help as this is becoming pretty
critical to me</div>
<div><br>
</div>
<div>Thanks very much</div>
<div><br>
</div>
<div>regards, dejan</div>
</blockquote>
<br>
</div>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Meral Özkaya
</div>