STORE PROEDURES

[NEAR]

Object to import existing stored procedures into Cognos Framework Manager

>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
After running the Metadata Import Wizard and selecting the data source I expanded Procedures. A this point none of the existing procedures were available (or visible).

Any help would be greatly appreciated!!!

Thanks

 

[blom0344]

What RDBMS are you working with? Is it possible the stored procedure is created under a different schema? Does the Cognos account you are using have enough rights?

Ties Blom

 

[NEAR]

Thanks for your reply! I'm using Sybase and asa it turns out my admin logon didn't have execute rights and therefore Cognos would not import the procedures. Once the rights were granted to my ID the procedured imported as expected.

Thsnks for your help.

Issue resolved!


Tom