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

Title: How do we impliment Details Filter, Summry Filter in Repot Studio or FM?
Post by: Cognos.Developer on 18 Jun 2014 11:55:53 PM

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

Title: Re: How do we impliment Details Filter, Summry Filter in Repot Studio or FM?
Post by: meeecog on 19 Jun 2014 04:58:05 PM

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.

Title: Re: How do we impliment Details Filter, Summry Filter in Repot Studio or FM?
Post by: Cognos.Developer on 19 Jun 2014 11:18:58 PM

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

Title: Re: How do we impliment Details Filter, Summry Filter in Repot Studio or FM?
Post by: Raghuvir on 20 Jun 2014 02:38:30 AM

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

Title: Re: How do we impliment Details Filter, Summry Filter in Repot Studio or FM?
Post by: Cognos.Developer on 23 Jun 2014 12:21:58 AM

Hi Raghuvir,

Thanking you your Helpful Explanation.

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

ThanksKumar
Cognos Developer

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: Cognos.Developer on 18 Jun 2014 11:55:53 PM