[Mondrian] Level closure ignores captionColumn

Kurtis Walker kwalker at pentaho.com
Tue Jun 7 10:24:17 EDT 2016

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


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/20160607/28c33c22/attachment.html 

More information about the Mondrian mailing list