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????



how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statemen..

Answer / 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

More Business Objects Interview Questions

why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.

7 Answers   Satyam,


11.what are the features in BO?

2 Answers   IBM, TCS,


Who launches the supervisor product in Business Objects for first time?

2 Answers  


Can any please explain FOR EACH AND FOR ALL?

2 Answers   HCL, Infosys, TCS,


Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.

1 Answers   TCS,






how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?

3 Answers   TCS,


What is the pragma?

2 Answers  


am a fresher hw to get real time experience?

1 Answers   Cap Gemini,


What is the difference between Thin client & thick client?

5 Answers  


HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?

2 Answers  


4.what is repository? types

8 Answers   TCS,


How to change the order of prompts in universe?

3 Answers  


Categories