Analysis view - filtering options

[nicholas]

I'm evaluating JasperServer Professional 2.1, and we have a question about filtering with the Analysis/JPivot view.

 

For 'Foodmart Sample Analysis View', as it opens by default, how would you then adjust the configuration so that it included data from all stores except Beverly Hills?

 

I don't see how to use Filter to do this, because there is no option to select all-except-one as they are radio buttons.

 

If I put Store into the Rows section, I can click down and select 'All' and then uncheck 'Beverly Hills', but that doesn't appear to change the numbers at all - it just hides that store from display, still counting them in the totals at the top line.

 

Thanks for any help,

 

Nick

[swood]

If you exclude a store from the display, its effect will not be removed from a higher level total, like 'All Stores'. What you want is a different rollup, like 'All Stores - Beverly Hills'.

 

There is no way to do this through the UI. You will need to create MDX with a calculated member or named set that does the right thing.

 

 

Sherman

JasperSoft

[nicholas]

Ok, thank you.