Business Object - Stored procedure

Card Puncher Data Processing

About

A stored procedure is a compiled SQL program, consisting of one or more SQL statements, which resides and runs on the target database.

A stored procedure universe is a special universe that enables SAP BO - Web Intelligence and Crystal Reports users to access stored procedures residing in the database.

In BusinessObjects XI Release 3.0, you can also use stored procedures with Desktop Intelligence

Business Objects supports stored procedures:

  • without parameters
  • with parameters (IN)
  • with multi-result sets
  • with multi-statement (with SQL sentences different from Select)

How to create a universe based on stored procedures

To create the stored procedures with parameters, click on the Quick Design Wizard. More in the designer guide.

Bobj Designer Wizard Stored Procedure

Restrictions

Note the following restrictions apply to stored procedures universes:

  • No joins are permitted between objects in stored procedures universes.
  • Filters cannot be used on the stored procedure universe.
  • You cannot link a stored procedure universe to a standard universe.
  • The Web Intelligence supervisor grants access to the database or account where stored procedures are located.
  • Not all RDBMSs support stored procedures. Consult your database guide to see if yours does.
  • COMPUTE, PRINT, OUTPUT or STATUS statements contained in stored procedures are not executed.





Discover More
Bobj Designer User Interface
Business Object - Universe Designer

Universe Designer provides a connection wizard that allows you to connect to your database middleware. You can create multiple connections with Designer, but only one connection can be defined for each...



Share this page:
Follow us:
Task Runner