Ati,<br><br>Please log this in Jira. Someone will look into it and determine if this is a bug.<br><br>Thanks for reporting this!<br><br>Luc<br><br><div class="gmail_quote">On Wed, May 11, 2011 at 7:19 AM, Ati Rosselet <span dir="ltr"><<a href="mailto:ati.rosselet@gmail.com">ati.rosselet@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>Luc/Julian,</div><div><br></div><div>Using VisualTotals(), somehow the Time dimension (at least) is not being handled correctly wrt aggregates.</div>
<div>Visual Totals sums up the values across its elements, but in the case of an aggregate (e.g. time rollup), it should be summing up the underlying values rather than the cell values</div>
<div>(if that makes sense).</div><div><br></div><div>I've reproduced the problem with 2 Foodmart queries to view</div><div>"sales to men for 1997, and by quarter, and a roll-up to show sales to men cumulated over the year" (I'm not a male chauvinist, this just was the first that came to mind :))</div>
<div><br></div><div>with </div><div>member [Gender].[YTD] as 'AGGREGATE(YTD(),[Gender].[M])', format_string = "#,###00.0" </div><div>select </div>
<div> {[Time].[1997], </div><div> [Time].[1997].[Q1],[Time].[1997].[Q2],[Time].[1997].[Q3],[Time].[1997].[Q4]} ON COLUMNS,</div><div>{[Gender].[M],[Gender].[YTD]} ON ROWS</div><div> FROM [Sales];</div><div>
<br></div><div>returns (correctly):</div><div><div>Axis #0:</div><div>{}</div><div>Axis #1:</div><div>{[Time].[1997]}</div><div>{[Time].[1997].[Q1]}</div><div>{[Time].[1997].[Q2]}</div><div>{[Time].[1997].[Q3]}</div><div>
{[Time].[1997].[Q4]}</div><div>Axis #2:</div><div>{[Gender].[M]}</div><div>{[Gender].[YTD]}</div><div>Row #0: 135,215</div><div>Row #0: 33,381</div><div>Row #0: 31,618</div><div>Row #0: 33,249</div><div>Row #0: 36,967</div>
<div>Row #1: 135,215.0 <--- [Time].[1997] is aggregated correctly</div><div>Row #1: 33,381.0</div><div>Row #1: 64,999.0</div><div>Row #1: 98,248.0</div><div>Row #1: 135,215.0</div></div><div><br></div><div><div>whereas:</div>
</div><div><br></div><div><div>with </div><div>SET [VTime] AS 'VisualTotals({[Time].[1997],[Time].[1997].Children})'</div><div>member [Gender].[YTD] as 'AGGREGATE(YTD(),[Gender].[M])', format_string = "#,###00.0" </div>
<div>select </div><div> {[VTime]} ON COLUMNS,</div><div>{[Gender].[M],[Gender].[YTD]} ON ROWS</div><div> FROM [Sales];</div><div><br></div></div><div>gives:</div><div><div>
<div>Axis #0:</div><div>{}</div><div>Axis #1:</div><div>{[Time].[1997]}</div><div>{[Time].[1997].[Q1]}</div><div>{[Time].[1997].[Q2]}</div><div>{[Time].[1997].[Q3]}</div><div>{[Time].[1997].[Q4]}</div><div>Axis #2:</div>
<div>
{[Gender].[M]}</div><div>{[Gender].[YTD]}</div><div>Row #0: 135,215</div><div>Row #0: 33,381</div><div>Row #0: 31,618</div><div>Row #0: 33,249</div><div>Row #0: 36,967</div><div>Row #1: 331,843.0 <<<< this should be 135,125 as far as I can tell</div>
<div>Row #1: 33,381.0</div><div>Row #1: 64,999.0</div><div>Row #1: 98,248.0</div><div>Row #1: 135,215.0</div></div></div><div><br></div><div>note axis #2 and axis #2 are identical in both cases, so I'm assuming it has to do with the internal handling of VisualTotals... </div>
<div><br></div><div>any ideas - or should I just create a testcase for this and open a new JIRA issue?</div><div>Cheers</div><div>Ati</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>