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?