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.


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,


Former Member

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