<p dir="ltr">That seems like a bug to me in the mondrian 4 branch. I'm pretty sure I use that successfully in mondrian 3 in the past.</p>
<div class="gmail_quote">On Jan 20, 2016 12:20 PM, "Tom Barber" <<a href="mailto:tom@analytical-labs.com">tom@analytical-labs.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Here's another one:<div><br></div><div><div><Query alias="my_view"></div><div> <ExpressionView></div><div> <SQL dialect='mysql'></div><div> <![CDATA[select f.customer_id, f.fname, f.fname `f2` from customer f]]></div><div> </SQL></div><div> </ExpressionView></div><div> </Query></div><div><br></div><div>If I try and use column f2 in a dimension I get a column not found error. If I look in the rolapschemaloader the table is indeed missing this column as I guess it looks up the names and ignores the alias. </div><div><br></div><div>I assume thats by accident rather than design? I can't see why Mondrian wouldn't support mysql column aliases?</div><div><br></div><div>If it looks like a bug I'll see if I can come up with a patch.</div><div><br></div><div>Tom</div><div><br></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>