Where clause when using Nested Prompt

[bo5i]

Hi,

I have a nested prompt , say Year==>Quarter. I pick up Year=2004 and being nested my Quarter shows values pertaining to that year. This prompt is optional. Since I want all the Quarter values belonging to Year=2004 i don't select any at this level. The SQL generated doesn't contain any where clause(as no value was selected for quarter) and I know that the where clause gets applied on the lowest level in a nested prompt. But is there a way where we can get the highest level in the where clause of the SQL when using nested prompt.

Thanks

 

[entaroadun]

I think you need to request this as an enhancement. Unfortunately, to get the results you need, you have to select all of the quarters in 2004. For time, where the dimension doesn't really change, that's OK. But it's a problem for dimensions that do change, i.e. a dimension with major category and minor category, where you want all minor categories in major category 'A', even if the minor categories change in the DW load process.