Exporting Selected Catalog Elements

  To export selected catalog elements (partial catalog) to an XML file:

  1. Perform an action:

    The Export dialog box is displayed with the Export partial catalog option selected and the Add button enabled.

  2. Click Add and select an option:

    • Add Metadata

      The Select Element to Export dialog box displays the contents of the Metadata Navigator. Perform these steps:

      1. Navigate to the items that you want to export.

      2. When you have finished making selections, click OK.

    • Add Data Source

      The Select Data Source to Export dialog box displays the contents of the Source Navigator. Perform these steps:

      1. Select the data sources that you want to export.

      2. When you have finished making selections, click OK.

    The metadata elements and data sources that you have selected for export are listed in the table in the File Contents portion of the Export dialog box.

    The full path of each element is shown under “Names.” The type of element—such as connection or hierarchy—is shown under “Type.”

  3. Optional: To delete any items listed before performing the export, select the item in the File Contents table and click Delete, Delete button.

  4. Click OK.

    The selected items from the catalog are exported to the XML file that you designated in step 2 and step 3 of Exporting the Catalog Database to an XML File.

    Note:

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

You can now import the XML catalog database artifacts to the new location. See Importing the Catalog XML File.