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 / 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 |
Post New Answer View All Answers
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain the difference between detect alias and detect context?
what is xcelsius architecture?
How many universes can be created in a project?
What is Indexing? how did u implement indexing?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
How to generate the report from excel sheet?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
How to restrict password to a user while sending a document in .pdf format
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Which versions are used in the bo dashboard work?
Can Bo generates the Report from the cubical data Explain?
U r project in which stage in implementation?
What is difference between custom hierarchy and report based hierarchy?
How to execute the plsql procedure from the report by clicking with mouse?