If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

DB function as metadata?

Started by James111, 02 Sep 2010 07:39:45 AM

Previous topic - Next topic

James111

Hi there,
I have a stored function in my DB which returns a ref cursor.
I want to use the result as my metadata in my Framework Manager model.

How can I do that?

Thanks!

peritas-chris

You should be able to use it, just call it via SQL in your select statement.

For example:

Select *, dbo.YourFunction(parameter) as FunctionResults
from TableA