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.  Making a Stored Procedure parameter truly optional

    Posted 06/16/20 03:30 PM
    I have a stored procedure in FM that is being used in a report. The SP parameters are being passed to the report via prompts. I would like to make one of those prompts optional, however Cognos does not allow me!

    I implemented the steps in this document,  however when I do not provide a value at the prompt, then cognos uses the one in FM manager, so still it is not optional.

    Any ideas or workarounds on how to make a SP parameter truly optional in a Cognos report.

    Thanks!
    #CognosAnalyticswithWatson


  • 2.  RE: Making a Stored Procedure parameter truly optional

    Posted 06/17/20 09:12 AM
    Disclaimer - I have no experience with stored procedures in FM. But that won't stop me for giving my 2 cents :-) . Can you set the "one in FM manager" equal to NULL as the default value?

    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------



  • 3.  RE: Making a Stored Procedure parameter truly optional

    Posted 06/18/20 01:54 PM
    Already had tired different ways to pass NULL, it does not work.
    Original Message


  • 4.  RE: Making a Stored Procedure parameter truly optional

    Posted 06/18/20 03:45 PM
    What type of value is the prompt (text,number,date, etc)?

    ------------------------------
    Mark Allen
    ------------------------------



Related Content