Oracle Analytics and AI

Integrating OBIEE 12C(12.2.1.4) with Essbase 11.2.1.4

We want to federate Oracle Essbase multidimensional sources(aggregated data from relational sources) with relational data sources(detailed facts).

Is there any bad known issues between these versions besides issue with bi admin tool?

OBIEE 12C and Essbase 11.1.2.4 integration issue

We are moving from OBIEE 10g + Essbase 11.2.1.4

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

That's an extremely wide and open question to say the least. There can be many issues but the most important ones / ones with the largest impact are in the cube design itself rather than the integration.

deniska

We know about many issues(obiee 10g+9.7,obiee 10g 10g+11.2.1.4) but I mean in General.

Are they compatible with each other?

Because we are choosing actual appropriate versions and we cant stop later))

Gianni Ceresa

Have a look at the certification matrix.

Essbase 11.1.2.* is certified for OBIEE 12.2.1.4.

deniska

I read it but

I faced the issue and the answer was

"As per Oracle SR, Solution is to use OBIEE 12.2.1.3 Admin Tool as OBIEE 12.2.1.4 Admin tool is not certified with imports from Essbase Version 11.1.2.4.X per Per BUG 27376664 and certification Doc ID 1109260.1"

And I want to understand does this integration have another huge bugs or not

[Deleted User]

That's an inacceptable answer from them since 12.2.1.3 will be out of error correction support innone month.

Gianni Ceresa

I hate what about to write but ....

Technically it isn't a totally blocking issue, the 12.2.1.4 Admin tool seem to not be certified for the import of an 11.1.2.4 cube (is there really such a thing like a certification for the import wizard of the Admintool? Never saw one, and the bug linked isn't accessible). This doesn't mean it doesn't work, just that the Admintool can't import the cube. If you get the cube into the RPD by another way (that's where 12.2.1.3 could be used) it must work as certified for OBIEE/DV etc.

What would be needed is to have access to that bug and the fix Oracle had to develop. That reply is July 2018, things had to change in the meantime!

deniska

.So we should have 2 installed version of BI EE 12C(12.2.1.2 and 12.2.1.4) on our development servers?

First only for importing cubes from essbase and second to develop with?

Is there any way to save and copy any files from 12.2.1.2 to anywhere 12.2.1.4 and don't user 2 servers?

Ive tried to copy all files

from

12.2.1.2 catalog c:\Oracle\Middleware\Oracle_Home\bi\bifoundation\server\bin\

12.2.1.4 catalog c:\Oracle\Middleware\Oracle_Home\bi\bifoundation\server\bin\admintoolessbase

and create new admintooless.cmd in c:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi_domain\bitools\bin\

"SETLOCAL

set DOMAIN_HOME=c:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi_domain

call "C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\server\bin\admintoolessbase\admintool.cmd" %*

ENDLOCAL"

but with no success

"Error: Unable to access jarfile C:\Oracle\Middleware\Oracle_Home\bi\bifoundation

\endpointmanager\jlib\bi-endpointmanager-impl.jar"

deniska

Have found patch.

Wow, impossible. Now I can import essbase metadata to bi repo)

Doc ID 2481998.1

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=434884965528234&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&…

[Deleted User]

Awesome, thanks for the update!

So the SR guys were wrong and @Gianni Ceresa the reply being from July '18 doesn't invalidate my statement since it is a product defect and suggesting to mixing Admin Tool versions is just beyond wrong.

Gianni Ceresa

I agree with you, but you know the kind of answers SRs are having lately ...