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
Explain about a tricky situation for which you found a very simple solution?
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 restrict password to a user while sending a document in .pdf format
what will be the contents for a functional requirements specifications
How would you format some text using css to be verdana and bold?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What is the difference between the public object&schema object?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain about a task that really tested your analytical abilities?
What would you consider as your biggest achievement and why?
Is there any other repository domains rather than universe, security, document?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain how to schedule the report in b.o?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Explain what is the difference between slice and dice and cross tab report?