Skip Headers
Previous
Previous
 
Next
Next

About Saving Dimensional Object Definitions

You only need to save object definitions in an external 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 files are platform independent

About XML Templates

Templates are XML documents that describe dimensional objects. You can save the XML descriptions of all the objects in an analytic workspace or just selected objects, and re-create them later in the same database or in a database on another computer or platform. You can use templates to back up your work while developing a dimensional model of your data or to distribute the design to other users.

You can save the XML definitions of the following types of objects:

Templates store metadata, not data. You can store templates in a small text file or in a database table. When re-creating objects from a template, you must have access to the source data.

Related Topics

"Creating XML Templates with Object Definitions"

"Creating Dimensional Objects From XML Templates"

About EIF Files

You can export objects in an analytic workspace to an EIF file. EIF files are specially formatted files for copying analytic workspaces. You can use EIF files to:

EIF files are upwardly compatible among releases of Oracle Database. An EIF file saves the definitions of OLAP DML objects and optionally saves the data also. When you create an EIF file, you can save only the data that you have permission to access.

EIF files do not save object security rules.

Using the SQL Developer UI, you can export and import EIF files for analytic workspaces. You can use EIF files at a more granular level, such as saving just your custom programs, using the OLAP DML.

Related Topics

"Creating EIF Files of Analytic Workspaces"

"Creating Analytic Workspaces from EIF Files"