How to stop auto refresh of LOV in mandatory prompts in webi

[Former Member]

Hi All,

How to stop auto refresh of LOV ? I want to enter manually and sometimes based on LOV's displayed.

I want the LOV in mandatory prompts to refresh only when I click on refresh button

Regrads,

Blessina

[Vidhya]

Hi Paul,

Please go with Raj's reply. What you expecting was explained clearly.

For your referrence, Please find the below screen shot and make sure with Prompts Variables from BW or Webi.

\

Regards,

Vidhya.C

[Former Member]

Hi Paul,

The below article explains all the scenarios regarding LOV refresh:

http://scn.sap.com/docs/DOC-63871

Regards,

Adil Raj

[former_member451616]

Hi Paul,

1748343 - BI4.x WebIntelligence: changes to List of Values

(LOV) behaviour for Mandatory and Optional prompts when

refreshing reports

1728482 BI4.0 WebIntelligence: Mandatory prompt value list is not automatically populated

What version of BO you using and what is the data source type ?

There is a change in the LOV refresh behavior within 4.X. Refer the notes for more details.

Anyway the fix to avoid automatic refresh is you can set a default value to the prompt OR select the "Keep Last values selected" option and save the report again.

Thanks,

Viswa.

[former_member198519]

Go to prompt property and un select the option for "Prompt with List of Values"

[amitrathi239]

in the universe designer->object->properties->check the checkbox "delegate search".

[Former Member]

We are using IDT .Is there any option there ?

[amitrathi239]

Then you need change your mandatory prompt to optional.With optional you will not get LOV's automatically.