KPI Partners Blog

Selecting A Single Value in OBIEE and Showing a Range

Posted by KPI Partners News Team on Mon, Aug 01, 2011 @ 09:19 PM

By Kurt Wolff

This post shows how you can use presentation variables to select a single value in a dashboard prompt and produce a result set that includes a range of values. For example, you could select a single year in a prompt and show data for that year and the preceding three years

describe the imagedescribe the image









To make this happen, you first need to set a presentation variable with the dashboard prompt. In this screen shot, the variable's name is "Y".

Range   Picture3



The trickier part is constructing the filter in the query. It is going to constrain the values between two values, i.e. between Y and Y-3. In the filter, this will be between a SQL Expression (using the variable Y) and the variable Y itself. The screen shot shows how this was entered.

Range   Picture4





On the Criteria Tab, this filter will look like this.

Range   Picture5





Just one other thing is required: you have to click Protect Filter or it will be overwritten by the value you enter in the dashboard prompt.

Range   Picture6




Tags: Kurt Wolff, Oracle BI, Blog

Subscribe to the KPI Blog