Stored Procedures not displaying

[pyovich]

Hello Gurus-

I am attempting to add a Sql Server stored procedure to Framework Via Create | Query Subject | Stored Procedure but when I select the appropriate DataSource, Database, and schema nothing is displayed despite the Stored Procedure being in the database.  Can anyone provide assistance to let me know what I am doing wrong?   Is there a security setting?  Something that I am missing?

Much obliged.
-Peter Yovich

[MFGF]

Hi,

Is it a user-defined Stored Procedure? System Stored Procedures are not supported...

If that's not the issue, does the user your are connecting to your database as have privileges to see the SP?

Cheers!

MF.

[pyovich]

Yes.  This is a stored procedure that I authored. 

How can I confirm the user that is being used to connect to the database?  I am not seeing any sort of that information.

Thanks.

[MFGF]

You need to check the signon used in the data source connection defined on the Cognos server. Go to IBM Cognos Administration, onto the Configuration tab, make sure Data Source Connections is selected on the left, click on the name of your data source to see the connection, then click on the connection to see the signon. Use the "Set properties" button for the signon, and go to the signon tab. Click "Edit the signon" and you will see the user name you are using to connect to your database.

Once you have the user name you can check in your database what privileges the user has.

Cheers!

MF.

[pyovich]

Yes.  Security on the object was the issue.  I could have *SWORN* i double checked that but apparently I was mistaken.

Now I am having the issue where the prompt for the stored proc parameters is showing up before my Prompt Page.  How can I bypass the proc calling for the parameter when I have the parameter being set on the Prompt Page.

Thanks for the assist.  Is there a _good_ book that I can get which will show these types of rudimentary problems and solutions?

-Peter

[MFGF]

Yes.  Security on the object was the issue.  I could have *SWORN* i double checked that but apparently I was mistaken.

Now I am having the issue where the prompt for the stored proc parameters is showing up before my Prompt Page.  How can I bypass the proc calling for the parameter when I have the parameter being set on the Prompt Page.

Thanks for the assist.  Is there a _good_ book that I can get which will show these types of rudimentary problems and solutions?

-Peter

Hi,

That indicates to me that perhaps the parameter name the SP is utilising is not one of the parameters your prompt page is fulfilling. Could this be the case?

I don't have a good book to recommend, sorry. Just a handy Cognos forum where you can ask questions people might know the ansers to. Oh... wait... you already found that one :)

MF.

[pyovich]

Thanks Beaker...er..MFGF

I checked that and the names are the same...hmm...sometimes I have the suspicion that the names are just 'pointers' to objects in the background so if two distinct things have the same name, they will actually be pointing to different objects.  I wonder if I am running into that here.

[pyovich]

Moved to Reports Section as it makes more sense for it to be over there now,