Please log a case in our Jira system and someone will look into the matter. Thanks!<br><br><a href="http://jira.pentaho.com">http://jira.pentaho.com</a><br><br>Luc<br><br><div class="gmail_quote">On Wed, Jul 25, 2012 at 6:45 AM, Rui Gonçalves <span dir="ltr"><<a href="mailto:rui.pinho.goncalves@gmail.com" target="_blank">rui.pinho.goncalves@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>Hi,</div><div><br></div><div>Found some inconsistency on rollupPolicy returned values, here's how to reproduce my findings (pentaho ce 3.10 - mondrian 3.3 and pentaho ce 4.5 - mondrian 3.4)</div>
<div><br></div><div>
Using JPivot in PUC with Mondrian-One-To-One-UserRoleMapper enabled, I've made the following modifications to steelwheels.mondrian.xml:</div><div><br></div><div> <span style="white-space:pre-wrap"> </span><Role name="cto"></div>
<div><span style="white-space:pre-wrap"> </span><SchemaGrant access="all"></div><div><span style="white-space:pre-wrap"> </span><CubeGrant cube="SteelWheelsSales" access="all"></div>
<div><span style="white-space:pre-wrap"> </span><HierarchyGrant hierarchy="[Markets]" rollupPolicy="partial" access="custom"></div><div><span style="white-space:pre-wrap"> </span><MemberGrant member="[Markets].[EMEA]" access="all"/></div>
<div><span style="white-space:pre-wrap"> </span></HierarchyGrant></div><div><span style="white-space:pre-wrap"> </span></CubeGrant></div><div><span style="white-space:pre-wrap"> </span></SchemaGrant></div>
<div><span style="white-space:pre-wrap"> </span></Role></div><div><span style="white-space:pre-wrap"> </span><Role name="Admin"></div><div><span style="white-space:pre-wrap"> </span><SchemaGrant access="all"></div>
<div><span style="white-space:pre-wrap"> </span><CubeGrant cube="SteelWheelsSales" access="all"></div><div><span style="white-space:pre-wrap"> </span></CubeGrant></div>
<div><span style="white-space:pre-wrap"> </span></SchemaGrant></div><div><span style="white-space:pre-wrap"> </span></Role></div><div><br></div><div>Refresh stuff and login as suzy</div>
<div><br></div><div>On a new analysis, user suzy (role cto) views a total Quantity for All Markets of 49578 </div><div>(select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,</div><div> NON EMPTY Crossjoin(Hierarchize({[Markets].[All Markets]}), {([Customers].[All Customers], [Product].[All Products], [Time].[All Years], [Order Status].[All Status Types])}) ON ROWS</div>
<div>from [SteelWheelsSales])</div><div><br></div><div>Drilling on All Markets we verify that 49578 is the Quantity value for EMEA ... nice</div><div>(select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,</div><div> NON EMPTY Crossjoin(Hierarchize(Union({[Markets].[All Markets]}, [Markets].[All Markets].Children)), {([Customers].[All Customers], [Product].[All Products], [Time].[All Years], [Order Status].[All Status Types])}) ON ROWS</div>
<div>from [SteelWheelsSales])</div><div><br></div><div><br></div><div>Using Jpivot Olap Navigator (the cube) we remove the Markets dimension from the Row axis to the Filter axis without defining any filter and save the analysis on the server. ex: \Steel Wheels\Analysis\Sample</div>
<div>(select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,</div><div> NON EMPTY {([Customers].[All Customers], [Product].[All Products], [Time].[All Years], [Order Status].[All Status Types])} ON ROWS</div><div>from [SteelWheelsSales])</div>
<div><br></div><div>Close the Analysis and reopen it from the solution browser</div><div><br></div><div>The returned value for Quantity is 49578 wich is correct. Using the JPivot Olap Navigator, add the Markets Dimensiont to the Row axis again. Now the value for [Markets].[All Markets] is 105331 and suzy can view information that previously had no access to.</div>
<div><br></div><div>Is there a way to workaround this behaviour?</div><div><br></div><div>Thank's,</div><div>Rui</div>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br>