what is difference btw summary filter and detail filter,
plz explain with example
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 |
1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?
what is query subject
how to access the database directly from cognos reportnet
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
what are determinants?
Difference between Express authoring mode and Professional authoring mode?
write the sql query to display 5th and 10th row in a table?
What is catalog and types of catalogs in cagonos and which is better?
When we save a report in report studio with what extn it save?
Column level security in report
dumps needed ASAP for - C2020-180 Cognos IBM Certification
Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com