How can we import stored procedures into framework manager in cognos8

Interview Candidate
Sep 27th, 2006
1
6561

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

Arunn

Nov 6th, 2006

Hi,
Try this method
In FM right click on the Namesapace in which you want the stored procedure to be imported...Select Create->QuerySubject....
New Query subject window appears... Select the third option "Stored Procedure" -->Click Ok...
New Querysubject Wizard appears in that...Select the Datasource...-->Next
In the select stored procedure window select the appropriate stored procedure and click "Finish"...
Define the properties for the Procedure.....
That's it and you can view the procedure as a query subject inside your namespace.