Setting up the Hybrid Analysis sample application

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.

Note:
The Hybrid Analysis application scripts require slightly different procedures, depending on the RDBMS that you are using.

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.

Table 27. Required Utilities for Setting Up the Hybrid Analysis Sample Application
Database Required Utilities
DB2 DB2CMD command line interface
Oracle
  • SQL*Plus
  • SQL*Loader command line utility
SQL Server
  • ISQL
  • BCP command line utility
Teradata
  • BTEQ
  • FastLoad

Setting up the Hybrid Analysis sample application on DB2 UDB

You use several files to create the Hybrid Analysis sample application on DB2 Universal Database:

Setting up the Hybrid Analysis sample application on DB2 UDB consists of performing the following tasks:

Note:
Before setting up the Hybrid Analysis Sample Application on DB2 UDB, verify that the DB2CMD command line interface is installed.

Running the batch file on DB2 UDB

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.

Note:
After the member and data load is finished, close the DB2 UDB command window.

Importing the sample OLAP model and metaoutline

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:

  1. Start Integration Services Console.
  2. Select File > XML Import/Export.

    The XML Import/Export window is displayed.

  3. Select the Import tab.
  4. In the XML File Path text box, enter the file path for the sample OLAP model or click the Open XML File button and navigate to the following file:
    \is\Samples\tbcmodel\HA_TBC_Model.xml
  5. Click Open XML File.

To import the sample metaoutline:

  1. Select File > XML Import/Export.

    The XML Import/Export window is displayed.

  2. Select the Import tab.
  3. In the XML File Path text box, enter the file path for the sample OLAP metaoutline or click the Open XML File button and navigate to the following file:
    \is\Samples\tbcmodel\HA_TBC_Metaoutline.xml
  4. Click Open XML File.

Setting up the Hybrid Analysis sample application on Oracle

You use several files to create the Hybrid Analysis sample application on Oracle:

Setting up the Hybrid Analysis sample application on Oracle consists of performing the following tasks:

Note:
Before setting up the Hybrid Analysis Sample Application on Oracle, verify that SQL*PLUS and SQLLDR command line interfaces are installed.

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:

\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 :

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:

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:

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

Importing the sample OLAP model and metaoutline

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:

  1. Start Integration Services Console.
  2. Select File > XML Import/Export.

    The XML Import/Export window is displayed.

  3. Select the Import tab.
  4. In the XML File Path text box, enter the file path for the sample OLAP model or click the Open XML File button and navigate to the following file:
    \is\Samples\tbcmodel\HA_TBC_Model.xml
  5. Click Open XML File.

To import the sample metaoutline:

  1. Select File > XML Import/Export.

    The XML Import/Export window is displayed.

  2. Select the Import tab.
  3. In the XML File Path text box, enter the file path for the sample OLAP metaoutline or click the Open XML File button and navigate to the following file:
    \is\Samples\tbcmodel\HA_TBC_Metaouline.xml
  4. Click Open XML File.

Setting up the Hybrid Analysis sample application on SQL Server

Several files are used to create the Hybrid Analysis sample application on SQL Server:

Setting up the Hybrid Analysis sample application on SQL Server consists of performing the following tasks:

Note:
Before setting up the Hybrid Analysis Sample Application on SQL Server, verify that you have ISQL and BCP (Bulk Copy) installed. These utilities were most likely included when you installed SQL Server Client.

Running the batch file

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:

Metadata load script

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.

Sample data load script

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.

Importing the sample OLAP model and metaoutline

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:

  1. Start Integration Services Console.
  2. Select File > XML Import/Export.

    The XML Import/Export window is displayed.

  3. Select the Import tab.
  4. In the XML File Path text box, enter the file path for the sample OLAP model or click the Open XML File button and navigate to the following file:
    \is\Samples\tbcmodel\HA_TBC_Model.xml
  5. Click Open XML File.

To import the sample metaoutline:

  1. Select File > XML Import/Export.

    The XML Import/Export window is displayed.

  2. Select the Import tab.
  3. In the XML File Path text box, enter the file path for the sample OLAP metaoutline or click the Open XML File button and navigate to the following file:
    \is\Samples\tbcmodel\HA_TBC_Metaouline.xml
  4. Click Open XML File.

Setting up the Hybrid Analysis sample application on Teradata

Several files create the Hybrid Analysis sample application on Teradata:

Setting up the Hybrid Analysis sample application on SQL Server consists of performing the following tasks:

Note:
Before setting up the Hybrid Analysis Sample Application on Teradata, verify that the BTEQ and FastLoad utilities are installed.

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:

\is\Samples\tbcdbase
Note:
If you installed DB2 OLAP Integration Server on Windows, the batch file is in the following directory:
\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.)

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:

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:

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:

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

Importing the Sample OLAP Model and Metaoutline

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:

  1. Start Integration Services Console.
  2. Select File > XML Import/Export.

    The XML Import/Export window is displayed.

  3. Select the Import tab.
  4. In the XML File Path text box, enter the file path for the sample OLAP model or click the Open XML File button and navigate to the following file:
    \is\Samples\tbcmodel\HA_TBC_Model.xml
  5. Click Open XML File.

To import the sample metaoutline:

  1. Select File > XML Import/Export.

    The XML Import/Export window is displayed.

  2. Select the Import tab.
  3. In the XML File Path text box, enter the file path for the sample OLAP metaoutline or click the Open XML File button and navigate to the following file:
    \is\Samples\tbcmodel\HA_TBC_Metaouline.xml
  4. Click Open XML File.