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 12c Integration with Essbase 11.1.2.4

Received Response
12
Views
13
Comments
3278969
3278969 Rank 2 - Community Beginner
edited Aug 13, 2024 6:11PM in Oracle Analytics Cloud and Server

I was able to create a repository, import Essbase metadata and push the cube to presentation layer. I am able to access the app in OBI analysis and select the member needed for my report. but When I run the result tab the following error is thrown. OBIEE 12.2.1.0.0 and Essbase 11.1.2.4 reside on separate servers on AIX 17.1 OS. I have gone through all lot of documents regarding  the integration configuration and not sure what I am missing.

Any help is greatly appreciated.

Odbc driver returned an error (SQLExecDirectW).

State: HY000.  Code: 10058.  [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000.  Code: 43113.  [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000.  Code: 27002.  [nQSError: 27002] Near <set>: Syntax error  (HY000)

State: HY000.  Code: 26012.  [nQSError: 26012] . (HY000)

«1

Answers

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

    Are you sure you're using the correct call interface definitions in the RPD and not - for example - an old Essbase version?

  • 3278969
    3278969 Rank 2 - Community Beginner

    Do you mean using an old essbase client where OBI resides? No. I was able to login to essbase and browse the cube properties via Maxl shell from OBI server.

    Thanks,

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

    No I meant the actual RPD settings. Often an issue when they don't match the real Essbase source.

    pastedImage_0.png

  • 3278969
    3278969 Rank 2 - Community Beginner

    My RPD is set to 11.1.2.3.500 release. Will this cause connectivity issues?

    Thanks

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

    No that's the max at the moment so it's correct.

    Can you emit normal MDX from your OBI server against the Essbase server for example?

  • 3278969
    3278969 Rank 2 - Community Beginner

    I get the same error when I emit an MDX query against the Essbase cube

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

    So then it's nothing related to OBI but something more basic.

  • 3278969
    3278969 Rank 2 - Community Beginner

    Also as an FYI, When I open the RPD online and attempt to view dimension members in physical layer , it errors out with the same general error.

    Thanks for your help.

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

    Honestly best raise an SR. I never faced this myself and don't have any AIX running where I could test that specific setup.

  • 3278969
    3278969 Rank 2 - Community Beginner

    I already have an SR open. I have installed OBI in windows and have no issues connecting to the same data source.

    Thanks