Selecting a single value and showing a Range.

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.

Step1: Set a presentation variable with the dashboard prompt.

Step2: Open the Year column in Answers and create the report in this format by giving the SQL Expression and calling the Presentation Variable.

Now the filter Looks like this.

Now click the edit filter and enable the Protect Filter.

Step3: Dont be panic if we click on Display Results then we will get a error its because we are not passing value to the Presentation Variable.

This can be resolved by placing both the prompt and report in the Dashboard.

Step4: Save the report and place the report and prompt in the Dashboard.

Advertisements
By bidevatapraveenkumar Posted in OBIEE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s