Interview Questions   Tutorials   Discussions   Programs   

Cognos - What are the Advantages of detailed filter and summarized filter?




843
views
asked mar October 4, 2014 10:00 AM  

What are the Advantages of detailed filter and summarized filter?


           

1 Answers



 
answered By vishnoiprem   0  

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 you select from a report query or the catalog.

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert