How do we impliment Details Filter, Summry Filter in Repot Studio or FM?

[Cognos.Developer]

Hi Friends,

I want to know what is the main Difference between Details Filter and Summry Filter?
At what what situation we impliment, Please explain clearly.

Thanks
Kumar

[meeecog]

This is what mentioned in IBM help..


When you use a detail filter to filter a report only on detail data items, none of the data items in a detail filter are summary data items. Examples of detail data items are product, order number, and customer name. You can filter detail data items that you select from a query or a catalog. A detail filter applies one or more specified conditions to each row of data. If the conditions are true for a row, the row is retrieved and appears in the report; if the conditions are not true, the row is not retrieved and does not appear in the report.

A summary filter is used to filter summary data items in a report. Before you create a summary filter, you must calculate the summary data items that you want to use in the filter. Summary data items that you include in the filter are calculated before the filter is applied while summary data
items that aren't in the filter are calculated after the summary filter is applied. You can filter summary data items that you select from a report query or the catalog.

[Cognos.Developer]

Hi MEECOG,

Thanking you for responding.

I want to very clearly with example of output.
In IBM Help, they covered therotically but I want to know the Purpose of usage of both Filters in practically.


Thanks
Kumar

[Raghuvir]

hi Cognos.Developer


lets take a small example, suppose you have the following data

Country   City                   Revenue in millions
Japan   Toyokawa   5000
   Tsushima                   10000
   Hekinan                   15000
   Kariya                   20000
Total                      50000

China   Shanghai                   10000
   Beijing                   20000
   Tianjin                   30000
   Kariya                   40000
Total                      100000


when you use a detail filter, only the detail items would get filtered, here for e.g if you want to filter out cities with revenue > 5000 then your output would be

Country   City                   Revenue in millions
Japan       Tsushima                   10000
   Hekinan                   15000
   Kariya                   20000
Total                      50000

China   Shanghai                   10000
   Beijing                   20000
   Tianjin                   30000
   Kariya                   40000
Total                      100000

where as if apply a filter for countries whose revenue is greater than 50000 then you will use a summary filter on country and your output would be

Country   City                   Revenue in millions

China   Shanghai                   10000
   Beijing                   20000
   Tianjin                   30000
   Kariya                   40000
Total                      100000


i hope this will be helpful.

Regards

[Cognos.Developer]

Hi Raghuvir,

Thanking you your Helpful Explanation.

& I would like know how do we apply the Scope while filtering.

ThanksKumar
Cognos Developer