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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

2995


Difference between b.o 5.1 and 6.1b?

647


what will be the contents for a functional requirements specifications

1780


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?

552


How to generate the report from excel sheet?

583






Explain what task is 98% of the required work of a business analyst?

598


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1881


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

586


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

4441


Can you please send me the migration related issues .

1642


What is the difference between condition & filter?

605


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

598


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9431


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

3843


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

814