1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

Question Posted / raj


how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statemen..

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

Post New Answer

More Business Objects Interview Questions

every reports have docid,when i export a report docid will change or not?

4 Answers   Zensar,

Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.

1 Answers  

What is the difference between business requirement document and use case document.

0 Answers  

why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.

7 Answers   Satyam,

What are the differences between webi and deski of XI R2 not the earlier versions

1 Answers  




Explain what three things do you consider to be the most important factors for a manager?

0 Answers  

in universe perameter u dont give the option multiple contexts ,what is the impact in report level

2 Answers   Accenture,

There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?

2 Answers  

What are the major problems will occur while migrating to the one version to another version?

2 Answers   CTS,

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2 Answers   iFlex,

how to make a report avilable to other users?

2 Answers  

Approximatly how many enduser can use the each bo project?

4 Answers   HCL,

For more Business Objects Interview Questions Click Here
Categories