on 12-10-2018 3:01 PM
Hi All,
I have created a customer exit on a field in BEx query and the setting is 'INCLUSION'.
I want to limit the values passed in the field based on my logic in customer exit.
Based on the logic execution I am appending my 4-5 values to E_T_RANGE internal table with following values
wa_t_range-sign = 'I'.
wa_t_range-opt = 'EQ'.
wa_t_range-low = 'XYZ'.
append wa_t_range to e_t_range.
wa_t_range-sign = 'I'.
wa_t_range-opt = 'EQ'.
wa_t_range-low = 'ABC'.
append wa_t_range to e_t_range.
When I execute the query in RSRT, it is unable to filter data correctly i.e. it is not restricting selection to XYZ and ABC. But returning all values.
My requirement works with 'EXCLUSION' but it is hampering my performance. Hence I have to work with 'INCLUSION' and pass value only which are needed.
I am running on BW 7.4 SP09. Do I need to apply a note or anything ?
Rujuta,
What exactly are you trying to achieve?
OR
OR
All three use cases would need 3 different approaches.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think you need to add another value which will give a NO DATA to your object.
For example, aside from assigning XYZ and ABC, you should also add the value # so that whenever there is no XYZ and ABC values your query will still run with # value which will result in NO DATA. Because if there is no XYZ and ABC in the report, all values will be shown as if you filter nothing.
Regards,
Loed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
if you want to restrict data there are 2 ways:
1. using analysis authorization and assign to users.
2. using F4 restrict value exit, follow below instruction
what you are doing now is just set default value
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i_step = 2 is after user input so i think it dont have affect that you want. the restriction should be authorization or F4 help restriction, it easier and achive what you want.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.