Essbase Studio is not provided with Essbase Release 12.2.1.x. To use Essbase Studio to deploy Essbase cubes and enable drill-through functionality with Essbase 12.2.1.x you must install EPM 11g on a separate host and complete some configuration steps.
Use the following steps to run Essbase Studio 11g with Essbase 12.2.1.x.
- Install EPM 11.1.2.4 and apply the latest Opatch.
- Install BI 12.2.1 on a different host.
- Update the Essbase Studio server properties file with server.trustedAuthenticationHost=<HOSTNAME>:<PORT>, where HOSTNAME is the host where Essbase is running, and PORT is the Essbase port.
Note:
The server.properties file is located in ORACLE_INSTANCE/EssbaseStudio/essbasestudio1/bin in the EPM 11.1.2.4 environment.
- Stop and restart Essbase Studio server.
- Stop the BI instance.
- Copy cpld.jar from 11.1.2.4 EPM:
${EPM_ORACLE_HOME}/common/essbase-studio-sdk/11.1.2.0/lib
To BI12c:
${MIDDLEWARE_HOME}/user_projects/domains/${DOMAIN_NAME}/lib
- Start Oracle Business Intelligence.
Note:
You cannot deploy and access drill-through reports on multiple BI Essbase instances. Multiple Essbase instances are not supported.