what is tuning of business reports ?
Answers were Sorted based on User's Feedback
Answer / prakash
Are you asking Business Objects reports tuning, if "Yes"
then, the answer is
- By reducing the number of variables
- By reducing the number of Data providers
- By pulling the exact amount of the data from the database
- By reducing the complex variables
- Do not check the "Refresh on open " report.
these are the some of the possible ways of tuning the
reports.
| Is This Answer Correct ? | 35 Yes | 1 No |
Answer / v.sivakumar
To add some with the before answers
Avoid Using objects from dreived tables.
Reduce the joins in the query.
Create index in the database level.
Apply the filter Properly as per the logic
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / naveen.g
using prameters in universe level.
creating view in database level.
creating index in database leavel.
increasing araay fetch size.
increasing arry bind size.
using correct operator,expression in report level.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / gowthami
Removing unwanted objects from BO query panel
Removing unwanted variables
Prefer to prompts instead of drill filters or input control or block filters
| Is This Answer Correct ? | 0 Yes | 0 No |
In banking domain how many Fact tables,Dimension table are present?
main purpose of aggregate awareness(not include make possible of use of aggregate tables)
How many tables can an universe contain is their any limit to insert tables in the universe?
can i use stored procedure in webi?
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.
From Business Objects Web-I reports, we can link to other BO reports using Opendoc functinality. How do we link to reports in other reporting tool or how to give a link any website?
I have a report with some hyperlinks,any issue will i get when i migrate this report?
Who launches the supervisor product in Business Objects for first time?
What is the difference in creating filters in designer and business objects?
how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this
tell me about aggregate awareness in detail?
What is casual dimension?