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
in sap bi we have wad, then why we go for sap bo
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What Is The Difference Between Oltp And Olap?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is thumbnail?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What is the difference between absolute and relative div positioning?
How can you first report in Business Objects by using broadcast agent?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain what is the difference between slice and dice and cross tab report?
Can Bo generates the Report from the cubical data Explain?
What would you consider as your biggest achievement and why?
How to execute the plsql procedure from the report by clicking with mouse?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S