Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

Question Posted / guest


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 static filter and dynamic filter

1 Answers  

How to change font color of values in hyperlinked columns?

4 Answers  

What is metrics?

2 Answers  

how to restrict up to three levels in hierarchy when u do drill mode?

3 Answers   iGate,

what is the syntax for aggregate awareness?

3 Answers   Exilant, i-Tree, Wipro,

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 create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".

3 Answers  

Can anybody pls provide me Business Objects Certification (SABE201) Study material and dump. Pls. My email id is reshma.toppo@gmail.com......Thanx

4 Answers  

how to improve the performance of the report

3 Answers  

Can Bo generates the Report from the cubical data Explain?

0 Answers   Wipro,

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

1 Answers   IBM,

what is difference between global filter an query filter in web intelligence?

3 Answers  

For more Business Objects Interview Questions Click Here
Categories