Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Filter By checkbox disappears

Received Response
1
Views
2
Comments
2834710
2834710 Rank 1 - Community Starter
edited Aug 13, 2024 5:30PM in Oracle Analytics Cloud and Server

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

Answers

  • 2834710
    2834710 Rank 1 - Community Starter

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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.