If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Scope of Filters

Started by rajivgupta1107, 16 Dec 2008 11:41:14 PM

Previous topic - Next topic

rajivgupta1107

Hi,

Please explain the concept of 'Scope of summary filters' with some example and where it is used?

Regards

Gopinath

Scope determines the level at which the filter shouild be applied.

for example
you have Region, country, State and Revenue data items in your report.
Region, Country and State were grouped.
If you Total the Revenue field you will get footers(sub totals) for Country and Region.
Now if you want to filter Country which has > 50000 revenue, then create a summary filter like Total(Revenue) > 50000 and set the scope to Country.

rajivgupta1107

okk thanks a lot..

One more thing:
Suppose I have a query in the report:

select sum(revenue), region from table group by region having sum(revenue) >100;

Data is:

Revenue  Region
200   A
40  B
500 G


Now in report I show only the region. Its showing A,B,G. But it should show only A and G. For 'B' the having clause is false.

Why it is so?




Gopinath

try total(revenue for Region) > 100 in your summary filter

rajivgupta1107

I have put the filter in summary filters.

But when i try to show the region, its showing A, B and G all. But it shud be A and G only.


Regards

Gopinath

Try placing the filter condition at Detail Filters and change the application property to After auto aggregation.