<div dir="ltr">Fair enough.<div><br></div><div>In that case I need to figure out how to make it resolve members missing a level descriptor, or fudge it to append the level so it can find the member! :)</div><div><br></div><div><br></div></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 26 January 2016 at 16:18, 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 style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>
<div>
<div>Mondrian 3 has the same behavior. </div>
<div>
<div></div>
</div>
</div>
</div>
<div><br>
</div>
<span>
<div style="font-family:Calibri;font-size:12pt;text-align:left;color:black;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt">
<span style="font-weight:bold">From: </span>&lt;<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>&gt; on behalf of Tom Barber &lt;<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>&gt;<br>
<span style="font-weight:bold">Reply-To: </span>Mondrian list &lt;<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>&gt;<br>
<span style="font-weight:bold">Date: </span>Tuesday, January 26, 2016 at 11:12 AM<br>
<span style="font-weight:bold">To: </span>Mondrian list &lt;<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>&gt;<br>
<span style="font-weight:bold">Subject: </span>Re: [Mondrian] Unique Member Names for Calculated Fields in Mondrian 4<br>
</div><div><div class="h5">
<div><br>
</div>
<div>
<div>
<div dir="ltr">But I don&#39;t recall mondrian 3 forcing you to the default year if you didn&#39;t use it (maybe I always had hasAll set to yes)</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 26 January 2016 at 16:11, Andy Grohe <span dir="ltr">
&lt;<a href="mailto:agrohe21@gmail.com" target="_blank">agrohe21@gmail.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 dir="ltr">that is part of the beauty of MDX. Every hierarchy is implicitly included in every MDX query. Used or not</div>
<div>
<div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Tue, Jan 26, 2016 at 9:50 AM, Tom Barber <span dir="ltr">
&lt;<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.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 dir="ltr">Okay, so 2 questions.
<div><br>
</div>
<div>Why, if I set hasAll false, but *dont* include the dimension in the query does it get included in the SQL? surely if i&#39;ve not used the dimension I don&#39;t need to filter on it?!</div>
<div><br>
</div>
<div>You can&#39;t Link a Table to a Query object in Mondrian 4 can you?</div>
<div><br>
</div>
<div>Thanks</div>
<span><font color="#888888">
<div><br>
</div>
<div>Tom</div>
</font></span></div>
<div class="gmail_extra"><span><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>
</span>
<div>
<div>
<div class="gmail_quote">On 20 January 2016 at 20:24, Julian Hyde <span dir="ltr">
&lt;<a href="mailto:julianhyde@gmail.com" target="_blank">julianhyde@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Try setting the default member of the hierarchy. (The default default<br>
is the first member of the first level, which is the &#39;all&#39; member if<br>
it has one, otherwise the first member of the first level. But you<br>
don&#39;t need to stick with the default default.)<br>
<div>
<div><br>
On Wed, Jan 20, 2016 at 10:37 AM, Tom Barber &lt;<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>&gt; wrote:<br>
&gt; Oh actually I suspect the hasAll = false option wont&#39; work for the user<br>
&gt; because of the other weird thing where you set hasAll to false and it forces<br>
&gt; Mondrian to add the first year in a time dimension into the where query even<br>
&gt; when its not used.<br>
&gt;<br>
&gt; --------------<br>
&gt;<br>
&gt; Director Meteorite.bi - Saiku Analytics Founder<br>
&gt; Tel: <a href="tel:%2B44%280%295603641316" value="+445603641316" target="_blank">
+44(0)5603641316</a><br>
&gt;<br>
&gt; (Thanks to the Saiku community we reached our Kickstart goal, but you can<br>
&gt; always help by sponsoring the project)<br>
&gt;<br>
&gt; On 20 January 2016 at 18:29, Tom Barber &lt;<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>&gt; wrote:<br>
&gt;&gt;<br>
&gt;&gt; Thanks for that Julian, the removal of has all has fixed it in my test,<br>
&gt;&gt; I&#39;ll check with the user and see if that will do for now, if not I guess<br>
&gt;&gt; I&#39;ll be stabbing aimlessly at the code on Friday.<br>
&gt;&gt;<br>
&gt;&gt; <a href="http://jira.pentaho.com/browse/MONDRIAN-2449" rel="noreferrer" target="_blank">
http://jira.pentaho.com/browse/MONDRIAN-2449</a><br>
&gt;&gt;<br>
&gt;&gt; Regards,<br>
&gt;&gt;<br>
&gt;&gt; Tom<br>
&gt;&gt;<br>
&gt;&gt; --------------<br>
&gt;&gt;<br>
&gt;&gt; Director Meteorite.bi - Saiku Analytics Founder<br>
&gt;&gt; Tel: <a href="tel:%2B44%280%295603641316" value="+445603641316" target="_blank">
+44(0)5603641316</a><br>
&gt;&gt;<br>
&gt;&gt; (Thanks to the Saiku community we reached our Kickstart goal, but you can<br>
&gt;&gt; always help by sponsoring the project)<br>
&gt;&gt;<br>
&gt;&gt; On 20 January 2016 at 18:18, Julian Hyde &lt;<a href="mailto:julianhyde@gmail.com" target="_blank">julianhyde@gmail.com</a>&gt; wrote:<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; Having said all that, I can&#39;t see why [Customers].[Customers].[USA]<br>
&gt;&gt;&gt; works an [Test Date].[Test Date].[1997] does not; both hierarchies<br>
&gt;&gt;&gt; have an &#39;all&#39; member. I think you should log a bug.<br>
&gt;&gt;&gt; _______________________________________________<br>
&gt;&gt;&gt; Mondrian mailing list<br>
&gt;&gt;&gt; <a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
&gt;&gt;&gt; <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">
http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;<br>
&gt;<br>
&gt; _______________________________________________<br>
&gt; Mondrian mailing list<br>
&gt; <a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
&gt; <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">
http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
&gt;<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>
</div>
</div>
</blockquote>
</div>
<br>
</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>
</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>
</div>
</div>
</div>
</div></div></span>
</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>