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
Answer Posted / 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 |
Post New Answer View All Answers
Explain in detail about type 2(scd),
What is the difference in creating filters in designer and business objects?
Explain what is the difference between business requirement document and use case document.
What is aggregate table and aggregate fact table ... Any examples of both?
What sort of existing documents should business analysts refer to when starting on a new project?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What is the functional & architectural differences between business objects and web intelligence reports?
How to execute the plsql procedure from the report by clicking with mouse?
How we drill up week to month?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
How many universes can be created in a project?
Explain when to use local filter and when to use global filter?
How to generate the report from excel sheet?
What is the difference between datawarehousing and businessintelligence?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?