<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18023" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=617542022-17042008><FONT face=Verdana
color=#000080 size=2>I've made that change, and logged bug <TD
nowrap="nowrap"><FONT color=#000000><FONT size=3><FONT
face="Times New Roman">1945278 </TD><TD></FONT></FONT></FONT><A
href="https://sourceforge.net/tracker/index.php?func=detail&aid=1945278&group_id=58645&atid=488472"><!-- google_ad_section_start --><FONT
face="Times New Roman" size=3>Ignore MDSCHEMA_MEASURES where IS_MEMBER_VISIBLE
is false</FONT></A></TD> against jpivot.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617542022-17042008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=617542022-17042008><FONT face=Verdana
color=#000080 size=2>Calculated members are still returned.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617542022-17042008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=617542022-17042008><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Pappyn
Bart<BR><B>Sent:</B> Tuesday, April 15, 2008 11:39 PM<BR><B>To:</B>
jhyde@pentaho.com; Mondrian developer mailing list<BR><B>Subject:</B> RE:
[Mondrian] XMLA requests don't return invisible members<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2>Julian,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2>One of them was change 8424, that fixed two things :
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2>* first of all, no calculated members where returned at
all</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2>* To be compatible with the previous version of mondrian
(at that time) and to match jpivot behaviour, only visible members where
returned.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2>* 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).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015412606-16042008><FONT face=Arial
color=#0000ff size=2>Bart</FONT></SPAN></DIV><FONT face=Arial color=#0000ff
size=2></FONT><FONT face=Arial color=#0000ff size=2></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Julian
Hyde<BR><B>Sent:</B> woensdag 16 april 2008 6:15<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] XMLA requests don't return
invisible members<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=455344001-16042008><FONT face=Verdana color=#000080
size=2>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
IS_MEMBER_VISIBLE=false.</FONT></SPAN></DIV>
<DIV><SPAN class=455344001-16042008><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=455344001-16042008><FONT face=Verdana color=#000080
size=2>Here are the two changes that implemented this
behavior:</FONT></SPAN></DIV>
<UL>
<LI><SPAN class=455344001-16042008><FONT face=Verdana color=#000080
size=2>7052 emberson "XMLA was not paying attention to the measure visible
flag/property" <A
href="http://perforce.eigenbase.org:8080/@md=d&cd=//&c=rD2@/7052?ac=10">http://perforce.eigenbase.org:8080/@md=d&cd=//&c=rD2@/7052?ac=10</A></FONT></SPAN>
<LI><SPAN class=455344001-16042008><FONT face=Verdana color=#000080
size=2>8424 jhyde "XMLA requests emit regular and calculated members, but
only if visible. (Contributed by Bart Pappyn.)" <A
href="http://perforce.eigenbase.org:8080/@md=d&cd=//&c=rD2@/8424?ac=10">http://perforce.eigenbase.org:8080/@md=d&cd=//&c=rD2@/8424?ac=10</A></FONT></SPAN></LI></UL>
<DIV><SPAN class=455344001-16042008><FONT face=Verdana color=#000080
size=2>Can the contributors please comment why they needed this behavior, and
why it was not acceptable to simply emit invisible members
with IS_MEMBER_VISIBLE=false?</FONT></SPAN></DIV>
<DIV><SPAN class=455344001-16042008><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=455344001-16042008>
<DIV><SPAN class=455344001-16042008><FONT face=Verdana color=#000080
size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=455344001-16042008><FONT face=Verdana color=#000080
size=2></FONT></SPAN> </DIV></SPAN></DIV>
<DIV><SPAN class=455344001-16042008><FONT face=Verdana color=#000080
size=2>Julian</FONT></SPAN></DIV><BR>______________________________________________________________________<BR>This
email has been scanned by the Email Security
System.<BR>______________________________________________________________________<BR></BLOCKQUOTE></BODY></HTML>