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