Oracle Transactional Business Intelligence

Products Banner

Records dropping from basic analysis due to filter(s)

Received Response


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
    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 "" is null OR "" = '[email protected]'