Using XML Import to Load Metadata into TBC_MD

To complete the procedure below, you must start Integration Services Console and connect to Integration Server.

  To start Integration Services Console and connect to Integration Server:

  1. On the Windows desktop, click Start, and select All Programs, then Oracle EPM System, then Essbase, then Integration Services, then Server.

  2. On the Windows desktop, click Start, and select All Programs, then Oracle EPM System, then Essbase, then Integration Services, then Console.

  3. If necessary, click Close to clear the OLAP Metadata Catalog Setup dialog box.

    Integration Services Console automatically displays the Login dialog box.

    1. In the Server text box, under Integration Services, select or type the name of an Integration Server computer; for example, cypress.

      If the port number on which Essbase Integration Server communicates with the console has been set to a value other than the default, you must type the server name or IP address and type the non-standard port number, separated by a colon; for example:

      cypress:3390

    2. In the OLAP Metadata Catalog text box, select or type the name of the OLAP Metadata Catalog, TBC_MD, for the sample TBC (The Beverage Company) database.

    3. In the User Name and Password text boxes, type the user name and password for the standard sample application user, TBC, and click OK.

  To load sample OLAP model metadata into the TBC_MD tables using XML Import:

  1. In Integration Services Console, select File, then XML Import/Export.

  2. Select the Import tab.

  3. 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 folder:

    EPM_ORACLE_HOME\products\Essbase\eis\server\samples\tbcmodel

  4. Select the XML file to import for the sample OLAP model, sample_model.xml.

  5. Click OK.

    Integration Services Console displays the XML Import/Export dialog box with the XML file path and name in the XML File Path text box. The name of the sample OLAP model is displayed in the OLAP Model Name text box.

  6. Click the Import to Catalog button to load the selected XML file into the sample OLAP Metadata Catalog.

  To load sample OLAP metaoutline metadata into the TBC_MD tables using XML Import:

  1. In Integration Services Console, select File > XML Import/Export.

  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:

    EPM_ORACLE_HOME\products\Essbase\eis\server\samples\tbcmodel

  4. Select the XML file to import for the sample OLAP metaoutline, sample_metaoutline.xml.

  5. Click OK.

    Integration Services Console displays the XML Import/Export dialog box with the XML file path and name in the XML File Path text box, the name of the sample OLAP metaoutline in the OLAP Metaoutline Name text box, and the name of the OLAP model upon which this metaoutline is based in the Based on OLAP Model text box.

  6. Click the Import to Catalog button to load the selected XML file into the sample OLAP Metadata Catalog.