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 (12.2.1.2.0) integration with Essbase (EAS Server)

Received Response
1
Views
6
Comments
HennieB
HennieB Rank 1 - Community Starter
edited Aug 13, 2024 5:59PM in Oracle Analytics Cloud and Server

Installation and Setup:

We installed OBIEE 12 C and included the Essbase component during the OBIEE installation.

According to the below Oracle reference, EAS 11.1.2.4.008 and later is supported with our release of Essbase.

http://docs.oracle.com/cd/E66975_01/doc.1221/readme/essbase_122120_readme.html

EAS Server was part of the OBIEE installation in the 11G environment, but based on feedback from Oracle Support, EAS server is not included in the OBIEE 12C installation and needs to be installed as part of EPM.

We subsequently installed EPM (including OHS) in a new home and deployed the EPM Java web applications to the EPMSystem domain.

Status:

We can connect to the EPM Administration Server via OHS on the default port (19000).

We can create and connect to the Essbase Server installed as part of OBIEE on the default port (9799).

When we try to create an application, it fails with the following erros:

Error from the EAS interface:

"

Failed to create application.

Check the message panel for details.

"

Error in the Message Panel:

"

[dev75502:9799.test] Create application 26 April 2017 3:58:49 PM Failed

Error: 1013238 Failed to create application [test]

"

Summary

In OBIEE 11G, with Essbase included in the installation, we manged to connect to the EAS server using the following URL without any additional config.

<hostname>:9704/easconsole where 9704 is the same port that is used by analytics.

In OBIEE 12C, with Essbase included in the installation, we cannot connect to the EAS server using the same URL that we used in 11G.

<hostname>:9502/easconsole where 9502 is the same port that is used by analytics

ERROR: "Error 404--Not Found"

To install EAS server, we followed the recommendations from Oracle Support and can connect to EAS server (via the EPM OHS instance), but we cannot create new Essbase applications.

Assuming that our architecture is sound, please advise what I could be missing which resulted in the error.

Regards,

Hennie

Answers

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

    Short answer: EAS is dead. Long live CDS.

    Longer answer: http://john-goodwin.blogspot.ch/2015/11/essbase-12c-for-bi-glimpse-into-future.html

  • HennieB
    HennieB Rank 1 - Community Starter

    Hi Christian,

    thanks for the response!

    That for us is where the confusion comes in, because according to the Oracle documentation, CDS is not supported yet.

    Please refer to the extract below:

    Administration Services and Essbase Studio 11.1.2.4.008 or Later Are Supported in Essbase 12.2.1.2.0Supported components for Essbase 12.2.1.2.0:- Essbase 12.2.1.2.0- Oracle Hyperion Provider Services 12.2.1.1.0- Oracle Essbase Administration Services 11.1.2.4.008 or later- Oracle Essbase Studio 11.1.2.4.008 or laterNote: Administration Services and Essbase Studio releases earlier than 11.1.2.4.008 are not supported with Essbase 12.2.1.2.0.Unsupported Features in Essbase 12.2.1.2.0These features are not supported in this release:- Cube Deployment Service (CDS)- Essbase BI Acceleration

    Source: Readme

    We also came across documentation (including the article from John Goodwin) stating that CDS replaced EAS, but could not find any Oracle documentation that confirmed that.

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

    I know it's a weird situation but it's there and deployed in every instance I have.

  • HennieB
    HennieB Rank 1 - Community Starter

    Hi Christian,

    can you create an Essbase application on your running instances?

    I have tried the following:

    1. Run startMAXL.sh

    2. MAXL> Login weblogic password;

    3. create application test_app

    It is failing to create the application, which is the original error that we received.

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

    I'm still confused about your setup. First you installed Essbase together with OBI - granted. That's the normal process to get the baked-in Essbase.

    What did you then install afterwards and where? And what did Oracle Support "recommend you do"? You either have and use the baked-in one or a stand-alone Essbase. Some weird mix of the two probably just won't work anyways

  • HennieB
    HennieB Rank 1 - Community Starter

    The only component in OBIEE 12C that we were missing, compared to OBIEE 11G was the EAS server component.

    Oracle recommended that we install EPM 11.1.2.4 that include EAS server and OHS.

    Based on your feedback, I decided to ignore the EPM recommendation from Oracle and test whether I can create an Essbase application using MAXL.

    The feedback in the previous post indicate that I cannot create an application using MAXL, so I might be missing something else.

    Note that the application was started with the out of the box scripts and I also confirmed that all the components are running.