<div dir="ltr">Actually linking a table to query doesn't matter because that doesn't work with the filter either. Arse.....</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 15:50, 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 class="HOEnZb"><font color="#888888"><div><br></div><div>Tom</div></font></span></div><div class="gmail_extra"><span class=""><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 class="h5"><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>
</blockquote></div><br></div>