This could be related to this issue:<br><br><a href="http://jira.pentaho.com/browse/MONDRIAN-1187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel" target="_blank">http://jira.pentaho.com/browse/MONDRIAN-1187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel</a><br>
<br>Cheers,<br>Pedro<div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Dec 25, 2012 at 5:12 AM, m.xinu <span dir="ltr"><<a href="mailto:mehdi_xinu@yahoo.com" target="_blank">mehdi_xinu@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-size:10pt;font-family:Courier New,courier,monaco,monospace,sans-serif">I checked it in Mondrian "3.3.0.14703", "3.4.1" and "3.5.0". The results all are the same.<div>
<span><br></span></div><div class="hm HOEnZb"><div><br></div> </div><div style="font-family:Courier New,courier,monaco,monospace,sans-serif;font-size:10pt"><div class="hm HOEnZb"> </div><div style="font-family:times new roman,new york,times,serif;font-size:12pt">
<div class="hm HOEnZb"> <div dir="ltr"> <font face="Arial"> <hr size="1"> <b><span style="font-weight:bold">From:</span></b> Kurtis Walker <<a href="mailto:kwalker@pentaho.com" target="_blank">kwalker@pentaho.com</a>><br>
<b><span style="font-weight:bold">To:</span></b> <a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>; m. xinu <<a href="mailto:mehdi_xinu@yahoo.com" target="_blank">mehdi_xinu@yahoo.com</a>> <br>
<b><span style="font-weight:bold">Sent:</span></b> Monday, December 24, 2012 4:37 PM<br> <b><span style="font-weight:bold">Subject:</span></b> Re: [Mondrian] Wrong result for TopCount using calculated measure<br> </font> </div>
</div><div><div class="h5"> <br>
<div>
<div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">Seems like a bug to me. What version of mondrian are you using?</div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"> </div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">On Monday, December 24, 2012 10:24:32 AM m. xinu wrote:<br></div>
<div style="margin-right:40px;text-indent:0px;margin-left:40px;margin-bottom:0px;margin-top:12px"><span style="font-size:10pt;font-family:'Courier New,courier,monaco,monospace,sans-serif'">Hi,</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px"><span style="font-size:10pt;font-family:'Courier New,courier,monaco,monospace,sans-serif'"><br></span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-size:10pt;background-color:#000000;font-family:'Courier New,courier,monaco,monospace,sans-serif'">I defined a calculated member in [Measures] dimension, and when I execute the following MDX:</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-size:10pt;font-family:'Courier New,courier,monaco,monospace,sans-serif'"><br>
</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-family:'Courier New,courier,monaco,monospace,sans-serif';font-size:10pt;color:#800000">select TopCount([ExpireDate].[Month].Members, 10, [Measures].[TotalAmount]) ON COLUMNS,<br>
[Measures].[TotalAmount] ON ROWS<br>from [Deposit]</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-size:10pt;font-family:'Courier New,courier,monaco,monospace,sans-serif'"><br>
</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-size:10pt;background-color:#000000;font-family:'Courier New,courier,monaco,monospace,sans-serif'">the result is wrong, but when I use Order() function instead of TopCount, the result is OK. In fact the following MDX works fine:</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-size:10pt;font-family:'Courier New,courier,monaco,monospace,sans-serif'"><br>
</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-family:'Courier New,courier,monaco,monospace,sans-serif';font-size:10pt;color:#007f40">select Head(Order([ExpireDate].[Month].Members, [Measures].[TotalAmount], DESC), 10) ON COLUMNS,<br>
[Measures].[TotalAmount] ON ROWS<br>from [Deposit]</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-size:10pt;font-family:'Courier New,courier,monaco,monospace,sans-serif'"><br>
</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-size:10pt;background-color:#000000;font-family:'Courier New,courier,monaco,monospace,sans-serif'">The [Measures].[TotalAmount] is a calculated member defined in Mondrian schema as follows:</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-size:10pt;font-family:'Courier New,courier,monaco,monospace,sans-serif'"><br>
</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-family:'Courier New,courier,monaco,monospace,sans-serif';font-size:10pt;color:#40007f"><CalculatedMember name="TotalAmount" dimension="Measures"><br>
<Formula></span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-family:'Courier New,courier,monaco,monospace,sans-serif';font-size:10pt;color:#40007f">[Measures].[MainAccAmount] + [Measures].[IntblockedAccAmount] + [Measures].[BlockedAccAmount]</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-family:'Courier New,courier,monaco,monospace,sans-serif';font-size:10pt;color:#40007f"></Formula><br>
</CalculatedMember><br></span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-size:10pt;font-family:'Courier New,courier,monaco,monospace,sans-serif'"><br>
</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-size:10pt;background-color:#000000;font-family:'Courier New,courier,monaco,monospace,sans-serif'">Is it a bug? or did I use something wrong?</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:40px;margin-right:40px;text-indent:0px;background-color:#000000"><span style="font-size:10pt;font-family:'Courier New,courier,monaco,monospace,sans-serif'"><br>
</span></div>
<div style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><br><br></div></div></div><br><br> </div></div></div> </div> </div></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></div>