Prerequisites for Modelling Oracle EPM Data Using Model Administration Tool

Before you start, make sure you have the required components in place and deployed correctly.

  • Oracle Analytics Cloud - Enterprise Edition.

  • A Windows 64–bit machine on which to run Model Administration Tool.

  • Model Administration Tool for Oracle Analytics Cloud. Always use the latest version of Oracle Analytics Client Tools. Using mismatched versions leads to incompatibility issues.

    Download it from Oracle Technology Network and install it on a local Windows 64–bit machine. See Download and Install Analytics Client Tools for Oracle Analytics.

  • A Javahost process running on the client. (Start a process using the command: C:\oracle\oac-client-5.6\bi\bifoundation\javahost\bin\startOnClient.bat.)

  • If you're deploying Oracle Analytics Cloud, (that is, on Oracle Cloud Infrastructure with Oracle-Managed), configure these options:

    • Set the JAVA_HOME system environment variable to point to your JDK installation.

      For example, C:\Program Files\Java\jdk1.8.0_162.

    • set INSTANCE_NAME=%DOMAIN_HOME%

    • Edit the file <BIClient_Home>\bi\bitools\bin\admintool.cmd, and below the ESSBASEPATH setting add:set INSTANCE_NAME=%DOMAIN_HOME%
    • Run <BIClient_Home>\bi\bifoundation\javahost\bin\startOnClient.bat to start Javahost.

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