Insight (OBIEE) Tips: SQL quick tip

For more Eloqua Insight Resources, please visit: https://community.oracle.com/topliners/discussion/4470627/eloqua-insight-resource-page

Recently, I was looking into a blind form submit challenge where anti-malware protections were causing a lot of fake form submits. We wanted to make sure that in form submission data reporting, we were only getting the valid data.

Based on the email recipients and the use case, we decided to only report on the last form submit from a given contact.

OBIEE SQL filter to achieve this:

"Form Data"."User Form Submit ID" = MAX( "Form Data"."User Form Submit ID" By "Contact"."Eloqua Contact ID")