Need to clear last selected prompt values while refreshing webi report

[Former Member]

While using ALL within cascading prompts its still showing the last prompt values selected in infoview and not while editing and trying to run webi reports.

Is there any way to clear this?

I have implemented following options to resolve but did not work

1) Delete the .lov files of universe.

2) Delete the contents in data folder by going into storage directory

3) Implemented the non_persistent concept in prompts

Code is as follows for the filter with in universe

@Select(Customised LOV\State) = @Prompt('Select State','A','Customised LOV\State',mono,free,Not_Persistent,,)

or

'ALL' = @Prompt('Select State','A','Customised LOV\State',mono,free,Not_Persistent,,)

[Former Member · Accepted solution]

Hi,

In Web Intelligence, the Query Filter Condition consists of 3 parts:

- Object on which condition is applied

- Operator (=,<,>,matches pattern, etc)

- Operands (constant, LIst of Values, etc)

You will find a button with a "?" sign which is also called as Prompt properties. When you click on this button, a new window will open and in this you have an option for "Keep last values selected" which is checked by default.

Uncheck this check box --> Click OK. Run the report and save --> Relaunch InfoView to avoid any caching problems.

Hope this works for you

Sheeba

[kalyanswarna · Accepted solution]

Hi,

Before Saving your report, PURGE all the Data Providers and Prompt Values.

in 3.0 Purging prompts is not available. in 3.1 its vailable.

Thanks,

Kalyan