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 stitch query in reportnet?

1155

---

How create measures and demensions?

1089

---

Can you define bitmap index?

1123

---

What is main advantage datawarehousing over oracle?

1039

---

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

2066

---

Can you define cube?

1085

---

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4802

---

Can you define drill down and drill up?

1075

---

What are the batches and it’s details?

1019

---

How is cognos model organization works?

1151

---

What do you understand by the cognos?

1018

---

Is it possible to join multiple Databases in a Catalog?

1161

---

7. What is performance tuning?

2050

---

How can I test reports in cagonos?

1012

---

Explain what is the main advantage of impromptu over cognos reportnet?

1087

---