Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve the performance of the report
- 3 Answers
- 6911 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vams_gk
to inprove the performence of the reports we have multiplw
ways in my view. for example
1)generate LOV for required objects
2)use aggregate tables in universe design
3)use pre defined conditions and formulas.
4)check context (if there resolve it)
5)check loops (if there resolve it through alias table)
if u did u all these at universe level,when u generate the
report at query panel level automatically performence will
increese
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / ratnakar neti
To improve the performance of Reports we have to check the
following .
1.check the number of subreports.If more number of
subreports are there it will kill the performance of the
report
2.check the loops. We have to reduce the no.of loops to
increase the performace of report
3.generate the Lov's
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / babu
Report performane will improve by the given following
things.
1. Should disable LOv's for unnessary measure objects.
2. Create conditions at Universe level and try to reduce
the variable's and bulit complex logic's in universe and
database level.
4. use query level filters.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the traps ? What are the disadvantages of traps?
how to overcome overflow of data in a report
What are the differences between webi and deski of XI R2 not the earlier versions
What is a bo repository?
why do we use crystal reports rather than webintelligence reports ?
What is the difference between business requirement document and use case document.
how can i add two different reports in the same document?
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
what is performance tunning in BO in report level& designer level?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
how to make a report avilable to other users?
Instead of cms which server you have to use?
Teradata 
