BusinessObjects Board

Data from one query be used in FHSQL filter

building reports webintelligence
#1

Hi,

I have two data providers, one from Universe and second from FHSQL. now I need help in creating filter in FHSQL based on Query1 ( Universe) like

CustName IN ( Custname from Query1)

can you please provide any suggestion or alternate method will also work.

thanks

#2

An alternative would be to lift the query from query one to become a subquery in query 2

#3

you can do a reference to the result of another data provide in the where clause like e.g.:
<variable_name> IN @dpvalue(‘A’, DP3.DO1)
sometimes this procedure behaves a bit “bullheaded”, but is works
BUT: not mor than 999 instances may be contained in that list (is I think at least a “hard” Oracle restriction)
Rgds