<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"><<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.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;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><<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>> on behalf of Tom Barber <<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>><br>
<span style="font-weight:bold">Reply-To: </span>Mondrian list <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><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 <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><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't recall mondrian 3 forcing you to the default year if you didn'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">
<<a href="mailto:agrohe21@gmail.com" target="_blank">agrohe21@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 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">
<<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">
<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've not used the dimension I don't need to filter on it?!</div>
<div><br>
</div>
<div>You can'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">
<<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">
Try setting the default member of the hierarchy. (The default default<br>
is the first member of the first level, which is the 'all' member if<br>
it has one, otherwise the first member of the first level. But you<br>
don't need to stick with the default default.)<br>
<div>
<div><br>
On Wed, Jan 20, 2016 at 10:37 AM, Tom Barber <<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>> wrote:<br>
> Oh actually I suspect the hasAll = false option wont' work for the user<br>
> because of the other weird thing where you set hasAll to false and it forces<br>
> Mondrian to add the first year in a time dimension into the where query even<br>
> when its not used.<br>
><br>
> --------------<br>
><br>
> Director Meteorite.bi - Saiku Analytics Founder<br>
> Tel: <a href="tel:%2B44%280%295603641316" value="+445603641316" target="_blank">
+44(0)5603641316</a><br>
><br>
> (Thanks to the Saiku community we reached our Kickstart goal, but you can<br>
> always help by sponsoring the project)<br>
><br>
> On 20 January 2016 at 18:29, Tom Barber <<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>> wrote:<br>
>><br>
>> Thanks for that Julian, the removal of has all has fixed it in my test,<br>
>> I'll check with the user and see if that will do for now, if not I guess<br>
>> I'll be stabbing aimlessly at the code on Friday.<br>
>><br>
>> <a href="http://jira.pentaho.com/browse/MONDRIAN-2449" rel="noreferrer" target="_blank">
http://jira.pentaho.com/browse/MONDRIAN-2449</a><br>
>><br>
>> Regards,<br>
>><br>
>> Tom<br>
>><br>
>> --------------<br>
>><br>
>> Director Meteorite.bi - Saiku Analytics Founder<br>
>> Tel: <a href="tel:%2B44%280%295603641316" value="+445603641316" target="_blank">
+44(0)5603641316</a><br>
>><br>
>> (Thanks to the Saiku community we reached our Kickstart goal, but you can<br>
>> always help by sponsoring the project)<br>
>><br>
>> On 20 January 2016 at 18:18, Julian Hyde <<a href="mailto:julianhyde@gmail.com" target="_blank">julianhyde@gmail.com</a>> wrote:<br>
>>><br>
>>> Having said all that, I can't see why [Customers].[Customers].[USA]<br>
>>> works an [Test Date].[Test Date].[1997] does not; both hierarchies<br>
>>> have an 'all' member. I think you should log a bug.<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>
><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>
</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>