<div dir="ltr">I'll supply a 1 line fix and no test case, or, a 1 line fix and a test case if someone documents the Mondrian test suite! It took me so long figuring out how the test suite works last time, I gave up because the debugger was making my laptop melt :)</div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr">--------------<div><br></div><div><div style="font-size:small"><font color="#999999">Director Meteorite.bi - Saiku Analytics Founder</font></div><div style="font-size:small"><font color="#999999">Tel: +44(0)5603641316 </font></div><div style="font-size:small"><font color="#999999"><br></font></div><div style="font-size:small"><font color="#999999">(Thanks to the Saiku community we reached our <a href="http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/" target="_blank">Kickstart</a> goal, but you can always help by <a href="http://www.meteorite.bi/products/saiku/sponsorship" target="_blank">sponsoring the project</a>)</font></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On 22 January 2016 at 17:22, Julian Hyde <span dir="ltr"><<a href="mailto:julianhyde@gmail.com" target="_blank">julianhyde@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Can you contribute a PR?<div><div class="h5"><div><br><div><blockquote type="cite"><div>On Jan 22, 2016, at 1:38 AM, Tom Barber <<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>> wrote:</div><br><div><div dir="ltr">Thanks for that Julian I patched our version of Mondrian 4 and it's spluttered back into life.<div><br></div><div>Tom</div></div><div class="gmail_extra"><br clear="all"><div><div><div dir="ltr"><div><div dir="ltr">--------------<div><br></div><div><div style="font-size:small"><font color="#999999">Director Meteorite.bi - Saiku Analytics Founder</font></div><div style="font-size:small"><font color="#999999">Tel: <a href="tel:%2B44%280%295603641316" value="+445603641316" target="_blank">+44(0)5603641316</a> </font></div><div style="font-size:small"><font color="#999999"><br></font></div><div style="font-size:small"><font color="#999999">(Thanks to the Saiku community we reached our <a href="http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/" target="_blank">Kickstart</a> goal, but you can always help by <a href="http://www.meteorite.bi/products/saiku/sponsorship" target="_blank">sponsoring the project</a>)</font></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On 21 January 2016 at 19:31, Tom Barber <span dir="ltr"><<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">Already logged mondrian-2450</p><div><div>
<div class="gmail_quote">On 21 Jan 2016 19:29, "Julian Hyde" <<a href="mailto:julianhyde@gmail.com" target="_blank">julianhyde@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Yes, it's a bug. It should be looking for the column label rather than<br>
its name. In RolapSchema.PhysSchema.describe, the line<br>
<br>
final String columnName = metaData.getColumnName(i + 1);<br>
<br>
should be<br>
<br>
final String columnName = metaData.getColumnLabel(i + 1);<br>
<br>
Can someone please log a JIRA case for this?<br>
<br>
Julian<br>
<br>
<br>
On Wed, Jan 20, 2016 at 11:26 AM, Andy Grohe <<a href="mailto:agrohe21@gmail.com" target="_blank">agrohe21@gmail.com</a>> wrote:<br>
> That seems like a bug to me in the mondrian 4 branch. I'm pretty sure I use<br>
> that successfully in mondrian 3 in the past.<br>
><br>
> On Jan 20, 2016 12:20 PM, "Tom Barber" <<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>> wrote:<br>
>><br>
>> Here's another one:<br>
>><br>
>> <Query alias="my_view"><br>
>> <ExpressionView><br>
>> <SQL dialect='mysql'><br>
>> <![CDATA[select f.customer_id,<br>
>> f.fname, f.fname `f2` from customer f]]><br>
>> </SQL><br>
>> </ExpressionView><br>
>> </Query><br>
>><br>
>> If I try and use column f2 in a dimension I get a column not found error.<br>
>> If I look in the rolapschemaloader the table is indeed missing this column<br>
>> as I guess it looks up the names and ignores the alias.<br>
>><br>
>> I assume thats by accident rather than design? I can't see why Mondrian<br>
>> wouldn't support mysql column aliases?<br>
>><br>
>> If it looks like a bug I'll see if I can come up with a patch.<br>
>><br>
>> Tom<br>
>><br>
>><br>
>> _______________________________________________<br>
>> Mondrian mailing list<br>
>> <a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
>> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
>><br>
><br>
> _______________________________________________<br>
> Mondrian mailing list<br>
> <a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
><br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</blockquote></div>
</div></div></blockquote></div><br></div>
_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org" target="_blank">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></blockquote></div><br></div></div></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" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br></div>