Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Forum

Categories

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

Date / Timestamp Issue

Received Response
21
Views
4
Comments
Teresa Modesta
Teresa Modesta Rank 5 - Community Champion
edited Aug 13, 2024 5:50PM in Oracle Analytics Forum

Hello,

I have this problem where I have a timestamp in an analysis from a subject area dimension field that I convert to a date to do some date manipulation with.

This worked, but then after saving reloading etc it now errors with a conversion error after no changes at all.

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics & AI Strategist

    Hi,

    I have seen this also.

    The fix is to make sure you explicitly convert it (cast to...) and never rely on implicit conversion at any point.

    I am not sure why this works initially, and then fails, but that is the fix.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    Larry's Friday Girl wrote:it now errors with a conversion error

    Hi,

    Thanks for letting us know

    In case it's a question, what's the question?

    And you will have to post a bit more if you expect an answer ...

    Things like the detailed error, the conversion used, the version etc.

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics & AI Lead

    We cannot help you unless you answer at least the following questions: What exactly did you try, What Is the exact error, which Obiee version do you use, ..

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Sorry, I'm a bad girl...

    Your resident angel solved my problem, he was dead right, but I will follow the rules next time...