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

What is the size of the cube?

976

---

What do you mean by drill through report?

968

---

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2695

---

i was asked what are the caluclations done by you in your report? plz give reply

2195

---

------------ Diff b/w MemberCaption and MemberDescription?

2319

---

Can you define confirmed dimension?

1085

---

Write some methods to apply securities in framework manager model?

1121

---

hi friends pls forward impropmtu interview question

2130

---

What is Bitmap Index?

1052

---

Explain is there any comparison available for cognos reportnet vs crystal reports?

965

---

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1921

---

Can you explain the advantage of using shortcuts?

1030

---

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1991

---

How is cognos model organization works?

1094

---

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1838

---