Result from another query for FHSQL

building reports
1

Hi all,

Hope everyone is well and safe.

I am trying to build this report with query from two data sources, one query pulls data from universe and another one points towards a SQL database using FHSQL connection. Is it possible to pass result from universe query to a FHSQL parameter inorder to select the required data from SQL database? Below is what I am trying to achieve

Free hand SQL query -
Declare @NAME varchar(max)
Select * from SALES_CURRENT where @name in ( result from another universe query which is a dimension)

Got no access to universe. Reports are built on Webi - SAP 4.2 I believe

Really appreciate your help

Thanks in advance

2

Even I am looking for the same. Any Luck?

3

One way round it is, if possible, to use the SQL from the first query as a subquery in your FHSQL statement.

1 Like