Skip to Content
0
Jul 22, 2020 at 09:24 AM

How to fetch Query A minus Query B in Webi Report from 2 different Data Providers

371 Views Last edit Jul 27, 2020 at 04:48 AM 3 rev

Hi All,

Can anyone tell me how to implement Query A Minus Query B in Webi.

Query A is based on custom SQL having 5 columns.

Query B is based on an excel source having 5 columns.

Requirement is to check every row from Query A and if that is not available in Query B, will have to be displayed in the result set.

Combined queries/minus operator cannot be implemented as these data providers are not based on the universe.

Thanks