cancel
Showing results for 
Search instead for 
Did you mean: 

How to create stored procedure universe

Former Member
0 Kudos

I want to create a Universe based on a SQL Server stored procedure.

When creating a new Universe, I selected the check box Click here to choose stored procedure universe. In the next step, I select insert > Stored Procedures. The Stored Procedure Browser only lists stored procedures under sys schema, but not user defined stored procedures under dbo schema.

Would you please help me on how to create a stored procedure universe?

Thank you!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I have figured it out. I just need to create normal SQL stored procedure and no cursor is required. Some post says cursor is required for Oracle procedure.

Some tips:

1. User should have execute permission to run the stored procedure.

2. I used SQL profiler to monitor the SQL command sent from BOE to SQL. The order of parameters should match the stored procedure definition.

Former Member
0 Kudos

I realized that the user used in the connection does not have the permission to execute the stored procedure. So I assigned the permission to the user, then I can see the stored procedure and created the stored procedure Universe.

However, when I create a webi report based on the unverse and run the report, it retrieves no data. The stored procedure does return some data when running in Management Studio.

Any suggestion? Please help!