What is the stored procedure ? What is the need of stored
procedure ? How to create a stored procedure Universe?
- 1 Answers
- 5092 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / sivakumar
Store procedure is used to excutea set of sql queries ,
Its used in the scenario where the query is used in
mulitple times.
there is a option in the designer to retrive the structure
of the universe through store procedure.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you please send me the migration related issues .
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain what are the steps to be taken to schedule the report?
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
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain what is the difference between business requirement document and use case document.
What are the steps to do to use alerts in bo?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
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 sort of existing documents should business analysts refer to when starting on a new project?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
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
Difference between b.o 5.1 and 6.1b?
Explain is data mart?
