what is tuning of business reports ?

Answers were Sorted based on User's Feedback



what is tuning of business reports ?..

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

what is tuning of business reports ?..

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

what is tuning of business reports ?..

Answer / satya

In a generic value report tuning is to give a final touch
to the report before putting it to production server.

Is This Answer Correct ?    6 Yes 4 No

what is tuning of business reports ?..

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

what is tuning of business reports ?..

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

Post New Answer

More Business Objects Interview Questions

Hi friends, How many types of dimentions are they ?What are they? Thanks in advance

5 Answers   Mind Tree,


What are the join problems comes appart from loop,chasm & fan Traps

0 Answers   IBM,


Difference between Object varification and validation

1 Answers   Cognizant,


which is the best way to resolve loop context r alias why?

3 Answers  


I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record

0 Answers   Flextronics,






1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?

3 Answers  


Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....

3 Answers  


What is ment by For each For all function. In which case we use the option in BO?

2 Answers   IBM, TCS,


CAN A REPOSITORY CONTAINS REPORTS?

7 Answers   AG Technologies,


can we create aliases for every table beforehand? if yes whar are the disadvantages?

5 Answers   AG Technologies,


Is there any other repository domains rather than universe, security, document?

0 Answers  


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

0 Answers  


Categories