Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Explain when we use aggregate awareness function in designer?

992


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...

2120


What is the profile and package?

2265


in sap bi we have wad, then why we go for sap bo

3344


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

944


Explain what are the measure objects?

958


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10809


Explain what is the difference between slice and dice and cross tab report?

1038


What is package in BO

3167


what is xcelsius architecture?

4541


How to schedule the report in b.o?

974


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2067


Is there any other repository domains rather than universe, security, document?

1015


Explain when to use local filter and when to use global filter?

1316


What are the join problems comes appart from loop,chasm & fan Traps

2095