<div dir="ltr">Yes Matt, i do have it enabled. These are my native setttings:<div><br></div><div><div>mondrian.native.crossjoin.enable=true</div><div>mondrian.native.filter.enable=true</div><div>mondrian.native.nonempty.enable=true<span class="" style="white-space:pre"> </span></div>
<div>mondrian.native.topcount.enable=true</div><div>mondrian.native.ExpandNonNative=true</div><div>mondrian.native.EnableNativeRegexpFilter=true</div></div><div><br></div><div>I followed some indications on <a href="http://infocenter.pentaho.com/help/index.jsp?topic=%2Fperformance_tuning_guide%2Fconcept_mondrian_properties.html">http://infocenter.pentaho.com/help/index.jsp?topic=%2Fperformance_tuning_guide%2Fconcept_mondrian_properties.html</a> to set it to true. I supposed with those i'd have the optimal performance.</div>
<div><br></div><div>I can confirm that the error is gone when setting mondrian.native.ExpandNonNative=false.</div><div><br></div><div>Is there any major hit in performance for having it to false with large datasets, or does any of the other options depend on this one to work?</div>
<div><br></div><div>Thank you for opening the issue, and for your attention.</div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Mar 27, 2014 at 12:39 PM, Matt Campbell <span dir="ltr"><<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
<br>
Hi Hilario-<br>
I was able to reproduce what you were seeing by setting ExpandNonNative=true. Can you confirm you have that property set as well? (I believe that's the default setting in biserver)<br>
<br>
I've logged MONDRIAN-1964 for the issue.<br>
<br>
-matt<br>
<br>
________________________________________<br>
From: <a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a> [<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>] On Behalf Of Hilario Fernandes [<a href="mailto:hilario.fernandes@cortex-intelligence.com">hilario.fernandes@cortex-intelligence.com</a>]<br>
Sent: Thursday, March 27, 2014 6:39 AM<br>
To: Mondrian developer mailing list<br>
Subject: Re: [Mondrian] RolapNativeSet NPE<br>
<div class=""><br>
Thank you for your reply.<br>
<br>
I've tryed version 3.6.2 and 3.6.5 with the same results.<br>
<br>
Should i fill in a bug report? Under which project should i do it? I've opened bugs in the wrong place in the past, just want to make sure i put it on the right place this time!<br>
<br>
<br>
</div><div class="">On Wed, Mar 26, 2014 at 6:33 PM, Luc Boudreau <<a href="mailto:lucboudreau@gmail.com">lucboudreau@gmail.com</a><mailto:<a href="mailto:lucboudreau@gmail.com">lucboudreau@gmail.com</a>>> wrote:<br>
Looks like a bug.<br>
<br>
Which version is this? I vaguely remember seeing this before.<br>
<br>
Luc<br>
<br>
<br>
</div><div><div class="h5">On Wed, Mar 26, 2014 at 2:30 PM, Hilario Fernandes <<a href="mailto:hilario.fernandes@cortex-intelligence.com">hilario.fernandes@cortex-intelligence.com</a><mailto:<a href="mailto:hilario.fernandes@cortex-intelligence.com">hilario.fernandes@cortex-intelligence.com</a>>> wrote:<br>
Hi everyone,<br>
<br>
I'm implementing a system that creates mdx queries and passes these to Mondrian to be executed. During my tests I have found a problem when using mondrian.native.crossjoin.enable=true.<br>
<br>
If I try to do a query such as this:<br>
<br>
SELECT<br>
NON EMPTY {[Measures].[Price_SUM]} ON COLUMNS,<br>
NON EMPTY CrossJoin({Filter({[Brand].[Brand].Members}, [Brand].CurrentMember.Name MATCHES '(?i).*zzzzz.*')}, {[Fuel].[Fuel].Members}) ON ROWS<br>
FROM [Cars]<br>
<br>
<br>
Where we have a CrossJoin of a Filter over Brand members with the fuel members. The problem is that whenever the first argument of the CrossJoin is a filter that returns empty (no values matched) i get a NullPointerException from mondrian.<br>
<br>
<br>
java.lang.NullPointerException<br>
at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:186)<br>
at mondrian.olap.fun.CrossJoinFunDef$CrossJoinIterCalc.evaluateIterable(CrossJoinFunDef.java:177)<br>
at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:875)<br>
at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:700)<br>
at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:656)<br>
at mondrian.rolap.RolapResult.<init>(RolapResult.java:288)<br>
at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:671)<br>
at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)<br>
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)<br>
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621)<br>
<br>
<br>
Anyone has an idea of the problem?<br>
<br>
--<br>
Hilario Fernandes<br>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
</div></div><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><mailto:<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a>><br>
<div class=""><a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br>
<br>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
</div><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><mailto:<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a>><br>
<div class="im HOEnZb"><a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br>
<br>
<br>
<br>
--<br>
Hilario Fernandes<br>
</div><div class="HOEnZb"><div class="h5">_______________________________________________<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>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><div>Hilario Fernandes</div></div>
</div>