12. Report is running very slow and How do you increase its performance? 1

12. Report is running very slow and How do you increase its
performance?

13. In infoview, I want to provide the hyperlink to view the
report in pdf format or other format. is it possible to do it.

14. There is one report and need to add new cloumns which
are not there in database. what is your approach.?

15. Did you face any ambiguous queries and how do you fix it?

Question Posted / siddu.cherla

3 Answers
12439 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

12. Report is running very slow and How do you increase its performance? 13. In infoview, I wa..

Answer / gs2kumar@gmail.com

Manasa enti ee Nasa qustion enti nuvvu cheppe answer enti?

Is This Answer Correct ?

0 Yes

0 No

12. Report is running very slow and How do you increase its performance? 13. In infoview, I wa..

Answer / gowthami

12. If the report is running slow check the query and correct the problems in joins and loops
Remove unwanted unused objects from report result objects
Remove unused variables from report
Try to use query level filters and not report level filters (Because query level filters restrict the data at DB level itself whereas report level filter allows all data to be executed which will take some time and then it will restrict it at report level)
Try to avoid derived tables at universe which will reduce the performance.

13. I think it is not possible to get the pdf view open through hyperlink. Navigation of one report to another report is possible through hyperlink functionality.
14. You can add columns by following the steps right click  add columns create a variable and assign that in that newly created column

Is This Answer Correct ?

0 Yes

0 No

12. Report is running very slow and How do you increase its performance? 13. In infoview, I wa..

Answer / manasa

12A.we increase the performance of the report first of all we resolving join path pbms.These are loops,chasmtrap,fantrap.Resolving these pbms we use alias's for tablas and provide context's for that tables then we resolving join path pbms,after that performance of the record is automtically increses.

13A.In infoview we use hyperlink for navigate from one document other document,from one report to other report,and from one block to other block.

14A.we want to add new columns to the report these are the steps: goto the toolsmenu -> click on new -> create one report after that in resultobjects click at the end of the column of the table -> rightclick -> click on insert new columns to the right.
observe the result on resultsobjects.

Is This Answer Correct ?

1 Yes

3 No

Post New Answer

More Business Objects Interview Questions

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

0 Answers

What is shortcut join?could give any one example?

8 Answers

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

0 Answers iNautix, Wipro,

REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

0 Answers

what is report tracing in bo

5 Answers Satyam, TCS,

What is domain? How many are there in a basic setup? What are they?

1 Answers

What is the definition of derived table ?

2 Answers JPMorgan Chase,

what is diff between Decode and case ? Give some Example?

2 Answers

What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...