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 |
Can we link the Universes from two different sourcess?Explain?
hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??
HOW TO SPOT A HIERARCHY?
Can any body will explain about sarrogat key? Thanks in advance...........Prakash
How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?
i want to hide a chart in reporting level? i want to hide a prompt in designer level?
I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same
There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
. User wants to modify a report and wants to add additional data. How will you approach.
How we can add a comment in universe...?
how do we apply sql query on selected variables?