Analytics Software

Hi All

I need to create a dummy dashboard prompt that has displays two values 'Y' and 'N' (Yes and No). If 'Y' is selected, I want the report to 'Filter based on the results of another request'. If 'N', then the report takes the usual filters (not taking the 'Filter through another request' filter).
I have achieved this in the report filter by using an 'OR' clause (The Project Number is in Project Number Report OR 'N' = 'N' (presentation variable from the prompt) ). So if 'N' is selected the OR clause is satisfied and the results from the report are not taken in. If 'Y', the results from the report are taken in. This part is fine.

The problem is, on the dashboard prompt, there are a few constrained prompts. When these are selected, WHERE clause is attached 'N'='N' (the clause above). So when 'Y' is selected in the prompt, the condition fails and the constrained prompts do not show any results.

So, basically the idea is: How do I make my report run against 'Filter based on results of another request' when 'Y' is selected and bypass this (i.e. take the other filters) when 'N' is selected (Keeping in mind the constrained prompts).

Thanks
Ananth