You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to add OR condition in the input of the OTBI analysis

Received Response
30
Views
7
Comments
edited Sep 18, 2020 7:20AM in Reporting and Analytics for ERP 7 comments

Summary

How to add OR condition in the input of the OTBI analysis

Content

There are suppliers whom we create only invoices and there are suppliers whom we create only PO (these suppliers get paid by credit card and the system it shows never paid). 

My requirement is to generate a list of all the suppliers who have either Invoices or PO between a specific date.

I created an analysis using 'Procurement -Spend Real Time' subject area.

I have given input parameters as Invoice and PO creation date. When I selected the date range in both the input parameter, it takes AND condition, and the output is the supplier list who have invoice and PO both in the given period. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!