How can we improve performance?

Answer Posted / tilak

1)usinf aggregated tables
2)using shortcut joins
3)removing unwanted classes and objects
4)removing unwanted joins
5)lov should be based on smaller look up tables

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differences between business objects and web intelligence reports?

651


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

3256


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

596


What are the data types present in bo? What happens if we implement view in the designer and report?

614


Explain about a time when you discovered a more efficient way to do a work task?

636






How to create Index to the table in the universe designer and how it improves the Query performence

2113


Explain what task is 98% of the required work of a business analyst?

598


explain in detail about type 3?

621


Explain what is the difference between slice and dice and cross tab report?

604


What would you consider as your biggest achievement and why?

612


What is the difference between user and versatile user?

577


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

543


What is the difference between absolute and relative div positioning?

576


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

691


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

677