[Mondrian] RolapNativeSet NPE

Hilario Fernandes hilario.fernandes at cortex-intelligence.com
Wed Mar 26 14:30:53 EDT 2014


Hi everyone,

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.

If I try to do a query such as this:

SELECT
NON EMPTY {[Measures].[Price_SUM]} ON COLUMNS,
NON EMPTY CrossJoin({Filter({[Brand].[Brand].Members},
[Brand].CurrentMember.Name MATCHES '(?i).*zzzzz.*')},
{[Fuel].[Fuel].Members}) ON ROWS
FROM [Cars]


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.


java.lang.NullPointerException
at
mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:186)
at
mondrian.olap.fun.CrossJoinFunDef$CrossJoinIterCalc.evaluateIterable(CrossJoinFunDef.java:177)
at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:875)
at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:700)
at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:656)
at mondrian.rolap.RolapResult.<init>(RolapResult.java:288)
at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:671)
at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621)


Anyone has an idea of the problem?

-- 
Hilario Fernandes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20140326/1af10bc6/attachment.html 


More information about the Mondrian mailing list