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 12.2.1.4.0 essbase error while importing cubes into BI Admin tool

Received Response
21
Views
6
Comments
User_INLWQ
User_INLWQ Rank 5 - Community Champion
edited Aug 13, 2024 5:22PM in Oracle Analytics Cloud and Server

Hi Gurus,

I am on OBIEE 12.2.1.4.0 and when i tried importing essbase cube into admin tool , i am getting below error.  Please share any inputs. Thanks in advance.

Essbase version is 11.

pastedImage_0.png

Answers

  • User_INLWQ
    User_INLWQ Rank 5 - Community Champion

    Hi Gurus,

    Please share any inputs on this. Thanks.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Do you have the Essbase client installed and the paths configured?

    That was the cause in 11g, in 12c I don't remember (just because last time I loaded a cube was ages ago) if it's the same or it now goes via the javahost config on the server directly (but if that is the case I expect a message saying the javahost isn't set correctly).

  • User_INLWQ
    User_INLWQ Rank 5 - Community Champion

    Hi Gianni,

    I found a doc on Oracle support (doc ID 1368858.1) , ( it says for OBIEE 11.1.1.5 and later versions),  in that they mentioned to set environment variables in "bi-init.cmd" and "opmn.xml" files  ---- these are not present in OBIEE 12.2.1.4.0

    then if that don't work, they suggested to set environment variables "ARBORPATH" and "ESSBASEPATH"

    IF that still don't help then create a ".bat" file, set paths in that and then run it.

    Thanks

  • User_INLWQ
    User_INLWQ Rank 5 - Community Champion

    Could not find any doc on support site explicitly for OBIEE 12c versions,  every article says "applies for OBIEE 11.1.1.X  or later" versions.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    2711084 wrote:then if that don't work, they suggested to set environment variables "ARBORPATH" and "ESSBASEPATH"IF that still don't help then create a ".bat" file, set paths in that and then run it.

    So did you set those variables?!

  • User_INLWQ
    User_INLWQ Rank 5 - Community Champion

    Hi Chris,

    Set both ARBORPATH and ESSBASEPATH,  It did not help.

    As a last option, will be creating that bat file and run.

    Thanks