Cognos Analytics

 View Only

  • 1.  Adding SP in framework manager with int type argument

    Posted Thu May 16, 2019 02:50 PM

    I have a SP that has a parameter as INT.  I,e,@PlanId 

     

    #prompt('@PlanId','integer')#

    When I tried to add above prompt in framework manager, it failed in validation.  I have tried different way but none works. Can you please provide a quick guide?

     

    Below is the doc that I refer to. We have no issues when adding varchar parameters.

     

    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_fm.10.1.0.doc/ug_fm_id5101stored_procedure_query_subjects.html

     



    ------------------------------
    ella ye
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Adding SP in framework manager with int type argument

    Posted Thu May 16, 2019 03:53 PM
    Hi Ella,
    What is the error message that you're getting?
    Can you give a screenshot of the FM definition of the stored procedure as well as the first couple of lines of the stored proc itself, just to check that the arguments are imported correctly.
    Also, which version and mode of Cognos are you using?
    //Henk

    ------------------------------
    HENK CAZEMIER
    ------------------------------

    Original Message


  • 3.  RE: Adding SP in framework manager with int type argument

    Posted Thu May 16, 2019 05:07 PM
      |   view attached
    hi HENK,

    Thanks for help.
    I use IBM Cognos Analytics 11.0.7.
    Attached the error screenshot.

    Code:

    CREATE PROCEDURE [dbo].[SP_TEST_1]
    @PlanId INT , @Soe VARCHAR(10)   
    AS
    BEGIN

    ------------------------------
    ella ye
    ------------------------------

    Original Message


  • 4.  RE: Adding SP in framework manager with int type argument

    Posted Thu May 16, 2019 11:32 PM
    Hi Ella,
    It looks like the input value is incorrect. It is a zero followed by a number of newline characters.
    When the FM prompt dialog comes up, have you tried re-entering the value?
    If that fails:
    Have you tried clearing the prompts in FM ?  (select a query Subject, select test, select options..., select prompts..., clear all)
    Restarting FM might be quicker.
    After that run the test again and see if you get the same/similar error.
    If neither of those approaches work, we can do a webex at your convenience and see if I can spot what's going wrong.
    //Henk

    ------------------------------
    HENK CAZEMIER
    ------------------------------

    Original Message


  • 5.  RE: Adding SP in framework manager with int type argument

    Posted Thu May 16, 2019 11:51 PM
    Hi henk,

    In fact there was no prompt pop up asking for value.

    Once I clicked ‘validate’ I got that error message and I didn’t even have chance to input a test value.


    Ella

    发自我的 iPhone


    Original Message