Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Custom Prompt In Query

This is the 3rd time I'm writing this because every time I try to paste a line of text to avoid having to write it by hand this box stops responding. Very inconvenient. So this attempt will not be as detailed as originally. Instead, I will just ask:

how do I add a prompt to the custom query script of a Webi query? I've tried starting the WHERE line with @prompt, etc. with the correct parameters but when I try to validate the script it tells me I have an invalid prompt defintion. Wouldn't there have to be 'something =' before the @prompt?

replied

Hi Jeff,

You're on track, just select the Table from which you get the Fiscal Period data (may be Fact or Lookup table). Also, name that object as Enter Fiscal Year Period Prompt.

Let us know.

Thanks,
Mahboob Mohammed

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question