We have a stored procedure that is working fine with Static values.
when i change the Values from Static to #Prompt('P_FY')#
and validate, i am getting the following error
RQP-DEF-0354 The query contains one or more unresolved prompts.
QE-DEF-0144 Prompt 'P_FY' has no substitution values.
Please see the attachment for Error.
Right now we are using 10.2.1 FP6.
can any one help with this ?
Quote from: vamsivanka on 13 Jul 2015 10:25:56 AM
We have a stored procedure that is working fine with Static values.
when i change the Values from Static to #Prompt('P_FY')#
and validate, i am getting the following error
RQP-DEF-0354 The query contains one or more unresolved prompts.
QE-DEF-0144 Prompt 'P_FY' has no substitution values.
Please see the attachment for Error.
Right now we are using 10.2.1 FP6.
can any one help with this ?
Hi,
You simply need to provide a default value for the parameter to allow FM to validate the query subject. You could either do this in the syntax of the prompt macro #prompt('P_FY','token','2014')#, or alternatively edit the definition of the query subject, go to the Test tab, use the Options link in the bottom right corner and then press the Prompts button and enter your default there.
Cheers!
MF.