Filter By checkbox disappears

Question

Hi,

I'm new to OBIEE. We're on 12c. I have a time hierarchy which has two levels. First, is called year with the year and year description. Second is detail with code and code long description. Code long description is set to code for sort order column and descriptor id column. When I go to do an analysis and I select to filter on code long description, the checkbox Filter By Code disappears if I select greater than or equal to filter. It works fine with just equal to or in. Both columns are stored as nvarchar2 on the database. Please let me know if any additional information is needed. Any help is appreciated.

Thanks

Gianni Ceresa · Answer

Is 'Hello world' > 'Hello new world' ? That's why your checkbox disappear ... A > or < (or >= and <=) make little sense when it isn't performed on a numeric or date/time data type.

2834710 · Answer

Should add the question: Why is the checkbox Filter By Code disappearing when the operator is set to "is greater than or equal to."