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
How to apply securities for reports in cognos connection?
Can you define fan trap?
What is the difference between a cascading report and drill through report?
What are all the types of gateway used in Cognos?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
What is the difference between the content store and content manager?
How is cognos model organization works?
Which studio is used to create reports?
Write various indexes used in cognos?
What is difference between content store and content manager?
Can you define a datastore in cognos?
what is the difference between filter and condition?
Why is auto-regression used in forecasting used on cognos platform?
What are the services provided in cognos 8?
Cleared COG-112 with 100% score today. What next certification should i go for?