Skip to content
  • Register

    • Oracle Analytics Cloud and Server

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

    Welcome!

    Sign in to share your experience and connect with the community.
    Log In
    Register

    Quick Links

    Categories

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

    Date / Timestamp Issue

    Received Response
    11
    Views
    4
    Comments
    Rank 5 - Community Champion
    edited Aug 13, 2024 5:50PM in Oracle Analytics Cloud and Server

    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.

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Log In
    Register

    Answers

    • Rank 8 - Analytics 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.

    • 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.

    • Rank 6 - Analytics 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, ..

    • 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...

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Log In
    Register