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

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,


what is local filter

2 Answers   Cap Gemini,


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

1 Answers  


how do u implement dense rank in bo reports?

2 Answers   CTS,


Can we link the oracle and excel universess?

1 Answers  






Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

1 Answers  


can anybody explain me in detail about software development life cycle of business objects in detail?

1 Answers  


How to execute the MACRO through Infoview?

1 Answers  


Can more than 1 metric be applied on an analytic in business objects?

0 Answers  


what are slowly changing dimensions, confirm dimensions?

1 Answers   Wipro,


how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?

2 Answers   TCS,


generally how do we get information for creating universes and reports

1 Answers   Satyam,


Categories