OBIEE 11g: Customizing Prompt ‘All Column Values’ to Custom Value

The requirement is to have a custom prompt value which will in turn hold all the prompt values. We mean to say All Column Values with new name. This looks simple but practically this is impossible to do. We have identified a way to achieve this in some scenarios i will explain one here.

We have a Prompt which holds the values of States in USA , now when we want to show all the values of USA (All States) we may have to select All Column Values or individually select all the values. Second is pretty bad idea as it makes no sense to select hundreds of column values. The first one is the apt but the client is looking for something different.

We need to show National instead of All Column Values as shown below.


Now lets see how this can be done.We have to build a new group as per our requirement as shown below. For this create a report which contains column that you are going to prompt and create group here with the name you need.





Provide the label as required , my case National and copy all the elements under it as shown below..



Now save the selection steps as shown below in some folder as this is where you will be finding it for use. Also select if it is going to be saved statically or dynamically, just in case if any future elements are added.



Now go to edit the prompt and include the group as shown below.



Click the Green Plus symbol to add the desired group from the saved location.



Now you can go ahead and use it as if it is a general column value.