Interested to Buy Any Domain ? << Click Here >> for more details...
if we run a report it is taking so much time to display the
report,what to do to increase th performance of the report
- 3 Answers
- 7917 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srikanth
Remove unnecessary objects and variables if any.make sure
you remove alerters if any unless it is the
requirement.Take the report query and run in Database.See
how much time its taking.From report query check whether
in 'where' clause columns have indexes.If not discuss with
oracle admin and add indexes.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ilaw
If the question is not pertaining to query optimization, I
would prefer not to use much of formatting on the page. One
can keep the report without any page formatting as this
would take a very long time. Try not to use the slice &
dice panel as this would also take considerably long time...
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vams_gk
if we run a report it is taking so much time to display the
result to be fallowed as :
1) use aggrigate tables(contains pre caliculated data)
2)pre defined conditions,LOV's
3)in a real time senario query contains a large if
statements.some times we need to wait max of 30 min to run
perticular statement...not all
| Is This Answer Correct ? | 1 Yes | 1 No |
Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example
What is Universe?
what is performance tunning in BO in report level& designer level?
tell me about aggregate awareness in detail?
difference between xir2 and 6.5 version
WHAT IS CARDINALITY?
What Is The Difference Between Oltp And Olap?
can you use inputbox in BOXI. e.g. checkbox,textbox etc.
Steps to create alias and apply
can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.
Explain which versions are used in the bo dashboard work?
Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik
Teradata 
