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 the size of the cube?
Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer
Can you define cube?
What is the function of cognos dispatcher?
how to hide a particular pages at time if you get blank pages
what are the dimensions that you have in your current project?list them?
-----------Diff b/w OLAP and RDBMS?
Can you define metrics designer?
what is the difference between aggregation and roll up aggregation?
Can any one give the example for slicing and dicing of data ?(with simple query)
How to move reports one server to another server?
what are the components having in the report studio using interface eg:insertable objects pan,properties pan