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 |
1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2
What is the server based ranking? and its usage?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?
How many universes are required for a single project,and how many reports are required for a single Universe.
how to connect one to one report? Explain with example?
How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
What type of schemas did you use in your project?Andwhy did you use that schema
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
How will solve a loop caused by lookup table without using alias?
What is the link option in the reporting Environment?
what is optional prompt in boxi r2