Skip to Content

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 13, 2016 at 08:04 PM

    Hi Jeff,

    I'm assuming that the prompt definition I asked you to try earlier (in other post) didn't work. Try the below definition in Where clause and also, add the Date Dim Table as Reference table for this filter object, as shown below.

    Null = @prompt('Enter Fiscal Year Period (e.g. 1 for July):','N',{'1','2','3','4','5','6','7','8','9','10','11','12'},Mono, Free, Persistent,,User:0)

    Snap 01.PNG

    I tried it, worked like a charm for me.

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded