importing function from oracle into FM

i made one function in oracle ..i want to import tht in my model...tht function takes in 3 parameter and return one string......is this god approch...how v do tht
muhammadaqeelAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

welchb123Commented:
To import your new function into your model you can use the the Metadata wizard.
1) In Framework manager right click on the namespace and select "Run Metadata Wizzard"
2) Select your data source
3) On the Metadata Wizard - Select Objects screen
4) click the check box next to "Show System Objects"
You should now see additional folders at the bottom of the screen.  Open the SYS folder and then Open the functions folder.  You should see your function there and should now be able to select it for improt into the model.
Make sure that security allows the login you are using in Cognos to see the function you created in Oracle.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.