Running the Batch File

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

Run the install_teradata.bat file located in: 

EPM_ORACLE_HOME\products\Essbase\eis\server\Samples\tbcdbase

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

Pass the following three required parameters to install_teradata.bat:

You can also pass, as an optional parameter, the database name where you want to install the sample application. (The default database is TBC.)

Metadata Load Script

The install_teradata.bat file runs the BTEQ utility, which executes the ha_create_teradata.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_teradata.bat file runs the FastLoad utility, which performs the following tasks:

  • Loads the sample data into the fact table using the ha_fastload_teradata.txt file

  • Creates the ha_results_loadfact.txt file

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

Alter Table Script

After loading the sample data into the fact table, the install_teradata.bat file runs the BTEQ utility, which executes the ha_altertable_teradata.sql alter table script file. This script file performs the following tasks:

  • Deletes a few tables no longer needed in the sample TBC database

  • Creates indexes and places constraints on the fact table

  • Creates the ha_results_altertables.txt file

The ha_results_altertables.txt file contains the results of the table-altering operation.