[Mondrian] Case sensitive check

Matt Campbell mcampbell at pentaho.com
Wed Apr 24 09:44:44 EDT 2013


Yep, I know about that one.  When set to false, the query I pasted is still treated case-sensitive due to the line I referenced.

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Luc Boudreau
Sent: Wednesday, April 24, 2013 9:42 AM
To: Mondrian developer mailing list
Subject: Re: [Mondrian] Case sensitive check

Matt, check out this mondrian property:

mondrian.olap.case.sensitive:
Boolean property that controls whether the MDX parser resolves uses case-sensitive matching when looking up identifiers. The default is false.

On Wed, Apr 24, 2013 at 9:35 AM, Matt Campbell <mcampbell at pentaho.com<mailto:mcampbell at pentaho.com>> wrote:

In RolapLevel.lookupChild(), around line 318 in lagunitas, there’s a call to findBestMemberMatch() using a case-sensitive search, regardless of the setting of the Mondrian property.  I’m assuming this is in error but wanted to make sure there wasn’t some background I’m not aware of before correcting it.  The following query shows the error with a case insensitive configuration.


> select gender.gender.f on 0 from sales;

Mondrian Error:Failed to parse query 'select gender.gender.f on 0 from sales'
Mondrian Error:MDX object 'gender.gender.f' not found in cube 'Sales'

> select gender.gender.F on 0 from sales;
Axis #0:
{}
Axis #1:
{[Customer].[Gender].[F]}
Row #0: 131,558

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130424/2b09f83d/attachment.html 


More information about the Mondrian mailing list