Skip to Content
author's profile photo Former Member
Former Member

Need to clear last selected prompt values while refreshing webi report

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,,)

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2009 at 11:02 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.