Explain the SQL Queries activated to data base from Data
provider in BO ?



Explain the SQL Queries activated to data base from Data provider in BO ?..

Answer / kishore

BO automatically generates the SQL query when objects are selected into query panel. When you run the query, the query is processed to database based on your connectivity.for ex: If you run query using, Local Machine Full Client (BO reporter), the query directly connects to database through midillewareFull Client <---> DatabaseIf you run query using Webi, the webi browser will connects to Web Server and Webserver will proces request to Database.WEBI <--->Web Server <---> Database

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Business Objects Interview Questions

1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2

3 Answers   CTS,


What is the server based ranking? and its usage?

2 Answers  


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

0 Answers  


while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?

2 Answers   PWC,


How many universes are required for a single project,and how many reports are required for a single Universe.

2 Answers  






how to connect one to one report? Explain with example?

5 Answers   TCS,


How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.

1 Answers   Cognizant, WinAlliance,


What type of schemas did you use in your project?Andwhy did you use that schema

1 Answers   IBM,


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

2 Answers   HCL, IBM,


How will solve a loop caused by lookup table without using alias?

1 Answers   L&T,


What is the link option in the reporting Environment?

3 Answers  


what is optional prompt in boxi r2

4 Answers   Mind Tree,


Categories