None of the calendar functions are working on OBIEE11g on Redshift. — Oracle Analytics

Oracle Analytics Cloud and Server

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

None of the calendar functions are working on OBIEE11g on Redshift.

Received Response
11
Views
3
Comments
3218183
3218183 Rank 2 - Community Beginner

None of the calendar functions are working on OBIEE11g on Redshift.  I am using PostgreSQL driver to connect to Redshift

I am getting the following error

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 16001] ODBC error state: 51 code: 0 message: [DataDirect][ODBC 20101 driver]6022. [nQSError: 16014] SQL statement preparation failed. (HY000)


Do I need to change any settings in RPD file.

All the calendar functions are checked in my RPD

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Anything in this archived thread of help?

    Connecting OBIEE to Redshift

  • Chet Justice
    Chet Justice Rank 2 - Community Beginner

    As you're probably aware, Redshift is not certified to work with OBIEE. That (supposedly) changed in 12c.

    I currently have a client with 11g sitting on Redshift using the Postgres drivers. My colleague determined that Redshift (but more likely the Postgres driver) doesn't play nicely with the OBIEE date functions. We've resorted to using EVALUATE and using Redshift functions for all our date calculations.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @Chet Justice welcome to the best forum here

    To add to your input: in 11g it's really the drivers which are the issue, less what's emitted. Even with more support coming you'll never get to a real native query translation.