making a prompt with static choices mandatory

[udaychow99]

Hi Gurus!

I am not able to crack a scenario which is mentioned below.I am just presenting it in a simpler way(as simpler as I can  :))

The scenario is, We have prompt 'A' which is having 3 static choices and also multi value select enabled.
We are filtering (not cascading) another prompt 'B' query based on the values selected in the above said prompt.
I defined the filter condition like [].[].[queryitem] in ?promptAparamter? and made optional.
So even if by making the prompt 'A' as required, It is not acting as a mandatory prompt.
So I think by using java script only we can make the prompt A mandatory. If you have any ideas, Please share with me.

Thanks in Advance.

[MDXpressor]

Is prompt 'A' on Autosubmit?

So as to say: are you reloading the page such that it has set the filter for query B? 

And, if you are trying to do this in a prompt page you will have some trouble.  Autosubmit on a prompt page uses a next command, not a reprompt.  Next will look for any other prompt page then attempt to load the report page.  Leaving your sad and lonely prompt B filtered, but with no selection made.

So, after I said are you autosubmitting?  And told you it's the solution, I'm right unless it's on a prompt page.  If it's on a prompt page, don't autosubmit.  Use a prompt button, and set it to 'reprompt'.  I can't remember for sure, but you may need to add a hidden list container with some data to force the Prompt Page to stay available, but only do that if you have trouble keeping your prompt page loaded after reprompting.