Insight - Returning "Blank" values after trying to Filter

Nicholas McKeta

Hi!

I'm having an issue where after filter a particular field to "Not Null", I'm still getting fields with 'blank values' in the report.

Any thoughts/suggestions?

Codrin Teiu

Hi @Nicholas McKeta ,

Maybe you can turn them to zero then display greater than zero. Check this out

https://community.oracle.com/topliners/discussion/4470721/insight-obiee-tips-how-to-force-blank-values-to-display-as-0

Codrin Teiu

Logarithmic Solutions

hub.logarithmicsolutions.com/

Nicholas McKeta

Thanks! I'll have to try that!

Alexa Kalapaca-Oracle

@Nicholas McKeta Some fields aren't actually NULL in the database. For example, contact custom fields don't store NULL values. You would have to use a query that looks for a "space" value only. Hopefully that post above helped though.

--- excerpt from MCX 2019 slides

Custom fields for Accounts, Contacts, and Campaigns do no contain NULL values in Insight. Depending on the data type, “NULL” values are:

• Text: space
• DateTime: 1900-01-01
• Numeric: 0