cancel
Showing results for 
Search instead for 
Did you mean: 

What is inclusion and exclusion in bex query

0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

DebjitSingha
Active Contributor

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