[Mondrian] XMLA requests don't return invisible members

Pappyn Bart Bart.Pappyn at vandewiele.com
Wed Apr 16 02:38:51 EDT 2008

The xmla behaviour of mondrian was changed at a certain point in time
and broke everything in jpivot (calculated members, slicers, ...) , so a
lot of patches where necessary to make it work again.
One of them was change 8424, that fixed two things : 
* first of all, no calculated members where returned at all
* To be compatible with the previous version of mondrian (at that time)
and to match jpivot behaviour, only visible members where returned.
* I don't remember if the IS_MEMBER_VISIBLE flag was available at that
time.  I have checked old xmla message I stored at the time I wrote this
change, and the visible flag was not available for members and
calculated members (only for dimensions and levels).
It's ok that this behaviour is changed, so returning all calculated
members, with a visible flag, if jpivot is changed in the same way.


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Julian Hyde
Sent: woensdag 16 april 2008 6:15
To: mondrian at pentaho.org
Subject: [Mondrian] XMLA requests don't return invisible members

Mondrian's XMLA server does not return members that are flagged as
invisible. This seems a little strange to me, since the XMLA provides an
attribute IS_MEMBER_VISIBLE and we could simply return the member with
Here are the two changes that implemented this behavior:

*	7052 emberson "XMLA was not paying attention to the measure
visible flag/property"
*	8424 jhyde "XMLA requests emit regular and calculated members,
but only if visible. (Contributed by Bart Pappyn.)"

Can the contributors please comment why they needed this behavior, and
why it was not acceptable to simply emit invisible members with
This behavior makes it difficult for the XMLA olap4j driver to be
compatible with the mondrian olap4j driver. So, I'd like to reverse this
behavior, and have MDSCHEMA_MEMBERS return all members, visible and
invisible. Let me know if this would cause problems.

This email has been scanned by the Email Security System.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080416/6d0908b2/attachment.html 

More information about the Mondrian mailing list