Prompt is not restricting.

Question

Hello,

I am using the OBIEE - 11.1.1.7

I have to show the data for the past 2 years and 1 year in the future in the Month-Year Prompt.

I have written query to restricted using the Query in the Prompt. I also have given the All Column Value option in the prompt.

When I am filtering data in the dashboard with the Prompt with the few of the months that time it is working fine but when I am using All Column Value that time it is not restricting as per the Query.

It is showing all the values which are available in the Column.

I have to show only the values for the past 2 years and 1 year in the Future in the All Column Values.

is there any solution for this?

Thanks & Regards,

Mayur

#Mayur · Answer

Thank you Gianni.

Gianni Ceresa · Answer

Hi,

You took "all column values" a bit too literally ...

Look at the query your analysis execute, you will see it doesn't contain a WHERE yourColumn IN ( the list of all the values ).

It doesn't work nor mean that.

You will need a different logical approach for the filter you look for. Add the filter of 2 years in the past and 1 in the future to the analysis, and on top you keep the filter based on the prompt. So your analysis is always filtered over the 2 years back and 1 year future time frame, and in addition to that one you also have the prompt if values have been selected (or the all values will have no impact).