How to improve the performance of the report at the report
level?
Answers were Sorted based on User's Feedback
Answer / venkat
Remove the unwanted joins and filters
and complex calculations we will do the all calculations in
the item level in Framework manager level
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / gopal
These are some properties to improve the performance
Apply
filters
Sorting
Grouping
if u have more than one Query set query execution Method = Concurrent in properties Pane of query explore.
and Query processing options -Date base and limited Local.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gauri
There are various things and they differ based on the case we are looking at.
Master detail relations defined on reports, having multiple singleton objects, poorly joined facts, in some cases having too many render variables also cause issues.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the considerations regarding performance kept in mind while setting up cognos?
what is the meaning of drill down and drill up in COGNOS 8BI
---------------What is meant by Scheduling?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
which type of project we r going to snowflake schema
Diff b/w Crossproduct and Outerjoin?
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
How to pass parameter value into html design page?
if u having 2 pakages i want a report with report items in 2 pakages how to use the 2 pakages in single report please ans me............
what are the applications of the tabular model ????
What is the difference btw reportnet - Report studio and cognos 8 - Report studio
The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.