what is difference btw summary filter and detail filter,
plz explain with example
Answer Posted / 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 |
Post New Answer View All Answers
what is the difference between native sql and cognos sql?
What do you understand by user class in cognos?
what is the difference between querystudio in reportnet and cognos8
Name the types of report?
What is the use of powerhouse?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What are the steps to import the two data sources in framework manager?
Can you define folder?
How the Bursting happens in same report and how to Print the bursting Report?
What is the difference between ‘macro’ and ‘prompt?
What is the enterprise class platform architecture of cognos 8?
What is the difference between a cascading report and drill through the report?
Can you explain dynamic query mode?
What is the information present in the cognos configuration file?
can you tell me what are the dimension tables are used in project