Implementation of @ prompt syntax in free hand SQL at the BI launch pad

[siva_ram20]

Hi Team

We are using BI 4.1 SP 7. We have a requirement to implement @Prompt function in Freehand SQL. We are using date objects for this. But unfortunately, we are getting the error like Invalid Prompt definition.

We are using the correct syntax for @Prompt function.

custom sql query starting "

with dateref as ( select @ prompt ...............................

Need quick help in this regard.

siva

[sevans]

the @prompt syntax consists of the following parts separated by comas,

prompt within single brackets (message to the user)

data type (A (alpha), N (numeric), or D (date))

Mono or Multi (equivalent to saying whether the comparison is based on equals (=) or in a list (in))

Free or Constrained (free allows the user to type free-hand or pick from a list, constrained makes the user pick from a list only)

User:0 (or User:1, etc, sort order if there is more that one prompt)

example:

@prompt('Enter Date:','D',mono,Free,,User:0)

[ayman_salem]

Read this KBA, it will help

2782399 - How to pass prompts in a custom query script in webi

https://launchpad.support.sap.com/#/notes/2782399