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

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

3 Answers  


I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.

2 Answers   L&T,


What we need to discuss with designer before starting the universe designing.

0 Answers   BMC,


When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?

4 Answers   IBM,


6.what is conformed dimension? R u used?

8 Answers   TCS,






Hi ,how many shortcut joins used in a single universe? Thanks in Advance

2 Answers  


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

0 Answers  


is there any limit for rows and columns in cross tab

4 Answers  


1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?

1 Answers   Virtusa,


use scheduler to refresh report.....explain please.....

2 Answers  


What is Complex Reports?

3 Answers   TCS,


if the project is assigned for you and the client said yo wait for a month,What will you do in that time?

1 Answers  


Categories