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

What is meant by ZABO and FC(full-client)?

2 Answers  


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers  


Give some information on report bursting?

0 Answers  


what r the advantages of creating the universe?

2 Answers  


Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?

2 Answers   TCS,






Is it possible to develop reports without Universe access?

7 Answers   IBM,


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  


what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance

2 Answers   IBM,


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

1 Answers  


How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.

1 Answers   Cap Gemini, TCS,


My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?

3 Answers   TCS,


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

0 Answers   Polaris,


Categories