[Mondrian] Level closure ignores captionColumn

Martijn van den Broek martijn at basesoft.com
Wed Jun 8 09:08:42 EDT 2016


Thanks Kurtis, that indeed looks like the proper way to do it. I made 
https://github.com/pentaho/mondrian/pull/712

I kindly ask if this can also be merged into the 3.12 branch as we are 
tracking that. Thanks.




On 06/07/2016 04:24 PM, Kurtis Walker wrote:
>
>
> Have a look at RolapParentChildMember.  I think you could override 
> getCaption in that one to return what you need.  Also have a look at 
> getCaption in MemberBase to give you an idea of the formatting that 
> you would still need to do in your override.
>
> ------------------------------------------------------------------------
> *From:* mondrian-bounces at pentaho.org <mondrian-bounces at pentaho.org> on 
> behalf of Martijn van den Broek <martijn at basesoft.com>
> *Sent:* Tuesday, June 7, 2016 10:06 AM
> *To:* mondrian at pentaho.org
> *Subject:* [Mondrian] Level closure ignores captionColumn
> Hi all,
>
> In our MDX queries we use id's to select and captionColumn to display 
> data to the end user. This works great until we started to use closure 
> tables within one of our levels. It seems that the captionColumn (and 
> also captionExpression) don't set the member caption on the objects.
>
> I made the following JIRA which also contains a (currently failing) 
> test case to reproduce the issue: 
> http://jira.pentaho.com/browse/MONDRIAN-2496
>
> We would like to try to solve this issue if possible. I've been trying 
> to debug the code to see where it might go wrong. I noticed the SQL 
> does include the caption column, but the final member still has 'null' 
> for .caption. The (closure) member does have a .dataMember which has 
> the expected caption set. Should we modify MemberBase.getCaption() to 
> check if this.dataMember.caption is set, and return that instead?
>
> Any hints resolving this issue will be appreciated.
>
>
> -- 
> Kind regards,
>
> Martijn van den Broek
> BaseSoft Solutions B.V.
>
> Herengracht 564
> 1017 CH Amsterdam
> The Netherlands
>
> http://www.basesoftsolutions.com/
> +31(0)206847087
>
> Confidentiality notice
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

-- 
Kind regards,

Martijn van den Broek
BaseSoft Solutions B.V.

Herengracht 564
1017 CH Amsterdam
The Netherlands

http://www.basesoftsolutions.com/
+31(0)206847087

Confidentiality notice
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20160608/9c0905a9/attachment.html 


More information about the Mondrian mailing list