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
- 53846 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 is the role of cognos comsultant?what actually it means?pls reply
What is the difference between ‘macro’ and ‘prompt?
What is Online View?
What is Additive function?
What is the difference between static and dynamic conditions?
Define dimensions?
is cognos 7 is better than cognos 8
What do you mean by Drill down and Drill Up?
What are products of cognos?
how to connect datamarts
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
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 are cognos connection initial page components?
Why cognos decision stream is used?
