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 |
how many micro cubes can a report can have
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?
HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..
Can we link the oracle and excel universess?
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?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
how to test reports in businessobjects?
1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?
Can any body tell me,What is the universe testing ? What is the report testing Explain?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?