Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Data Module using Stored Procedure

    Posted 06/17/20 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 07/07/20 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
    ------------------------------



  • 3.  RE: Data Module using Stored Procedure

    Posted 07/08/20 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
    ------------------------------



  • 4.  RE: Data Module using Stored Procedure

    Posted 07/08/20 11:53 AM
    Data modules do not support importing stored procedures as you can with Framework Manager

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



Related Content