Cognos Analytics

 View Only

  • 1.  Data Module using Stored Procedure

    Posted Wed June 17, 2020 11:28 AM

    Hi, Does anyone know if it is possible to create a Data Module that uses a SQL Stored Procedure as the Data Query? I have not been able to find anything on this yet.

    Thanks for any information!

     

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    Heather Wilson

    Sinclair Broadcast Group, Inc.

     


    #CognosAnalyticswithWatson


  • 2.  RE: Data Module using Stored Procedure

    Posted Tue July 07, 2020 11:40 AM
    Hi Heather - did you get anywhere with this? I'm trying to do the same thing. I've used stored procedures in the past in Framework Manager, but I'm trying to step away from that.

    ------------------------------
    Chris Turner
    ------------------------------

    Original Message


  • 3.  RE: Data Module using Stored Procedure

    Posted Wed July 08, 2020 05:16 AM
    Hi, 

    I have attended the Ask Me Anything webinar yesterday and someone asked this question. IBM said you cannot use a stored procedure to create a table in a data module (at least in the current version). They suggested creating a view using the stored procedure in the database and import that view in the data module. 

    Regards

    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------

    Original Message


  • 4.  RE: Data Module using Stored Procedure

    Posted Wed July 08, 2020 11:53 AM
    Data modules do not support importing stored procedures as you can with Framework Manager

    ------------------------------
    NIGEL CAMPBELL
    ------------------------------

    Original Message