What is the stored procedure ? What is the need of stored
procedure ? How to create a stored procedure Universe?



What is the stored procedure ? What is the need of stored procedure ? How to create a stored proce..

Answer / 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

More Business Objects Interview Questions

How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible

2 Answers  


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

0 Answers  


I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )

6 Answers   Exilant, Siebel,


How many universes can be created in a project?

0 Answers  


CAN A REPOSITORY CONTAINS REPORTS?

7 Answers   AG Technologies,


'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.

1 Answers  


Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that

3 Answers   BirlaSoft,


how can we build one report from two data bases

4 Answers   IBM,


What is a category?

3 Answers  


What is object stores?

0 Answers  


explain in detail about type 3?

0 Answers  


How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".

3 Answers  


Categories