<div dir="ltr">And to add to that, i don't see why it would need to act any differently to a standard non calculated member, ie: if the main members don't require a level prepended, why does the calculated variant?</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 20 January 2016 at 14:00, 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">I don't agree or disagree, but mondrian seems to respond with out the level but then require the level when constructing the mdx :)</p><div class="HOEnZb"><div class="h5">
<div class="gmail_quote">On 20 Jan 2016 1:56 pm, "Andy Grohe" <<a href="mailto:agrohe21@gmail.com" target="_blank">agrohe21@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"><p dir="ltr">I would say it is better practice to fully qualify the member wth the level if possible.</p>
<div class="gmail_quote">On Jan 20, 2016 4:09 AM, "Tom Barber" <<a href="mailto:tom@analytical-labs.com" target="_blank">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">Hello Folks<div><br></div><div>Trying to debug a problem that has cropped up in Mondrian 4.</div><div><br></div><div>I have a schema that looks like this: <a href="https://gist.github.com/buggtb/6173b6ed547e0be77ce4" target="_blank">https://gist.github.com/buggtb/6173b6ed547e0be77ce4</a></div><div><br></div><div>And as you can see there is a calculated column that extracts the year from a date.</div><div><br></div><div>The queries run, but when you use Saiku to select a member the unique name for the Year is [Test Date].[Test Date].[1997] which fails because it reckons is doesn't exist. That said, [Customers].[Customers].[USA] does exist, so for normal members it is fine. Anyway, if I drop to an MDX query, indeed:</div><div><br></div><div><div>WITH</div><div>SET [~COLUMNS] AS</div><div> {[Customers].[Customers].[USA]}</div><div>SET [~ROWS] AS</div><div> Hierarchize({[Test Date].[Test Date].[1997]})</div><div>SELECT</div><div>NON EMPTY CrossJoin([~COLUMNS], {[Measures].[Unit Sales]}) ON COLUMNS,</div><div>NON EMPTY [~ROWS] ON ROWS</div><div>FROM [Sales]</div><div><br></div><div>Doesn't work, but:</div><div><br></div><div><div>WITH</div><div>SET [~COLUMNS] AS</div><div> {[Customers].[Customers].[USA]}</div><div>SET [~ROWS] AS</div><div> Hierarchize({[Test Date].[Test Date].[Year].[1997]})</div><div>SELECT</div><div>NON EMPTY CrossJoin([~COLUMNS], {[Measures].[Unit Sales]}) ON COLUMNS,</div><div>NON EMPTY [~ROWS] ON ROWS</div><div>FROM [Sales]</div></div><div><br></div><div>Does. So from my point of view there is an issue with the member lookup. Anyway, does anyone have any bright ideas as a workaround/fix?</div><div><br></div><div>Thanks</div><div><br></div><div>Tom</div><div><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>
</div></div></div>
<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></blockquote></div>
<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></blockquote></div>
</div></div></blockquote></div><br></div>