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 |
what are the roles and responsibilities of BO Administrator ?
1 Answers OCS Infotech, TCS, Wipro,
Is it possible to develop reports without Universe access?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Types of universes in business objects?
What is the merge dimension?
What is Complex Reports?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What are the types of errors you faced while creating a report from two different data providers
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
how will you move the universe/report from development to production?
Is it necessary to give joins to the aggrigate tables in the universe?