Optional prompt on universe level

[former_member419024]

Applied code below in order to have optional prompt, although optional prompt is succeed but after that I get the error which attach below

where

(A.BATCTRCDE='T413' or (A.BATCTRCDE='T405' and E.REPTYPE in (select REPLCODE from CDE_T_T3586)))and A.SACSCODE in ('FG', 'CO')  

and

(

A.BATCACTYR = @Prompt('Enter This Year','N','Year Others':'BATCACTYR',Mono,Constrained,Persistent,,User:-1,Optional)

AND 

(

A.BATCACTYR = year(getdate())

OR 

A.BATCACTYR = @Prompt('Enter This Year','N','Year Others':'BATCACTYR',Mono,Constrained,Persistent,,User:-1,Optional)

))

[Former Member · Accepted solution]

Hello,

try this:

(A.BATCTRCDE='T413' or (A.BATCTRCDE='T405' and E.REPTYPE in (select REPLCODE fromCDE_T_T3586)))and A.SACSCODE in ('FG', 'CO')

and

(

1. A.BATCACTYR = isnull(@Prompt('Enter This Year','N','Year Others':'BATCACTYR',Mono,Constrained,Persistent,,User:-1,Optional), A.BATCACTYR)

AND

(

1. A.BATCACTYR = year(getdate())

OR

1. A.BATCACTYR =isnull( @Prompt('Enter This Year','N','Year Others':'BATCACTYR',Mono,Constrained,Persistent,,User:-1,Optional), A.BATCACTYR)

))

regards

Andreas

[former_member419024 · Accepted solution]

Thank for replied, tried but getting the same error message.

[Former Member · Accepted solution]

which BO Version you ar using?

[former_member419024 · Accepted solution]

Support Pack 7 - 14.0.7.1147

BO4.0

[Former Member · Accepted solution]

Hi,

look at this

Perhaps try first:

A.BATCACTYR =isnull( @Prompt('Enter This Year','N','Year Others\BATCACTYR',Mono,,,,,Optional), A.BATCACTYR)