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

OBIEE TimesTen Integration

Received Response
23
Views
4
Comments
Bhavya P
Bhavya P Rank 3 - Community Apprentice
edited Aug 13, 2024 5:58PM in Oracle Analytics Cloud and Server

Hello,

TimesTen is configured with OBIEE using BI Direct: OBIEE 11G and Oracle Times Ten 11.2.2 Integration  configuration setup, in Windows machine for OBIEE 11.1.1.9.

Every thing went fine for configuration, but when running a report found "NO RESULT", updated row count in physical layer but there was 0 rows updated, not sure what was missing.

Some one please help me on it with your suggestions.

Thanks in advance...

Bhavya

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Are you sure there is data in the underlying tables? If yes, take the OBIEE generated query and run it in the TimesTen database (using SQL developer?) and see if it is returning result. Also it is a good idea to disable cache for testing.

  • Bhavya P
    Bhavya P Rank 3 - Community Apprentice

    Hello George,

    Yes, tested the physical query running by using SQL Developer, It retrieves data...  and disabled cache as well. Still it is "No Results"

  • Bhavya P
    Bhavya P Rank 3 - Community Apprentice

    Any other suggextion George...

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    You mentioned 'Windows' in your original post. Can you confirm you have performed installation of OBIEE and TimesTen database in certified OS (refer certification matrix for both products). If it is a certified configuration, I would suggest to try a different driver for DSN to use with TimesTen if available.