Planning Analytics

 View Only

  • 1.  Help with stored procedure

    Posted Wed August 04, 2021 06:49 AM
    Hey
    I am trying to pull data from MS SQL table where there is security on 1 column. I have a stored procedure witch make med able to see the data in that column. 

    I have seached for help, but cant seem to fin good guides for creating a TI proces that uses a stored procedure. 

    I have tryed this guide IBM Cognos TM1 and Stored Procedures. But i keep geeting below error:

    "01000[Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor."


    Does anyone have any exampels on using stored procedures or can try and tell me how to?

    ------------------------------
    Morten Frandsen
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Help with stored procedure

    Posted Thu August 05, 2021 04:43 AM

    Hi Morten

     

    It sounds like you are trying to EXEC the stored procedure. You cannot do that if you want to retrieve data from it. The stored procedure needs to end with a SELECT that returns data, and you need to SELECT * FROM the stored procedure on the Data Source Tab.

     

    Regards

     

    Paul Simon




    Original Message


  • 3.  RE: Help with stored procedure

    Posted Sat August 07, 2021 03:29 AM
    Hi, 

    you need to make sure that you access a "table". Either original table or the result of store procedure or view, etc. But the format should be table where you can read the data directly. 

    Then connect TM1 to the data source using ODBC connection and retrieve data using sql command: "select"
    Select * from [table name] where [condition1] and [condition2]

    Regards,
    Veronika

    ------------------------------
    Veronika Gultom
    ------------------------------

    Original Message