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 Posted / 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 View All Answers
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What are the join problems comes appart from loop,chasm & fan Traps
Did you face any problems while creating reports? Name? Solutions?
What is the difference between slice and dice and cross tab report?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
explain in detail about type 3?
Explain the difference between union and group?
how to create metric universe ?
Can more than 1 metric be applied on an analytic in business objects?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What we need to discuss with designer before starting the universe designing.