Is there a way to filter this way in OTBI?
Summary:
Content (please ensure you mask any confidential information):
I'm extracting columnA from a table. It has both null and not null values.
»»»Filter should only show not null values - it should not show NULL value!«««
When no filter is applied the analysis should return only rows having columnA = null.
When filter is applied, let's say filter = Val1, analysis should return only rows having columnA in (null, Val1).
If filter = Val1, Val2 analysis should return only rows having columnA in (null, Val1, Val2).
In BI Publisher I was able to do it this way:
I'm not able to do the same in OTBI, any idea?