how to test the reports if there are multiple sql
statements?i,e if there is 1 single sql statement we can
copy it and paste it in TOAD or someother tools to test it
but if we have multiple sql statements in a single query????
Answer Posted / shamanth
Should be clear what meant by multiple SQL staements ?
We can take the multiple SQL stmts and paste them to TOAD
and test.
When WEBI generate multiple SQL stmts(Combined
Queries),those should be either Union,intersect etc...so
the same will be applicable for TOAD also...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
how to create reports on screech?
what will be the contents for a functional requirements specifications
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
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?
What is the difference between datawarehousing and businessintelligence?
Explain what are the steps to do to use alerts 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 is the difference between the public object&schema object?
in sap bi we have wad, then why we go for sap bo
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What are all difference between business objects 6.5 and xi r2?
U r project in which stage in implementation?