When using EDM business rules can be constructed using one of five methods:
In this section we will describe how to create a business rule using each type, and why one type would be used versus another.
To implement business rules you must first determine what the functional business requirement is, and then identify what the technical representation of that requirement is. The technical representation of the requirement is a SQL statement.
In our example the business rule is INVOICE IS NOT CLOSED. The technical representation of this requirement may be:
select invoice_header_id from ap_invoice_header where invoice_status <> ‘ CLOSED’;
Our sample interim table would have the following columns:
We will use this example to describe how to use the different condition types.