how to use subquery in WEBI

building reports webintelligence
1

Hi All,
I am new to WEBi
Is it possible to use a Subquery in that a subquery in where clause in WEBI XIR2.

Like

select root where
root inlist (select a,b,c from A where g=‘a’ )
and trace inlist(select Req_id where type = ‘Activity’ and tag=1ur);

Is it possible to write this type of queries in WEBi

Thanks,
Radhika

radhiraj (BOB member since 2006-06-02)

2

Moved from “Building Reports” ==> WebI 1.x/2.x (which is for legacy versions that correspond to BusinessObjects 4.x/5.x) to the ==> WebI XI sub-forum.

Anita Craig :us: (BOB member since 2002-06-17)

3

You can write sub-queries in Webi XI, although the process is not immediately obvious. What you need to do is create your query, then highlight the “source” object for the sub-query, and finally click the “sub-query button” on the toolbar.

I’ve attached a screenshot from my Webi presentation at the conference this year where I showed how to do this…
webi_subquery.jpg

Dave Rathbun :us: (BOB member since 2002-06-06)