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
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
how to connect datamarts
What do you mean by Drill down and Drill Up?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
What do you understand by ‘ibm predictive maintenance and quality’?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What is difference between data mart and data warehouse?
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......
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
Can you explain cognos planning?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
what is log in cognos?
Mention the difference between ‘macros’ and ‘prompt’?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt