cancel
Showing results for 
Search instead for 
Did you mean: 

stored procedure universe

Former Member
0 Kudos

Hello,

I've read Chapter 7 - "Creating stored procedure universes" from the XI 3.1 Universe Designer Guide.

However, I haven't found what I was looking for, namely how does it actually work.

Also, it is not entirely clear for me what kind of parameters can be sent by BO and how to do this.

Can someone explain it to me, please.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

The manual is actually pretty good in this area ...

Anyway - The stored procedures universe can only be used to call stored procedures - so It is an additional universe to your existing ones you have. The parameters the manual is talking about is the input/ouput parameters of the STORED PROCEDURE !!!! not the universe query.

Hope it helps....

Eran.

Answers (2)

Answers (2)

Former Member
0 Kudos

Sands, Eran

thank you for your answers

Regards,

Cate

Former Member
0 Kudos

Hi cate,

We can only select the input parameter for the stored procedure, this parameter is created in the stored procedure itself, we just select the values for it.

The Stored procedure universe can have multiple input parameters.

The value which we select for the input parameter is passed to the stored procedure and it retrieves the records/resultset accordingly.

Input parameter is nothing but the prompt created at stored Procedure level.

For eg. "Enter EmpNo"

Hope it helps.

Thanks,

Sands