Skip to Content
avatar image
Former Member

Creation of stored procedure

We are using SAP Bo Enterprise XI 4.0, whether it is possible to create stored procedure through Information Design Tool or Universe Design Tool. We don't have access rights of creation or execution of stored procedure. Or is there any other techniques for stored procedure, which will act like stored procedure.

Thanks in Advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 04, 2017 at 12:29 PM

    You are asking if you can use IDT or UDT to create a stored procedure? No, the tools only allow you to create a universe that uses an SP as its source.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 04, 2017 at 11:11 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank You Amit,

      But my question is; may I create a store procedure in Universe level, Because I don't have access right to execute stored procedure on database( Sql Server) which SP are created by database users.

  • Dec 04, 2017 at 11:14 AM

    Better try to avoid this, because of dozens of limitations that procedure sets on reporting.

    Add comment
    10|10000 characters needed characters exceeded