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

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


Please Help Members By Posting Answers For Below Questions

Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

629


Explain is there any other repository domains rather than universe, security, document?

583


What is the difference in creating filters in designer and business objects?

586


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

599


What is package in BO

2681






I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

2996


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 ?

5969


how get the grand total in master-detail report?

1814


How to schedule the report in b.o?

562


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

551


is it possible to export the webi reports to crystal reports?with out using businessview?

1817


How to execute the plsql procedure from the report by clicking with mouse?

615


Differences between business objects and web intelligence reports?

651


How to create Index to the table in the universe designer and how it improves the Query performence

2117


Explain in detail about type 1?

650