Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference btw summary filter and detail filter,
plz explain with example
- 10 Answers
- 54526 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ranjan mishra
Basic difference between Detail and Summary filter in terms
of SQL formation is:-
Detail filter comes under Where Clause
And
Summary Filter comes under Having Clause after Group By
| Is This Answer Correct ? | 61 Yes | 8 No |
Answer / navneet singh
Detail fiter is applied to whole body of the report.
Summary filter is applied to only at footer level.
For Example if we take Product Line, Product Type and Price
and then take total on Price and apply the filter saying
Price > 20000 (detail Filter) then its going to display
those values which are greater than 20000 in body.
It will be oppsite in Summary Filter i.e for summary footer
its going to check the value which is greater than 20000 at
footer level.
| Is This Answer Correct ? | 60 Yes | 16 No |
Answer / nish
Hi Saj...
I think you have copied this answer from some other link...
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / vsandhyana
hi manju,
you are correct but not explained your answer well.
it's true that detail filter is used before aggregation and
summary filter is used after aggregation.
just look the explanation below:
lets say that for product A we have three quantity values
10,15 and 18 for product B values are 20,19,11 and so on ..
we set the aggregation total on field quantity .
Detail Filter:
if we group by the quantity on product than we will get the
value 43(Sum of the values) for product A and 50 for product B
if i have applied a filter (quantity >16) and applied on
before aggregation than we will get the output value for A
is 18 and for product B the value is 39 here in both product
A and B we have filter out the values less than 16.
Summary Filter:
if we have applied the same filter on after aggregation than
the output for product A is 43 and for product B is 50. here
we have not filter out any values because the filter is
applied on the product after aggregation.
and u have applied a filter price>=30 before aggregation
than output is
30
| Is This Answer Correct ? | 10 Yes | 4 No |
Answer / sunil.h.b
Detail Filter is used to Filter detail level values within
a report and Summary Filter is used to filter summary level
values within a report.
| Is This Answer Correct ? | 20 Yes | 17 No |
Answer / viswa
After auto aggregation : It means the values are filtered
after the aggregation performed.
Detail Filter : It filter the data before the aggregation
takes place.
Summary Filter : To perform this one, first we should have
to group one column for ex. take country & qty. first group
the country column then perform aggregation on qty then
apply the summary filter. Summary filter takes place after
the aggregation.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / sm
hi Vsandhyana,
I have a question....
Then whats is the difference a After Auto Aggregation
Detail Filter and a Summary Filter?
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / saj
Summary and detail filters both sets of criteria you apply
to a report to change
the focus of the report. You can use a filter to emphasize
information that is important
to you by filtering out what is unnecessary.
The differences between summary and details filters are as
follows:
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 select from a report
query or the catalog.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / manju
Before aggregation we can use detail filter and After
aggregation we can use summery filter.
For example:There is one calculated query item values like
10
20
30
40
50....likewise.
if you apply detail filter we can get every indudual values.
Fom above example we can get 10 or 20 or 30 or 40 or 50.
If you apply summery filter we can get total of values.From
above example we can get 150.
I think it is correct.If it is wrong please let me know.
| Is This Answer Correct ? | 10 Yes | 18 No |
Answer / raiders
Filters have nothing to do with aggregation. Both filters
only affect data in the selected query. Summary filter can
only be applied to the columns within the query while
detail filter can be applied at a lower level to any column
in the package.
| Is This Answer Correct ? | 2 Yes | 10 No |
Write various indexes used in cognos?
Which studio is used to create reports?
What is difference between primary key and unique key constraints?
if there are list,crosstab,chart how can you apply a single filter to all object?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
What is stitched Query?
Is it possible to create drill through access to other report from PDF report?
what is catalog and types of catalogs in cagnos and which is better?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
Which service handles requests for cognos connection,query studio and event studio.
how to create calculate column in report studio
Teradata 
