Passing All Choices in Presentation Variables

Hi All,

I was working on this report and had faced this issue and took some time to work around it so thought would be helpful to post it.

Scenario-

I have a dashboard which has reports from different Subject Areas and I’m using a Presentation Variable in the Prompts to filter out the report data. This is quite simple and can be done easily but when choosing ‘All Choices’ option I’m getting an error

 

 

 

Solution

Here I have a Quarter column and the users want to choose All choices to get YTD.
The first thing we have to understand is when All choices are chosen then the OBIEE is actually passing a  NULL value. This is dynamiclly taken when its prompted. When passed through a presentation variable then we have to add this filter condition.

>  In the report click on the column filter condition and Advances SQL Result. In my case it is for the Quarter column. I used this condition

Time.”Calendar Quarter” = case when ‘@{QUARTER}’  IS NULL THEN CAST(Time.”Calendar Quarter” AS CHAR) ELSE ‘@{QUARTER}’ END

 

 





Save the report and is sure to work.

Till next time 🙂

 

Advertisements

4 thoughts on “Passing All Choices in Presentation Variables

  1. I found something very helpful (at least for me) on this topic. When you filter on a presentation variable if you put a wildcard in the (default) value it will simulate “All Choices”. OBIEE's wildcard is %.

    So, if you want to see All Choices, just set the prompt option to blank 🙂

    Like

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s