When you create or change dimensions and cubes in Analytic Workspace Manager, the changes are saved automatically in the database. You only need to save the definitions in an external flat file for transferring them to another database or saving a backup copy. You can save the definitions either in an XML template or in an EIF file. Both methods are platform independent.
XML templates are small text files that are easily portable. A template saves the XML definition of dimensions, cubes, and other dimensional objects. Using a saved template, you can create a new analytic workspace with the same objects as an existing one. The template does not save any data.
Important: Do not use templates to copy analytic workspaces to a different version of Oracle Database. Always use EIF files to assure compatibility among software versions.
To save an analytic workspace as a template:
In the same way, you can save a particular dimension or cube in a template.
Select a local directory for the XML file, and change the default file name if you wish.
Tip: Use the Configuration dialog box to set the initial directory. From the Tools menu, choose Configuration.
Choose Save.
To create an analytic workspace from a template:
To create the analytic workspace in a different schema or using a different name, edit the XML file and make these changes to the code using search-and-replace.
In the navigation tree, right-click the Analytic Workspaces folder and choose Create Analytic Workspace From Template from the pop-up menu.
Select the saved XML file from a local directory, and choose Create.
Load and aggregate the data.
EIF files are upwardly compatible among releases of Oracle Database. An EIF file saves the object definitions of any analytic workspace, and optionally saves the data also. For information about EIF files, see the related topics.
Exporting Analytic Workspace Objects
Importing Analytic Workspace Objects
Copyright © 2003, 2007, Oracle. All rights reserved.