Interested to Buy Any Domain ? << Click Here >> for more details...
How to Improve the Performance of the Report? i need this
urgently .
- 4 Answers
- 11580 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / kumar
1. check the governor settings.
2.Avoid using 'NOT' function in the query
3.Avoid using more no:of filters, complex calculations and
complex reports.
4.Move all the calculations and filter conditions from
report level to FM level.
5.Check the client server balancing
6. check the table qualifying and weighting
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Explain difference between powerplay transformer and power play reports?
What is Metrics designer?
What do you mean by drill across?
What you mean by drill across?
What are the types of studio present in Cognos?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Define the slice and dice?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
Can you define dimension?
Write types of folders present in cognos?
Can you explain a cognos controller?
Explain what is the difference between native sql and cognos sql?
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.
how to perform single sign in cognos by using url?
Can you explain the advantage of using shortcuts?
