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
- 53966 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 |
What is Lookup ,bridgeing tables where they will use in the Dataware house
How do you test the performance of a report?
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha
How to schedule the report in Cognos? And i have 2 users u1,u2. how to schedule the report for these 2 users(the 2 users will get result once for a week) but u1 get the result on every monday to his inbox,and u2 get the result on every wednesday to his inbox.
Difference between cognos report net and cognos8
What snowflake and Starschema?
What are all the types of indexes in Cognos?
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.
4 Answers Accenture, HCL, IBM,
Can you define folder?
how can you set the image in the report
Teradata 
