[Mondrian] Unique Member Names for Calculated Fields in Mondrian 4

[Tom Barber]

Actually linking a table to query doesn't matter because that doesn't work
with the filter either. Arse.....

--------------

Director Meteorite.bi - Saiku Analytics Founder
Tel: +44(0)5603641316

(Thanks to the Saiku community we reached our Kickstart
<http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/>
goal, but you can always help by sponsoring the project
<http://www.meteorite.bi/products/saiku/sponsorship>)

On 26 January 2016 at 15:50, Tom Barber <tom at analytical-labs.com> wrote:

> Okay, so 2 questions.
>
> 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?!
>
> You can't Link a Table to a Query object in Mondrian 4 can you?
>
> Thanks
>
> Tom
>
> --------------
>
> Director Meteorite.bi - Saiku Analytics Founder
> Tel: +44(0)5603641316
>
> (Thanks to the Saiku community we reached our Kickstart
> <http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/>
> goal, but you can always help by sponsoring the project
> <http://www.meteorite.bi/products/saiku/sponsorship>)
>
> On 20 January 2016 at 20:24, Julian Hyde <julianhyde at gmail.com> wrote:
>
>> Try setting the default member of the hierarchy. (The default default
>> is the first member of the first level, which is the 'all' member if
>> it has one, otherwise the first member of the first level. But you
>> don't need to stick with the default default.)
>>
>> On Wed, Jan 20, 2016 at 10:37 AM, Tom Barber <tom at analytical-labs.com>
>> wrote:
>> > Oh actually I suspect the hasAll = false option wont' work for the user
>> > because of the other weird thing where you set hasAll to false and it
>> forces
>> > Mondrian to add the first year in a time dimension into the where query
>> even
>> > when its not used.
>> >
>> > --------------
>> >
>> > Director Meteorite.bi - Saiku Analytics Founder
>> > Tel: +44(0)5603641316
>> >
>> > (Thanks to the Saiku community we reached our Kickstart goal, but you
>> can
>> > always help by sponsoring the project)
>> >
>> > On 20 January 2016 at 18:29, Tom Barber <tom at analytical-labs.com>
>> wrote:
>> >>
>> >> Thanks for that Julian, the removal of has all has fixed it in my test,
>> >> I'll check with the user and see if that will do for now, if not I
>> guess
>> >> I'll be stabbing aimlessly at the code on Friday.
>> >>
>> >> http://jira.pentaho.com/browse/MONDRIAN-2449
>> >>
>> >> Regards,
>> >>
>> >> Tom
>> >>
>> >> --------------
>> >>
>> >> Director Meteorite.bi - Saiku Analytics Founder
>> >> Tel: +44(0)5603641316
>> >>
>> >> (Thanks to the Saiku community we reached our Kickstart goal, but you
>> can
>> >> always help by sponsoring the project)
>> >>
>> >> On 20 January 2016 at 18:18, Julian Hyde <julianhyde at gmail.com> wrote:
>> >>>
>> >>> Having said all that, I can't see why [Customers].[Customers].[USA]
>> >>> works an [Test Date].[Test Date].[1997] does not; both hierarchies
>> >>> have an 'all' member. I think you should log a bug.
>> >>> _______________________________________________
>> >>> Mondrian mailing list
>> >>> Mondrian at pentaho.org
>> >>> http://lists.pentaho.org/mailman/listinfo/mondrian
>> >>
>> >>
>> >
>> >
>> > _______________________________________________
>> > Mondrian mailing list
>> > Mondrian at pentaho.org
>> > http://lists.pentaho.org/mailman/listinfo/mondrian
>> >
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20160126/2f003e4e/attachment-0001.html