Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

combining multiple Select statements

I'm trying to understand how webi behaves in a situation like this:

- universe with contexts

- query in webi uses objects from both contexts

- so one query would generate 2 Select statements -> normal behaviour so far.

question:

How are the 2 Select statements combined?

- Does webi send each Select separately to the db and then the db handles the combination of queries?

- Or does webi send a combined query (Select 1 + Select 2) to the db? In that case, how does webi combine the query (union, intersection)?

Many thanks in advance,

R

replied

In this case also the query will be considered as 1 Select with sub select query and no Union or Intersection logic will be implied on that.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question