To configure the runsamplesAPS and runsamplesEmbedded script files to work in your computer environment, you must verify that the path and other environment variables in the scripts are set correctly.
Note: | The procedure in this section applies to both a three-tier or embedded Java API deployment. |
To configure the script files to work with your computer environment:
In the EPM_ORACLE_HOME/common/EssbaseJavaAPI/11.1.2.0/samples/japi directory, locate the appropriate script.
If you are deploying the Java API in three-tier mode:
runsamplesAPS.cmd on Windows
runsamplesAPS.sh on UNIX
If you are deploying the Java API in embedded mode:
runsamplesEmbedded.cmd on Windows
runsamplesEmbedded.sh on UNIX
Using a text editor, open the script file you chose in step 1.
Verify that the APS_HOME variable is set to the location of your Provider Services installation; for example:
set APS_HOME=C:Oracle\Middleware\EPMSystem11R1\common\EssbaseJavaAPI\11.1.2.0\
Verify that the JAVA_HOME variable points to a supported version of the Java Runtime Environment.
If you did not install the Java Runtime Environment with Provider Services, you must update this variable with a full path to the Java installation; for example,
set JAVA_HOME="C:\Oracle\Middleware\jdk160_11" or C:\Oracle\Middleware\EPMSystem11R1\common\JRE\Sun\1.6.0
Replace the variable values for SAMPLE_PROG, USER, PASSWORD, OLAP_SERVER, and PROVIDER_URL as necessary.
These variables are set at the beginning of the script file.
Tip:
To make running the example programs easier, set up Oracle Hyperion Provider Services and Oracle Essbase on your local computer. Then, in Oracle Essbase Administration Services, create a user “system” with a password of “password” and full access to the Sample Basic, Demo Basic, and Demo2 Basic databases. If you set up your computer system in this configuration, you do not need to modify the default settings for the sample client programs.