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

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
------------------------------

Original Message:
Sent: Tue June 16, 2020 03:30 PM
From: Richard Mabjish
Subject: Making a Stored Procedure parameter truly optional

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

Already had tired different ways to pass NULL, it does not work.
Original Message:
Sent: Wed June 17, 2020 09:12 AM
From: brenda grossnickle
Subject: Making a Stored Procedure parameter truly optional

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

Original Message:
Sent: Tue June 16, 2020 03:30 PM
From: Richard Mabjish
Subject: Making a Stored Procedure parameter truly optional

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

What type of value is the prompt (text,number,date, etc)?

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

Original Message:
Sent: Tue June 16, 2020 03:30 PM
From: Richard Mabjish
Subject: Making a Stored Procedure parameter truly optional

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