what is difference btw summary filter and detail filter,
plz explain with example
Answer Posted / viswa
After auto aggregation : It means the values are filtered
after the aggregation performed.
Detail Filter : It filter the data before the aggregation
takes place.
Summary Filter : To perform this one, first we should have
to group one column for ex. take country & qty. first group
the country column then perform aggregation on qty then
apply the summary filter. Summary filter takes place after
the aggregation.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Can you define fan trap?
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?
in u r data u having duplicates how to fetch the latest data in our report?
What are the batches and it’s details?
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
----------------Diff b/w Dimensional modeling and Relational modeling?
4. How many dimensions did you use in your reports?
What are the advantages of shortcuts?
what are slowly changing dimensions? Why we are used scd?
How do you call a store procedure within a transformation?
What are various types of gateways in cognos?
What is Online View?
is cognos 7 is better than cognos 8
What is the use of powerplay web viewer in cognos?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?