Subquery in webi query panel

[anuragvijay]

I'm using Webi 2.7.2. Is it possible to create a subquery in the query panel (as we can do in full-client)? I do not see any option to do that. Is there any indirect method?

I want the query generated to look like:
select customer from table1 where customer not in (select cus from table2)

Here 'customer' and 'cus' can be considered two objects in two different folders 'table1' and 'table2' respectively.

In other words i want only those customers from table1 which are not present in table2.

Thanks
Anurag

 

[skrandel]

No, this is not possible in WebI 2.7.x. It is possible in WebI 6.1x.

You could build a predefined condition in the universe that does this for you.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com