C O G N O i S e - the COGNOS community ...brought to you by BrightStar Partners, Inc.
The largest independent IBM Cognos support community!
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email
?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
February 7th, 2011
- COGNOiSe.com now has integrated chat rooms!
Home
Help
Search
Calendar
Login
Register
C O G N O i S e - the COGNOS community ...brought to you by BrightStar Partners, Inc.
»
IBM Cognos 8 Platform
»
COGNOS 8
»
Framework Manager
»
DB function as metadata?
« previous
next »
Print
Pages: [
1
]
Author
Topic: DB function as metadata? (Read 370 times)
James111
Full Member
Posts: 10
Forum Citizenship: +0/-0
DB function as metadata?
«
on:
02 Sep 2010 06:39:45 pm »
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!
Logged
peritas-chris
Full Member
Posts: 45
Forum Citizenship: +3/-0
Re: DB function as metadata?
«
Reply #1 on:
04 Sep 2010 11:28:43 pm »
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
Logged
Chris F
Peritas
Print
Pages: [
1
]
« previous
next »
C O G N O i S e - the COGNOS community ...brought to you by BrightStar Partners, Inc.
»
IBM Cognos 8 Platform
»
COGNOS 8
»
Framework Manager
»
DB function as metadata?