Excluding result of one report in another report.

[Former Member]

Hell Experts,

We have two DSOs as below:

DSO1 - Contains Master list of customers

DSO2 - Transactions of all customer.

I want a report to show all customers who do not have any transactions.

So thought of come up with all unique set of customers from DSO2 then read the DSO1 exclude this list (using replacement path), but raised that exclusion is not possible in replacement path.

Is there a way I can do this in BEx.

Any thoughts in this regard of great help.

Regards,

[Former Member · Accepted solution]

Hi,

The soultion for this is using variable with processing type replacement path to be replaced with query results.

See this link:

http://help.sap.com/saphelp_NW70EHP1core/helpdata/en/2c/78a03c1178ad2ce10000000a114084/content.htm

HTH,

Marek

[former_member189638]

Try creating a multiprovider having both the DSO in it. Now create a query on this multiprovider.

The query output would be 0 for the customers without any transactions. If this is not coming as 0 then create a Formula Key Figure in the query with formula (K.F + 0) and hide the original key figure K.F. This will enforce the key figure value to display the value or 0.

Now create a condition where this Key Figure is Less than 0. I believe this should give you the desired output.