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

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

2363


what is universe null

2364


What are the steps to do to use alerts in bo?

1320


how get the grand total in master-detail report?

2172


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2039


what is document design in boxi,have u participate in that

2081


Which versions are used in the bo dashboard work?

980


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...

2096


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

983


How to generate the report from excel sheet?

1112


explain in detail about type 3?

951


Explain when to use local filter and when to use global filter?

1300


Explain what would you consider as your biggest achievement and why?

922


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

967


What would you consider as your biggest achievement and why?

958