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

Have you worked with multiple data sources? If yes. How do you link them?

1 Answers  


How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

1 Answers   Emphasis,


What is maximum number of promts we can give in a BO report?

1 Answers   Patni,


how do you give security to universe ?

2 Answers   InfoStep, Tech Mahindra,


how to optimize the query perfomance in b.o?

1 Answers   TCS,






What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 Answers  


Hi friends, How many types of dimentions are they ?What are they? Thanks in advance

5 Answers   Mind Tree,


1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2

3 Answers   CTS,


What are the differences between webi and deski of XI R2 not the earlier versions

1 Answers  


1.what is input level context and output level context in webI? 2.what is a cascading prompt? Where will you give this and how? 3. What is External Strategy?

1 Answers   IBM,


WHAT IS SYNCHRONIZATION IN BOXI?

2 Answers   HCL,


How many built-in objects are created in Business Objects repository?

2 Answers  


Categories