Insight (OBIEE) Tips: How to force blank values to display as 0

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

You may have noticed metrics in your Eloqua Insight reports showing blanks as well as 0s.

Here is an example email analysis:

The blanks actually represent a NULL - meaning there is no value for that metric. In the case of bouncebacks you will only see values for hard and soft bouncebacks if there was a bounceback (i.e email delivery is less than 100%). On the other hand, Total Bouncebacks does show 0s. This is because the metric is using an aggregated table. An aggregated table stores the pre-coumuted results of Total Hard and Total Soft bouncebacks. So in the case of an aggregated table, you will see 0 instead of a NULL value.