on 2023 Jan 13 2:17 AM
Hello fellow SAP users,
Someone asked about dynamic input values in a scheduled WEBI report, and someone else replied that it is not possible.
"You cannot currently schedule a report with dynamic values"
https://answers.sap.com/questions/13666964/webi-report-for-dynamic-input-parameter.html
My question is: How about for AO reports?
Is it also correct that we cannot have dynamic input values?
In our case, we have a month and year field.
If possible, we would like to have it set automatically every month based on the calendar or based on some special rules.
Thank you
Quin
Hi Quin
Dont trust all you read on the internet 😉
It is possible to schedule in Webi and AFO using dynamic values if you can control the dynamics in the underlying BW query. The trick is to make prompts in your BW query that is filled using a customer exit if it's filled with eg # or another special value (could be "fill me in"). In the abap code you would have something like (copyed from our CMOD) this where we have a variable "I0CALMO7" for 0calmonth that will be filled with current month if its # or 000000
Remark the usage of e_check_again as described here
WHEN 'I0CALMO7'.
IF i_step = 1. " set default value = current month
CLEAR: L_S_RANGE.
ZT_DTH = sy-datum.
L_S_RANGE-LOW = ZT_DTH(6).
L_S_RANGE-SIGN = 'I'. "Include
L_S_RANGE-OPT = 'EQ'. "Equal
APPEND L_S_RANGE TO E_T_RANGE.
e_check_again = 'X'.
endif.
if i_step = 2.
* if original value = # then fill with sy-datum
read table i_t_var_range into loc_var_range with key vnam = 'I0CALMO7'.
if sy-subrc = 0 and ( loc_var_range-low = '#' or loc_var_range-low = '000000' ).
CLEAR: L_S_RANGE.
ZT_DTH = sy-datum.
L_S_RANGE-LOW = ZT_DTH(6).
L_S_RANGE-SIGN = 'I'. "Include
L_S_RANGE-OPT = 'EQ'. "Equal
APPEND L_S_RANGE TO E_T_RANGE.
else.
CLEAR: L_S_RANGE.
L_S_RANGE-LOW = loc_var_range-low.
L_S_RANGE-SIGN = 'I'. "Include
L_S_RANGE-OPT = 'EQ'. "Equal
APPEND L_S_RANGE TO E_T_RANGE.
endif.
endif.
With kind regards
Kristian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kristian,
Thank you for your information!
It is very true that we should not trust everything we read on the Internet. After posting the question in the SAP community, I also checked with someone internally. Though they said not possible, they also qualified it by saying that it can be done in the BW queries. I think it is probably the same as you have described. However, only they can make that change.
Best regards!
Quin
User | Count |
---|---|
71 | |
11 | |
10 | |
10 | |
10 | |
8 | |
7 | |
7 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.