cancel
Showing results for 
Search instead for 
Did you mean: 

Creation of stored procedure

Former Member
0 Kudos

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.

amitrathi239
Active Contributor
0 Kudos

corrected the tag.

Accepted Solutions (1)

Accepted Solutions (1)

Joe_Peters
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Thank You Joe..

Former Member
0 Kudos

Thank You Joe,

Is there any other techniques other than Stored Procedure which act like Stored Procedure?

Thanks In Advance

Joe_Peters
Active Contributor

A derived table is probably the only solution if creating a procedure is not an option.

Former Member
0 Kudos

Thank You Joe for your responce.

Answers (2)

Answers (2)

former_member199543
Contributor
0 Kudos

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

amitrathi239
Active Contributor
0 Kudos
Former Member
0 Kudos

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.