How to improve the performance of the report at the report
level?
- 3 Answers
- 4366 Views
- I also Faced
- E-Mail Answers
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 content store?
How to improve the performance of the report at the report level?
How to apply securities for reports in cognos connection?
how can you get the errors in job? when loops are araised we get error?
What is looping and how to avoid it in framework manager?
What is Additive function?
After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?
what are versions of cognos from starting release to latest in the market?
What is drill down and slicing and dicing whats the difference between them?
how to hide a particular pages at time if you get blank pages
How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
Teradata 
