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
- 4371 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
Explain the data types present in bo and what happens if we implement view in the designer and report?
What is the difference between condition & filter?
is it possible to export the webi reports to crystal reports?with out using businessview?
Did you face any problems while creating reports? Name? Solutions?
What is package in BO
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
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?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
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...
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
what are the tables used in health care domain project and columns used in report?
