what is difference btw summary filter and detail filter,
plz explain with example

Answer Posted / ranjan mishra

Basic difference between Detail and Summary filter in terms
of SQL formation is:-

Detail filter comes under Where Clause

And

Summary Filter comes under Having Clause after Group By

Is This Answer Correct ?    61 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a cascading report and drill through the report?

735


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1289


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1562


What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

1620


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

1977






How Metrics Studio is better than Report Studio?

2034


What is difference between content store and content manager?

549


What are initial page components of Cognos connection?

612


Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

1759


how to test reports in cognos?

592


what is degenerate key in oracle ?whare do we use it?

2067


What is drill down and slicing and dicing whats the difference between them?

550


-----------------What is Direct and Conventional loading?

1650


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......

1532


how can you get the errors in job? when loops are araised we get error?

1658