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
What are the components of report net?
What are types of batch available in cognos?
What is a Framework manager?
Can you explain cognos planning?
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?
What are the roles defined by cognos platform?
What are the different types of reports present in cognos?
What is the difference between ‘macro’ and ‘prompt?
What is metric store database?
What is catalog and types of catalogs in cagonos and which is better?
How can I test reports in cagonos?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What is defined as catalog and types of catalogs in Cognos?
Cleared COG-112 with 100% score today. What next certification should i go for?
What is the use of powerhouse?