Skip to Content

How to get dynamically changing prompts in Webi Publications?

Hi Experts,

We have developed the Webi reports based on Bex Queries.

Bex query have two variables with Default value (Current fiscal month and Current Fiscal year)

When I run the webi reports it shows me prompt screen as below,

when I refresh values for fiscal year prompt, it shows me only current fiscal period as we set in Bex (Default value for variable).

When I created the Publication for this report in last month, It showed me default value for a period which is DEC 2017 which is correct. so we set this value to prompt.

But when JAN 2018 arrived, reports are still running for DEC 2017. Whereas it should run for JAN 2018. This prompt value in publications is not changing dynamically. But in BW side its showing defalut value as JAN 2018, also when we refresh webi report its showing default value as JAN 2018 but In Publication, it's not changing to JAN 2018. Do I have to mannualy change this prompt value in Publication in the end of every month?

How to automate this??


prompt-screen.jpg (25.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 05, 2018 at 08:24 PM

    Hi Pan,

    What version of the product are you using?

    Have you tried removing the saved value from the prompt?

    1. Go to Web Intelligence Launchpad preferences and set Modify mode to APPLET
    2. Open the report in Modify/APPLET mode(Right click-Modify)
    3. Under Document Properties
    4. Under [Data Access] tab click on [Purge]
    5. Check the Purge last selected prompt values
    6. Choose [Yes]
    7. Save the report
    8. Open the report, refresh and dynamic prompts are coming properly

    Now try the same report in the schedule?


    Add comment
    10|10000 characters needed characters exceeded

    • Hi Jason,

      As per your reply, after refreshing the report, dynamic prompts coming properly.

      but my concern is, they are not changing in publication as per the period. When month change, it still shows data for the month that we set in prompts in publications.

  • Jan 08, 2018 at 11:39 AM


    Prompts in publications do not change dynamically based on the default values.

    For this purpose, create a customer exit variable which converts a period like 12.1999 to current period.
    Then schedule your publication with 12.1999 selected.


    Add comment
    10|10000 characters needed characters exceeded