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


Please Help Members By Posting Answers For Below Questions

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

593


What is the dense rank?

679


Explain about a time when you discovered a more efficient way to do a work task?

643


Which versions are used in the bo dashboard work?

603


What is Indexing? how did u implement indexing?

1820






What is top business?

569


how get the grand total in master-detail report?

1819


What are the data types present in bo? What happens if we implement view in the designer and report?

622


Explain what are the measure objects?

553


What Is The Difference Between Oltp And Olap?

682


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1583


How to restrict password to a user while sending a document in .pdf format

1866


Explain what is the difference between slice and dice and cross tab report?

609


Explain the difference between detect alias and detect context?

629


Explain what is the difference between business requirement document and use case document.

579