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 to create Events?

1 Answers  

What is the difference b/w macros and prompt?

0 Answers  

Why need staging area database for dwh?

0 Answers  

hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.

0 Answers  

i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....

2 Answers  

What is the difference between filter & Condition?

4 Answers   IBM, Polaris, TCS,

what is cardinality that you can give to employee and department query subjects in framework manager?

2 Answers   HCL,

can any one explain about blue prints&performance tuning in cognos? 

1 Answers   TCS,

cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer

5 Answers  

What is the complex report you faced in real time?

0 Answers  

What is the difference between the content store and content manager?

0 Answers  

How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.

4 Answers   TCS,