Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference btw summary filter and detail filter,
plz explain with example
- 10 Answers
- 54230 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
What are the different uses of a repository manager?
what is the difference between native sql and cognos sql?
What is Bitmap Index?
How to do Performence Tunning in Cognos Reports?
What is meant by alternate drill down with ex?
When we save a report in report studio with what extn it save?
What do you understand by the term 'aggregate cache'?
What is the difference between drill through, drill across?
-------------What is Coditional Prompting?
hi friends pls forward impropmtu interview question
2. What functional area you worked on.
What is called a slice?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
can you tell me what are the dimension tables are used in project
what is a prompt value in report studio and variables ?
