All choices for Edit box control in OBIEE Dashboard prompt

26 Apr

I have seen so many questions regarding Edit box control in Dashboard prompt for getting ‘All Choices’ like drop down list control when you have a presentation variable to carry the prompt value to a report.

To achieve this we have had enough techniques from our vast OTN and BI blogs.

As usual apart from that I want to contribute my 2 cents worth solution to our BI world.

When you set the edit box prompt value to a presentation variable in dashboard prompts you don’t have any option to set to “All choices” by default, So at this stage as we don’t have any value for prompt our report will return No results message until and unless if you have set to any default value.

So in this scenarios if we want to show the report for all values just put % symbol in Default to ->Specific value box.

Examples for Dashboard prompt:

Here % means “All values” for Edit box in OBIEE language 🙂

For eg: I have an answers Report with Year and Revenue columns and having a filter on Year column with Presentation variable var_year.

Now I placed these prompt and report in a dashboard page. By default my report is showing full data without filtering i.e. our prompt is giving all values to report.

That’s it by default our prompt is sending all values to filter.

Hope it helps you..


Posted by on April 26, 2010 in OBI EE


5 responses to “All choices for Edit box control in OBIEE Dashboard prompt

  1. ronnit

    June 27, 2010 at 11:30 am

    Hi can yo please let me know how to create a alias table in OBIEE i am new to this

  2. VKrishna

    January 26, 2011 at 7:58 pm

    Thanks man. Great Post

  3. VKrishna

    February 11, 2011 at 4:55 pm

    Nice Post. My requirement is to provide a measure X >= edit box and X <= Edit Box with no default values. Can we do it? With defaults, am able do it but I was not able to do it with out having any defaults. Edit box doesn't allow us to use greater than or equal to and assign it to a presentation variable. do u knw any work around or solution for this??

  4. Chandra K

    December 6, 2011 at 10:38 pm

    Hi, This doesn’t seem to work properly when I try to filter a different Presentation Column/Logical Column in the report when compared the one used in the Prompt. For example, if I have “Year1” and “Year2” presentation columns. If I use Year1 column in the Prompt and set the presentation variable “var_year” and use this variable in the report report for “Year2” Presentation variable. Then we set the default to “All Choices” for this filter in the prompt. The physical query that fires has the w_time_d.year = ” resulting in No Results. Any idea how to resolved this?

  5. my review here

    August 10, 2012 at 4:23 am

    It is not my first time to visit this web site,
    i am visiting this site dailly and take nice facts from here every day.


Leave a Reply

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

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

%d bloggers like this: