<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; 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 id="MAC_OUTLOOK_SIGNATURE"></div>
</div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<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">mondrian-bounces@pentaho.org</a>> on behalf of Tom Barber <<a href="mailto:tom@analytical-labs.com">tom@analytical-labs.com</a>><br>
<span style="font-weight:bold">Reply-To: </span>Mondrian list <<a href="mailto:mondrian@pentaho.org">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">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><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 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: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 class="HOEnZb">
<div class="h5">
<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">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>
</span>
</body>
</html>