Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is a fantrap in business objects?

1161


What is package in BO

3187


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

4706


What is the profile and package?

2278


What sort of existing documents should business analysts refer to when starting on a new project?

1000


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

1055


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

1010


what is xcelsius architecture?

4567


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

1119


Explain the difference between union and group?

1085


Can anybody tell me what are the tuning problems?

2032


Explain how we drill up week to month?

1076


can anybody tell me about complicated object you have created

3209


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

3680


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

2145