[Mondrian] Case sensitive check

Luc Boudreau lucboudreau at gmail.com
Wed Apr 24 09:41:41 EDT 2013


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>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
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130424/e8a0dac3/attachment.html 


More information about the Mondrian mailing list