on 01-05-2018 5:18 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pan,
What version of the product are you using?
Have you tried removing the saved value from the prompt?
Now try the same report in the schedule?
Jason
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.