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 |
if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
how can u find the granularity in fact table
can i link two Universes having with different connection
what will be the contents for a functional requirements specifications
I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process
how will you move the universe/report from development to production?
any difficulitis have you phase while creating bo reports and how did u solve it
Anyone suggest where can i get SAP Business Objects dumps for the below: C_BOE_30 C_BOWI_30 C_BOWI_40 C_BOBIP_40 C_BOBIP_41 C_BODI_20 C_BOSUP_90
What is the difference between the public object&schema object?
Explain about a time when you discovered a more efficient way to do a work task?