<div dir="ltr">Matt, check out this mondrian property:<br><div><br>mondrian.olap.case.sensitive:<br>Boolean property that controls whether the MDX parser resolves uses case-sensitive matching when looking up identifiers. The default is false.<br>

</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Apr 24, 2013 at 9:35 AM, Matt Campbell <span dir="ltr">&lt;<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div link="blue" vlink="purple" lang="EN-US"><div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">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.<u></u><u></u></p>

<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:9.0pt;font-family:&quot;Lucida Console&quot;">&gt; select gender.gender.f on 0 from sales;<u></u><u></u></span></p>

<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:9.0pt;font-family:&quot;Lucida Console&quot;"><u></u> <u></u></span></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:9.0pt;font-family:&quot;Lucida Console&quot;">Mondrian Error:Failed to parse query &#39;select gender.gender.f on 0 from sales&#39;<u></u><u></u></span></p>

<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:9.0pt;font-family:&quot;Lucida Console&quot;">Mondrian Error:MDX object &#39;gender.gender.f&#39; not found in cube &#39;Sales&#39;<u></u><u></u></span></p>

<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:9.0pt;font-family:&quot;Lucida Console&quot;"><u></u> <u></u></span></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:9.0pt;font-family:&quot;Lucida Console&quot;">&gt; select gender.gender.F on 0 from sales;<u></u><u></u></span></p>

<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:9.0pt;font-family:&quot;Lucida Console&quot;">Axis #0:<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:9.0pt;font-family:&quot;Lucida Console&quot;">{}<u></u><u></u></span></p>

<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:9.0pt;font-family:&quot;Lucida Console&quot;">Axis #1:<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:9.0pt;font-family:&quot;Lucida Console&quot;">{[Customer].[Gender].[F]}<u></u><u></u></span></p>

<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:9.0pt;font-family:&quot;Lucida Console&quot;">Row #0: 131,558<u></u><u></u></span></p></div></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></div>