what is difference btw summary filter and detail filter,
plz explain with example
- 10 Answers
- 51274 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
Can you define transformer?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What is meant by alternate drill down with ex?
what are the special features in cognos reportnet?
what are the features in cognos8ui
How is possible this scenario using in type-in prompt.?
What do you understand by the cognos?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is difference between primary key and unique key constraints? What is catalog and types of catalogs in cagonos and which is better? Can you define drill down and drill up? What is the difference between Standard and Metrics folder? What are the message flows? What is the deployment requirements used in cognos?
