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
- 4340 Views
- IBM, I also Faced
- E-Mail Answers
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
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
what is xcelsius architecture?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
What are the steps to be taken to schedule the report?
What is the dense rank?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain about a time when you discovered a more efficient way to do a work task?
Explain about a task that really tested your analytical abilities?
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 what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
what is the difference b/w the refresh and buffered data?
Differences between business objects and web intelligence reports?
