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 is Star schema group?
It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?
Cleared COG-112 with 100% score today. What next certification should i go for?
Can any one give the example for slicing and dicing of data ?(with simple query)
What is the difference btw reportnet - Report studio and cognos 8 - Report studio
What is a dimension?
Explain the different types of views used in cognos.
whis meant by Thumbnails on cagnos?
Define the cognos reporting tool?
How applying "Level Span" in Cognos 8.3?
What are the advantages and disadvantages of using Transformer cube?
what is the difference between filter and condition?