[Mondrian] VisualTotals and Excel 2007

Julian Hyde jhyde at pentaho.com
Mon Dec 21 11:55:02 EST 2009

> Calum Miller wrote:
> The following query against the FoodMart Database yields different  
> results in SSAS and Mondrian

First of all, make sure that you have the fix to
http://jira.pentaho.com/browse/MONDRIAN-295. It is fixed only on the main
branch currently.

If that doesn't work, please log another jira case.

> The queries from Excel are dynamic, so I need a clean way to apply  
> visual totals by default to each axis, any thoughts?

Are you asking for a way to apply visualtotals even though it isn't
explicitly specified in the MDX query? I'd rather not do that unless there
is a very good reason.


More information about the Mondrian mailing list