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????
- 1 Answers
- 4356 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is a category?
what is fantrap?
When we go for OLAP , and When we go for OLTP for generating the reports ?
What is the use of linling the universes?Thanks in advance
how to improve the performance of the report
Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?
Difference between zabo and webi?
What is a fantrap in business objects?
Explain what are the measure objects?
1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?
Teradata 
