Merge 3 queries

building reports webintelligence
1

Query 1 can be merged to Query 2 on ID1. Query 2 can be merged to Query 3 on ID2. I need to return result from Query 3 please?

Qry1
ID1 = 781255

Qry2
ID1 = 781255
ID2 = 785828

Qry3
ID1 = 0
ID2 = 785828
ID3 = 781261

Return results
Qry1.ID1 = 781255
Qry2.ID2 = 785828
Qry3.ID3 = 781261

2

select Qry1.ID1, Qry2.ID2, Qry3.ID3
from Qry3
inner join Qry2 on Qry3.ID2 = Qry2.ID2
inner join Qry1 on Qry2.ID1 = Qry1.ID1

3

you can merge dimensions variables of a large number of queries in WeBi, either all in one operation or adding them one after another
for adding attributes from the various queries, you need to use context operators as “in” or “foreach” when they are not from the “main” query, or to make variables of type “Detail” relating to the merged variable out of them