how to improve the performance of the report

Answer Posted / vams_gk

to inprove the performence of the reports we have multiplw
ways in my view. for example

1)generate LOV for required objects
2)use aggregate tables in universe design
3)use pre defined conditions and formulas.
4)check context (if there resolve it)
5)check loops (if there resolve it through alias table)


if u did u all these at universe level,when u generate the
report at query panel level automatically performence will
increese

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

690


Explain is there any default username & pwd for bo designer & supervisor?

593


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

992


Explain is data mart?

588


Did you face any problems while creating reports? Name? Solutions?

3256






What is the difference in creating filters in designer and business objects?

584


What is a fantrap in business objects?

577


What are the join problems comes appart from loop,chasm & fan Traps

1548


Explain the data types present in bo and what happens if we implement view in the designer and report?

558


What would you consider as your biggest achievement and why?

615


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4319


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

1968


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)?

539


Explain what is aggregate table and aggregate fact table ... Any examples of both?

603


How to open a universe with out using the Designer ??

6605