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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2597


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1751


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

584


Explain what is the difference between slice and dice and cross tab report?

602


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

3840






How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4317


What is the difference between absolute and relative div positioning?

576


what is document design in boxi,have u participate in that

1659


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

992


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1554


any difficulitis have you phase while creating bo reports and how did u solve it

2990


explain in detail about type 3?

621


Explain when we use aggregate awareness function in designer?

582


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

626


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2400