on 11-18-2020 4:27 AM
Hi,
Could you please explain what is inclusion and exclusion in bex query.
Where it is used and how can we see the inclusion and exclusion values.
Regards,
Krishna
Hello Krishna,
Welcome to the community.
I am assuming by you are referring to filter values in BEx queries.
Inclusion - instructing query restrict query output based on the included filter values (and nothing else)
Exclusion - Instructing query to pull everything but the values selected as filter.
Use of Exclusion is not recommended for production queries (unless unavoidable) not only in BEx but SQL in general. Something similar is left outer join, "do not use it unless have to"
Exclusion statements mostly have performance impact on query.
Usually front end reporting tools (like Analysis For Office) show inclusion and exclusion details under "Effective Filter" (info field).
You can find additional details in similar Q&A thread below-
https://answers.sap.com/questions/7308113/exclusion-or-inclusion.html?db=5
https://answers.sap.com/questions/9655065/exclusion-of-values-in-bex-query.html
Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).
Thanks,
Debjit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.