OBIEE Reverse the filter

Or how to define a between filter based on ONE presentation variable.

Let’s get our prompt and presentation variable:

variable is pVarYear

Let’s get a simple report:

Giving us:

Let’s add the between, first add your variable to a dummy column:

Add a filter to that column and set it on between:

Add two sql expression with your year column and add the diferences:

Remove your dummy column and check the results:

 

Or simple convert a filter to sql an directly edit it:

Till Next Time