After setting up the sample application

You must connect to both TBC and TBC_MD from Integration Services Console to create, modify, and store TBC OLAP models and TBC metaoutlines. To make these connections, each database (TBC and TBC_MD) must be mapped to a supported ODBC driver, as described in Configuring relational data sources for DB2 OLAP Integration Server.

When you connect to Integration Services Console, you can view TBC columns, tables, OLAP models, and metaoutlines in Integration Services Console. For more information, see Viewing TBC tables and columns.

Note:
You must connect to TBC and TBC_MD as user TBC unless you create user name aliases or synonyms in the RDBMS.

Viewing TBC tables and columns

After you set up the sample application and configure TBC and TBC_MD by mapping them to supported ODBC drivers, you can view TBC tables and columns in Integration Services Console

To see TBC tables and columns in the left frame of Integration Services Console:

  1. Start the servers.

    For instructions, see Starting the Analytic Server on Windows or Starting the Analytic Server on UNIX.

  2. Start Integration Services Console.

    For instructions, see Starting Integration Services Console.

  3. In a blank Integration Services Console window, select Connections > OLAP Metadata Catalog > Connect, and connect to the OLAP Metadata Catalog, TBC_MD.
  4. In the New tab, double-click the OLAP Model icon.
  5. In the Data Source dialog box, connect to the TBC sample database.

Viewing OLAP models

After you set up the sample application and configure TBC and TBC_MD by mapping them to supported ODBC drivers, you can view OLAP models in Integration Services Console.

To see the OLAP model (TBC Model) in the right frame of Integration Services Console:

  1. Start the servers.

    For instructions, see Starting the Analytic Server on Windows or Starting the Analytic Server on UNIX.

  2. Start Integration Services Console.

    For instructions, see Starting Integration Services Console.

  3. If the Login dialog box is not already displayed, in a blank Integration Services Console window, select Connections > OLAP Metadata Catalog > Connect.
  4. Connect to the OLAP Metadata Catalog TBC_MD.
  5. Click the Existing tab, select TBC Model, and click Open.

    Hybrid Analysis: To view the Hybrid Analysis-enabled OLAP model, select HA TBC Model.

    Unicode: To view the Unicode-enabled OLAP model, select Sample_unicode.

  6. In the Data Source dialog box, connect to the TBC sample database.

Viewing metaoutlines

After you set up the sample application and configure TBC and TBC_MD by mapping them to supported ODBC drivers, you can view metaoutlines in Integration Services Console.

To see the metaoutline (TBC Metaoutline) in the right frame of Integration Services Console:

  1. Start the servers.

    For instructions, see Starting the Analytic Server on Windows or Starting the Analytic Server on UNIX.

  2. Start Integration Services Console.

    For instructions, see Starting Integration Services Console.

  3. If the Login dialog box is not already displayed, in a blank Integration Services Console window, select Connections > OLAP Metadata Catalog > Connect.
  4. Connect to the OLAP Metadata Catalog TBC_MD.
  5. Click the Existing tab, then expand the view of TBC Model and select TBC Metaoutline.

    Hybrid Analysis: To view the metaoutline enabled for Hybrid Analysis, expand the view of HA TBC Model and select HA TBC Metaoutline.

    Unicode: To view the metaoutline enabled for Unicode, expand the view of Sample_unicode and select Sample_unicode_meta.

  6. Click Open.

    The Data Source dialog box is displayed.

  7. In the Data Source dialog box, connect to the TBC sample database.