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

OAC | Filtration - Error

Accepted answer
36
Views
2
Comments
Vismay Barot
Vismay Barot Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Greetings Community, I'm facing an issue with an error only when I apply a Filter.
So I am able to visualize and put Data side by side from 2 Sources:

image.png

It's only when I select a Location, let's say for example "Cambridge", it throws in following error:

image.png

Just a FYI, this is how the joining is done:

image.png

Please let me know how this can be tackled, as everything is fine until a Filter is applied.

Thank You So Much for your time and efforts.

Tagged:

Best Answer

  • Vismay Barot
    Vismay Barot Rank 4 - Community Specialist
    Answer ✓

    Thank You So Much @Jestin Rajan for your Comment.

    Please Note 18 is just an Internal ID for My Select Filter for "Cambridge":

    image.png

    Here's the Full List of Sales Representative Location:

    image.png

    I don't think so any Location would be Non-Text Value.

    But the Great News is, I created this Calculation:

    image.png

    And will use this as a Filter, this is working perfectly fine.

    Thank You So Much and Have a Great Day :)

Answers

  • Jestin Rajan
    Jestin Rajan Rank 4 - Community Specialist

    Hi @Vismay Barot , You might want to check the data type of the Sales Representative Location column. It looks like you’ve applied a filter value of 18, which is numeric, but the column might actually be stored as text. That type mismatch is likely causing the ORA-01722: invalid number error.