what is difference btw summary filter and detail filter,
plz explain with example
Answer Posted / navneet singh
Detail fiter is applied to whole body of the report.
Summary filter is applied to only at footer level.
For Example if we take Product Line, Product Type and Price
and then take total on Price and apply the filter saying
Price > 20000 (detail Filter) then its going to display
those values which are greater than 20000 in body.
It will be oppsite in Summary Filter i.e for summary footer
its going to check the value which is greater than 20000 at
footer level.
| Is This Answer Correct ? | 60 Yes | 16 No |
Post New Answer View All Answers
When we save a report in report studio with what extn it save?
Explain the different types of views used in cognos.
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
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......
what are the names of the reports that you prepared?
What is main difference mapplets and mapping?
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?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
Can you define fan trap?
faq's on cognos
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
------------------What is Inline Query?
How do you call a store procedure within a transformation?