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 |
difference between web intelligence,crystal reports and desktop intelligents
1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?
WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT
9 Answers Business Intelligence Analytics, SRA,
How many built-in objects are created in Business Objects repository?
How to create universe in business objects enterprise 11.5
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
how to do Ad-hoc reporting ?
What are the Input and Output Context Operators.
working with Business Objects 6.1(a), i m facing a problem. when i save the BO report containing chart aswell as table in .xls then the null vlues in the table automatically are converted to 0, thereby istorting the chart also. please provide me the solution as soon as possile.
how many reports have u created ? explain a few.
0 Answers Bank Of America, TCS,
While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.
How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.