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 |
When we are going for Shortcut join and why.
What three things do you consider to be the most important factors for a manager?
What is the difference between the Bo 3.0 and 3.1?
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
When to use local filter and when to use global filter?
How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?
What is the drill up , drill down, drill by , drill trough ?
What is a universe?
Explain when we use aggregate awareness function in designer?
2.What is loop? How resolve the loop?explain it?
11 Answers TCS, UHG,
Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....
how to do Ad-hoc reporting ?