what is tuning of business reports ?
- 5 Answers
- 10195 Views
- Business Intelligence Analytics, Oracle, TCS, I also Faced
- E-Mail Answers
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 I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?
i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What sort of existing documents should business analysts refer to when starting on a new project?
Is there any other repository domains rather than universe, security, document?
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
What are the steps to taken care to improve the Report performance?
how do u resolve contexts ?
What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Hi All, If anyone of you had very Latest & Authentic BUSINESS OBJECTS - XI Certification Dumps for the below Codes, can you please forward it to me, its really very urgent to me SABE 201, SABE 301, SABE 401, SABE 501V3.0 Thanks Mohan
Teradata 
