Running the Batch File

The first task in setting up the Hybrid Analysis sample application on Oracle consists of running the install_oracle.bat file. This batch file creates tables in the sample database, loads metadata into the dimension tables, and loads sample data into the fact table.

Run the install_oracle.bat file located in:

EPM_ORACLE_HOME\products\Essbase\eis\server\samples\tbcdbase

This batch file sends SQL commands to the SQL*PLUS command line interface.

Pass the following three parameters to install_oracle.bat :

The user ID that you use to connect with Oracle
Your password
The Oracle service name as defined in the TNSNAMES.ORA file

Metadata Load Script

The install_oracle.bat file runs the SQLPLUS command line interface, which executes the ha_create_oracle.sql metadata load script file. This script file performs the following tasks:

Deletes any existing tables in the sample TBC database
Creates a new set of tables in the TBC database
Inserts records into the dimension tables
Creates the ha_results_createtables.txt file

The ha_results_createtables.txt file contains the results of the table-creating operation.

Sample Data Load Script

After loading the metadata into the dimension tables, the install_oracle.bat file runs the SQLLDR command line interface, which performs the following tasks:

Loads the sample data into the fact table
Creates the ha_results_loadfact.txt file

The ha_results_loadfact.txt file contains the results of the data-loading operation.