Importing the Catalog XML File

Preparing to Import

  Before you begin the catalog XML file import procedure, complete the following tasks:

  1. Using the method of your choice, move the catalog XML file that you created in Exporting the Catalog Database to an XML File or Exporting Selected Catalog Elements to the location or computer where you will be importing it.

    For example, you may use an FTP program to move the file to the target location on another computer.

  2. Ensure that the catalog.db property in server.properties specifies the location of the target catalog database.

    See catalog.db.

    For a new catalog, create an empty database to serve as the target catalog database using the catalog_schema.sql scripts included in the Essbase Studio installation. The scripts are located in:

    EPM_ORACLE_HOME/products/Essbase/EssbaseStudio/server/database/common/your_RDBMS

    Note:

    This task assumes that the catalog RDBMS program is installed on the target machine.

Importing

Be sure to complete the tasks in Preparing to Import before beginning this procedure.

  To import the Essbase Studio catalog database XML file:

  1. In Essbase Studio Console, select File, and then Import.

  2. In the Import dialog box, click Browse, and in Import File, navigate to the location of the exported catalog XML file.

  3. Select the XML file to import, and click Open to return to the Import dialog box.

    Note that the File Name, File Description, and File Content Type fields are populated with the information that you entered during the export process.

  4. In the Options for importing into catalog group, select an option:

    • Check for elements and overwrite them—If the element already exists in the catalog database, it is overwritten with the new element from the XML file.

    • Check for elements but do not overwrite them—If the element already exists in the catalog database, it is retained; the duplicate element in the XML file is not used.

    • Do not check for elements; all elements are new—A catalog database is created using the XML file.

  5. Click OK to import the elements in the XML file into the catalog database.

    The XML file populates the catalog database that is specified by catalog.db in the server.properties file (see catalog.db).

    If errors occur during import, an error message box containing the details is displayed.

    Note:

    If you encounter an out-of-memory error during import, increase the virtual memory setting for Essbase Studio Console, as described in Configuring Virtual Memory.