Before setting up the Hybrid Analysis sample application, you must set up the standard sample application (see Setting up the standard sample application automatically or Setting up the standard sample application manually).
Setting up the Hybrid Analysis sample application is a manual process. Follow the instructions given in this section for your particular platform.
The utilities listed in Table 27 are required for running the various batch files and SQL scripts used in creating the Hybrid Analysis sample application.
You use several files to create the Hybrid Analysis sample application on DB2 Universal Database:
install_db2.bat
ha_create_db2.sql
HA_TBC_Model.xml
HA_TBC_Metaoutline.xml
ha_sampledata.txt
Setting up the Hybrid Analysis sample application on DB2 UDB consists of performing the following tasks:
The first task in setting up the Hybrid Analysis sample application on DB2 UDB consists of running the install_db2.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_db2.bat file located in:
\is\Samples\tbcdbase
This batch file sends SQL commands to the DB2CMD command line interface.
Pass the following three parameters to install_db2.bat:
The install_db2.bat file runs the DB2CMD command line interface, which executes the ha_create_db2.sql load script file. This script file performs the following tasks:
The ha_results_createtables.txt file contains the results of the table-creating and loading operations.
The final task in setting up the Hybrid Analysis sample application on DB2 UDB consists of importing the two XML files for the sample OLAP model and metaoutline:
To import the sample OLAP model:
The XML Import/Export window is displayed.
\is\Samples\tbcmodel\HA_TBC_Model.xml
To import the sample metaoutline:
The XML Import/Export window is displayed.
\is\Samples\tbcmodel\HA_TBC_Metaoutline.xml
You use several files to create the Hybrid Analysis sample application on Oracle:
install_oracle.bat
ha_create_oracle.sql
hasales.ctl
HA_TBC_Model.xml
HA_TBC_Metaoutline.xml
ha_sampledata.txt
Setting up the Hybrid Analysis sample application on Oracle consists of performing the following tasks:
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:
\is\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 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:
The ha_results_createtables.txt file contains the results of the table-creating operation.
After loading the metadata into the dimension tables, the install_oracle.bat file runs the SQLLDR command line interface, which performs the following tasks:
The ha_results_loadfact.txt file contains the results of the data-loading operation.
The final task in setting up the Hybrid Analysis sample application on Oracle consists of importing the two XML files for the sample OLAP model and metaoutline:
To import the sample OLAP model:
The XML Import/Export window is displayed.
\is\Samples\tbcmodel\HA_TBC_Model.xml
To import the sample metaoutline:
The XML Import/Export window is displayed.
\is\Samples\tbcmodel\HA_TBC_Metaouline.xml
Several files are used to create the Hybrid Analysis sample application on SQL Server:
install_sqlsrv.bat
ha_create_sqlsrv.sql
HA_TBC_Model.xml
HA_TBC_Metaoutline.xml
ha_sampledata.txt
Setting up the Hybrid Analysis sample application on SQL Server consists of performing the following tasks:
To set up the Hybrid Analysis sample application on SQL Server, you first run the install_sqlsrv.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_sqlsrv.bat file located in:
\is\Samples\tbcdbase
This file sends commands to the Interface SQL (ISQL) command line interface. These commands install the sample application to the sample database TBC.
Pass the following three parameters to install_sqlsrv.bat:
The install_sqlsrv.bat file runs the ISQL utility, which executes the ha_create_sqlsrv.sql metadata load script file. This file performs the following tasks:
The ha_results_createtables.txt file contains the results of the table-creating operation.
After loading the metadata into the dimension tables, the install_sqlsrv.bat file runs the BCP (Bulk Copy) utility which performs the following tasks:
The ha_results_loadfact.txt file contains the results of the data-loading operation.
The final task in setting up the Hybrid Analysis sample application on SQL Server consists of importing the two XML files for the sample OLAP model and metaoutline:
To import the sample OLAP model:
The XML Import/Export window is displayed.
\is\Samples\tbcmodel\HA_TBC_Model.xml
To import the sample metaoutline:
The XML Import/Export window is displayed.
\is\Samples\tbcmodel\HA_TBC_Metaouline.xml
Several files create the Hybrid Analysis sample application on Teradata:
install_teradata.bat
ha_create_teradata.sql
ha_altertable_teradata.sql
ha_fastload_teradata.sql
HA_TBC_Model.xml
HA_TBC_Metaoutline.xml
ha_sampledata.txt
Setting up the Hybrid Analysis sample application on SQL Server consists of performing the following tasks:
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:
\is\Samples\tbcdbase
\is\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.)
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:
The ha_results_createtables.txt file contains the results of the table-creating operation.
After loading the metadata into the dimension tables, the install_teradata.bat file runs the FastLoad utility, which performs the following tasks:
The ha_results_loadfact.txt file contains the results of the data-loading operation.
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:
The ha_results_altertables.txt file contains the results of the table-altering operation.
The final task in setting up the Hybrid Analysis sample application on Teradata consists of importing the two XML files for the sample OLAP model and metaoutline:
To import the sample OLAP model:
The XML Import/Export window is displayed.
\is\Samples\tbcmodel\HA_TBC_Model.xml
To import the sample metaoutline:
The XML Import/Export window is displayed.
\is\Samples\tbcmodel\HA_TBC_Metaouline.xml