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

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.

Answer / nish

Hi Saj...
I think you have copied this answer from some other link...

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

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.

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.

Answer / sm

hi Vsandhyana,

I have a question....

Then whats is the difference a After Auto Aggregation
Detail Filter and a Summary Filter?

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.

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.

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.

How do you improve the performance of the Cognos Analytics report

0 Answers  

What is the advantage of using shortcuts?

0 Answers  

write a query to display to 10 max record from the employee table?

8 Answers   HCL,

APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT

5 Answers   Satyam,

What is the difference between group and associare?

0 Answers  

Column level security in report

4 Answers  

Explain informatica architecture?

0 Answers  

how can you set the image in the report

1 Answers   HSBC,

What is the use of Generated Prompt? Where is it used in realtime project?

3 Answers   HCL,

what is Cognos Visualizer?

1 Answers  

Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.

3 Answers   iGate,

What are shortcuts? Where it can be used? What are the advantages?

0 Answers