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 this god v do tht
Who is Participating?
welchb123Connect With a Mentor Commented:
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.

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.

All Courses

From novice to tech pro — start learning today.