Records dropping from basic analysis due to filter(s)

Karen Delaney

Summary:

Content (required):

I have a very basic analysis in obiee that is pulling all active CWK. I need to include Home Email, however, when I filter, I lose ~25% of my population, because they do not have a Home Email. I need a solution to include the field, while keeping the whole population intact. Regardless of whether one of my CWKs has a Home Email or not, if they're active, they should be on my output, and their Home email field blank. It's probably so obvious ? Appreciate any/all responses

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Nathan CCC

In an analysis on teh criteria tab in your filters when you add a filter the default operator is "AND". But you can click it to change it to "OR". And copy paste them about to change the nesting. So if i understand you correctly you sound like you need a where clause that goes something like

where "table.email" is null OR "table.email" = '[email protected]'