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 |
how to coneect to a server in a business objects
what is the difference btween olap and oltp?
Can we create universe with no cache??
What is difference between custom hierarchy and report based hierarchy?
Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.
1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment
What is the difference between business requirement document and use case document.
what is performance tunning in BO in report level& designer level?
Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva
What are the different types of connections?Explain?
what is the difference b/w star and snowflack schema in dataware house?
what is a filter?