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

[Matt Campbell]

Mondrian 3 has the same behavior.

From: <mondrian-bounces at pentaho.org<mailto:mondrian-bounces at pentaho.org>> on behalf of Tom Barber <tom at analytical-labs.com<mailto:tom at analytical-labs.com>>
Reply-To: Mondrian list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Date: Tuesday, January 26, 2016 at 11:12 AM
To: Mondrian list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Subject: Re: [Mondrian] Unique Member Names for Calculated Fields in Mondrian 4

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)

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

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 16:11, Andy Grohe <agrohe21 at gmail.com<mailto:agrohe21 at gmail.com>> wrote:
that is part of the beauty of MDX. Every hierarchy is implicitly included in every MDX query. Used or not

On Tue, Jan 26, 2016 at 9:50 AM, Tom Barber <tom at analytical-labs.com<mailto: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<tel:%2B44%280%295603641316>

(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<mailto: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<mailto: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<tel:%2B44%280%295603641316>
>
> (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<mailto: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<tel:%2B44%280%295603641316>
>>
>> (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<mailto: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<mailto:Mondrian at pentaho.org>
>>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>>
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian


_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian



_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto: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/b1ee5bd6/attachment.html