how to optimize the query perfomance in b.o?



how to optimize the query perfomance in b.o?..

Answer / srinivas

hi

u can select the limit size of exegution is increase button
in universe parameters

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More Business Objects Interview Questions

In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.

5 Answers  


How will solve a loop caused by lookup table without using alias?

1 Answers   L&T,


why do we use crystal reports rather than webintelligence reports ?

7 Answers   CTS, Tech Mahindra,


Can i use personal database connection to the Webintellegence reports?

1 Answers   Infotech,


1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?

1 Answers   Accenture,






HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  


How to implement LDAP authentication in BOE

1 Answers   Infosys,


What are the steps to taken care to improve the Report performance?

3 Answers  


How to check for a particular value from one column with the list of values present in another column in Webi reports?

2 Answers  


explain merge dimensions with real time in DWH?

1 Answers   IBM,


it is possible to link two universes of separate functional domain ?

1 Answers   IBM,


what is difference between folders and category ?

4 Answers   Tech Mahindra,


Categories