Using a stored procedure in universe

[SergeS]

Hi all,

I've defined a stored procedure in my database (Sybase Adaptive Server 12). Now, in my universe I want to use that stored procedure. Can someone explain the syntax to me?

I am trying: procedurename(argument1, argument2) but I am getting the error that procedurename is not a built-in function.

Thanks,

Serge

 

[blom0344]

Hello Serge,

Don't know if it is possible to have a stored procedure IN a universe. How would you create relationship with the rest of the universe structure. You can use a defined stored prodecure as a dataprovider in itself when you choose "Access data in a new way" when adding a new dataprovider. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[skrandel]

You can't use a stored PROCEDURE in a universe. You can, however, use a stored function.

The real question: Can you use the thing you wrote in a simple SELECT statement outside of BO. If so, then you can use it in BO.