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 |
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.
How will solve a loop caused by lookup table without using alias?
why do we use crystal reports rather than webintelligence reports ?
Can i use personal database connection to the Webintellegence reports?
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?
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?
How to implement LDAP authentication in BOE
What are the steps to taken care to improve the Report performance?
How to check for a particular value from one column with the list of values present in another column in Webi reports?
explain merge dimensions with real time in DWH?
it is possible to link two universes of separate functional domain ?
what is difference between folders and category ?