<!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.18157" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=304042700-13122008><FONT face="Lucida Sans"
color=#000080 size=2>Could it be this issue: <A
href="http://jira.pentaho.com/browse/BISERVER-2491">http://jira.pentaho.com/browse/BISERVER-2491</A> ?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=304042700-13122008><FONT face="Lucida Sans"
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=304042700-13122008><FONT face="Lucida Sans"
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>Ati
Rosselet<BR><B>Sent:</B> Friday, December 12, 2008 4:17 PM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] re: roles and multiple
hierarchies.. androllupPolicy="partial"<BR></FONT><BR></DIV>
<DIV></DIV>Using jpivot, we have some strange behavior with
roles...<BR>Without Role restrictions, each dimension with multiple
hierarchies displays all the members of each hierarchy as expected... and one
can select from any hierarchy (with a single hierarchy of course). Now.. if I
apply a Role, interesting things happen. <BR>using rollupPolicy="partial",
categories with partial visibility (other than the default hierarchy) are not
appearing. If I remove the rollupPolicy statement, they appear. From what I
can see.. JPivot is not getting the data to display the hierarchy.. so I'm
assuming somehow that mondiran is removing/altering something in the
Heirarchies returned with the query Results.... Any ideas?
Julian?<BR><BR>Second interesting effect. If we do not specify rollupPolicy on
any of the hierarchy restrictions .. it/they appear (all are shown) and all
works fine (with roles). If however, ANY hierarchies of a dimension have a
rollupPolicy="partial" defined, thenafter selecting the other hierarchy and
executing a query.. the other hierarchy returned is empty.... but can be
accessed by writing it into the MDX query... so...<BR><BR>So.. it seems that
something is off with the rollupPolicy. Is this a known/experienced BUG? or a
"feature" .. or.... I'll look at the source.. but have no idea whether I'll
get anywhere (the partial rollup policy would be very useful if it
worked....) I tried debugging into the guts of mondrian... but I can't
see where the hierarchy members are disappearing (I assume it has something to
do with the substutionMemberReader... maybe? :))<BR><BR>Cheers<BR>Ati
</BLOCKQUOTE></BODY></HTML>