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
what is universe null
Explain how many universes can be created in a project?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is the difference between datawarehousing and businessintelligence?
Explain when we use aggregate awareness function in designer?
how get the grand total in master-detail report?
What is package in BO
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What is the difference in creating filters in designer and business objects?
how many reports have u created ? explain a few.
Explain is there any other repository domains rather than universe, security, document?
What is top business?
Explain what are the steps to do to use alerts in bo?
What Is The Difference Between Oltp And Olap?