Skip to Content
0

How to get dynamically changing prompts in Webi Publications?

Jan 05 at 05:18 AM

88

avatar image

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??

Thanks.

prompt-screen.jpg (25.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jason Everly
Jan 05 at 08:24 PM
0

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?

Jason

Show 2 Share
10 |10000 characters needed characters left characters exceeded

HI Jason,

BO version is 4.1 SP 5 and BW version is 7.4

0

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.

0
Erdem Pekcan Jan 08 at 11:39 AM
0

Hi,

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.

Regards,
Erdem

Share
10 |10000 characters needed characters left characters exceeded