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
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain difference between zabo and webi?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What is the difference between absolute and relative div positioning?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
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
Explain what is the difference between slice and dice and cross tab report?
Can Bo generates the Report from the cubical data Explain?
What task is 98% of the required work of a business analyst?
what are the tables used in health care domain project and columns used in report?
Explain which versions are used in the bo dashboard work?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
When we use aggregate awareness function in designer?