Stored Procedures in Cognos Reporting

[himanshu1012]

We are using COGNOS with SQL Server on Cloud Application.

Framework MANAGER is not there in the application. we do have Report studio, Query studio, Analysis studio, Workspace,event studio , Admin.

I want to import Stored Procedures for Reporting.

Our vendor says u need not require FM for Stored Procedures.

Is there any other way to access user stored Procedures in cognos.

[New_Guy]

Hi,
You have to have FM to import the stored procedure.
Good luck
New guy

[AnalyticsWithJay]

Our vendor says u need not require FM for Stored Procedures.

Is there any other way to access user stored Procedures in cognos.

Yes, by using a SQL Query in Report Studio. Depending on what you're looking to do, you could also call them from Event Studio.

[bdbits]

Of course it should be noted that writing SQL in Report Studio goes against many reasons for using Cognos in the first place. If your vendor actually understands Cognos, they would not want you to do this either.

You should only do it as a last resort, which may be the case here.