You may need to move the Essbase Studio catalog from one computer to another. Essbase Studio enable you to export the catalog database into a file, which can then be imported to a different machine in order to recreate the catalog.
The process begins with the export operation. Using the Export option on the File menu, you may perform an action:
Export the entire catalog
Export individual catalog artifacts, such as data source connections, metadata elements, hierarchies, cube schemas, Essbase models, and drill-through reports.
You may also right-click individual or multiple catalog artifacts in the Source Navigator or the Metadata Navigator and then select the Export option from the shortcut menu.
No matter which export method you choose, the catalog database or selected artifacts are exported into an XML file.
You then import the XML file at the new location or machine. You must import the entire contents of the file; you cannot selectively import artifacts from the file.
When specific catalog artifacts are exported, the XML file that is created contains the descendants of the selected catalog artifact. For example, if a hierarchy is selected, the dimension elements and data source connection in the lineage of that hierarchy are also exported.
When exporting data source connections, the password to the source database is not included in the resulting XML file. After importing the XML file, add the password back by editing the connection, as described in Editing Data Source Connection Properties.