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 / 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 |
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
Which versions are used in the bo dashboard work?
it is possible to link two universes of separate functional domain ?
What is ment by For each For all function. In which case we use the option in BO?
what are the documentations u r created?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
Difference between zabo and webi?
HI, can anybody explain me how performence will decrease if we create objects using derived tables ?
What are the join problems comes appart from loop,chasm & fan Traps
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?
difference between xir2 and 6.5 version
How to check for a particular value from one column with the list of values present in another column in Webi reports?