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
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is package in BO
What is aggregate table and aggregate fact table ... Any examples of both?
Explain what are the steps to be taken to schedule the report?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain about a task that really tested your analytical abilities?
What are the data types present in bo? What happens if we implement view in the designer and report?
When to use local filter and when to use global filter?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Can we create universe with no cache??
How to execute the plsql procedure from the report by clicking with mouse?
Explain when we use aggregate awareness function in designer?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Give some information on report bursting?