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

How to join multiple db in catalog?

968

---

tell me two or three issues from client side and how to solve those issues?

2122

---

Can you define cube?

984

---

What is the metric store database?

931

---

Explain the difference between native sql and cognos sql?

953

---

What are slice and dice?

889

---

Give the advantages of cognos?

998

---

What is a Cube?

1090

---

can we insert all types of charts in a list report? what r the realtime prompts?

2173

---

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

1336

---

--------------Diff b/w ODS and OLAP?

3163

---

9. What was the most complex type of report you dealt with?

2166

---

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

2078

---

Why need staging area database for dwh?

1038

---

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

1997

---