Importing EPBCS Application Cubes into OAC RPD

In order to connect and import EPM Cloud application cubes (EPBCS/PBCS) into OAC rpd, we need to configure following.

1.      Set the JAVA_HOME system environment variable in client machine to point to your JDK installation.

Ex: C:\Program Files\Java\jdk1.8.0_162.

For OAC (Oracle Managed)

If you're deploying Oracle Analytics Cloud, (i.e, on OCI with Oracle-Managed), configure these options:

2.   Configure <BIClient_Home>\bi\bitools\bin\admintool.cmd with the instance name:

add INSTANCE_NAME=%DOMAIN_HOME% below to ESSBASEPATH

set ESSBASEPATH=%DOMAIN_HOME%\..\..\bi\clients\Essbase\EssbaseRTC

set INSTANCE_NAME=%DOMAIN_HOME%

For OAS (Customer Managed)

If you're deploying Oracle Analytics Cloud- Classic, (i.e, Oracle Cloud Infrastructure Classic ), configure these options:

2.a.   Configure <BIClient_Home>\bi\bitools\bin\admintool.cmd with the instance name:

add INSTANCE_NAME=%DOMAIN_HOME% below to ESSBASEPATH

set ESSBASEPATH=%DOMAIN_HOME%\..\..\bi\clients\Essbase\EssbaseRTC

set INSTANCE_NAME=%DOMAIN_HOME%

2.b.    Configure Oracle Analytics Cloud host and port information in 

<BIClient_Home>\bi\config\fmwconfig\biconfig\OBIS\NQSConfig.INI

JAVAHOST_HOSTNAME_OR_IP_ADDRESSES = "host:9506";

3.    Update loader.xml File on Client Machine

1.   Navigate to  <BIClient_Home>\bi\bifoundation\javahost\config and locate loader.xml file and replace the below tags at the end of the file.

<!-- BI Server integration code -->

<Loader>

        <Name>IntegrationServiceCall</Name>

        <Class>oracle.bi.integration.javahost.ServiceCallLoader</Class>

        <ConfigNodePath>ServiceCall</ConfigNodePath>

        <ClassPath>

        {%ORACLE_BIJH_ROOTDIR%}/lib/obisintegration/javahostservice.jar;

        {%BI_PRODUCT_HOME%}/modules/oracle.bi.server/epm-cloud-driver.jar;

        </ClassPath>

</Loader>

    

4.      Run Javahost on client machine by executing following command

<BIClient_Home>\bi\bifoundation\javahost\bin\startOnClient.bat

If you need to restart the client, run stopOnClient.bat, then rerun startOnClient.bat

5.    Open OAC RPD Admin tool and start importing cube

           

Provide following details

Connection Type: Hyperion ADM

URL : adm:thin:com.hyperion.ap.hsp.HspAdmDriver:<EPBCSHostName>:<ApplicationCubeName>?locale=en_US;tenantName=<EPBCSIdentityDomainName>;hubProtocol=https;

Provider Type : Hyperion Planning

UserName : EBPBCS Admin Username

Password : EBPBCS Admin User Password

Click Next and Import Cube into Repository

Make sure that you've selected the ANCESTOR_DIMENSION_PROPERTY_SUPPORTED database feature after importing cube into Physical layer