Home > OLAP Dialog Boxes and Wizards > Save to Template
![]() Previous |
![]() Next |
Use this dialog box to save an XML description of the selected analytic workspace, cube, or cube dimension.
The content of this dialog box changes depending on your selection of a destination:
Save to File: Creates a disk file containing the template.
Save to Table: Saves the XML template in a table named CUBE_TEMPLATES
. Each saved template is a row in this table.
Object Selection: Shows the contents of the analytic workspace in a tree. You can verify or modify the selection of objects in this tree.
Options: Displays the following options for the metadata saved in the template:
Include Schema Name with OLAP Objects: Fully qualifies the names of all OLAP objects. Select this option so the template always re-creates the OLAP objects in the original schema. For example, you can re-create the GLOBAL
analytic workspace in the GLOBAL
schema while logged in as any user with the appropriate access rights. For portability, deselect this option so that the OLAP objects can be re-created in any schema. For example, you can re-create the GLOBAL
analytic workspace in the SCOTT
schema.
Source Object Option: Controls whether the XML descriptions of objects use the simple name or a fully qualified name:
Include Schema Name for All Source Objects: Fully qualifies the names of all relational tables and views in the mappings metadata, so that the cubes and dimensions are mapped to relational objects in the original schema. Select this option when re-creating an analytic workspace in the original schema or when the relational sources are available only in the original schema. For example, you can re-create the GLOBAL
analytic workspace in the GLOBAL
schema in the same database or in a different database. You can also re-create the GLOBAL
analytic workspace in the SCOTT
schema, and all objects will be mapped to tables in the GLOBAL
schema.
Do Not Include Schema Name for Source Objects Owned by schema_name: Fully qualifies only the names of relational tables and views in a different schema than the OLAP objects. The template maps the cubes and dimensions to relational source tables and views in the same schema unless the names are fully qualified. Select this option when the relational source will be re-created in a new schema along with the OLAP objects, but any other sources will be available only in their original schema. (Default)
Do Not Include Schema Name for Any Source Objects: Does not qualify the names of any relational source objects. The template maps the cubes and dimensions to relational source tables and views in the same schema.
Metadata Format: Select a metadata version for the template:
12.1 is the current version.
11.2.0.2 is backward compatible with Oracle Database 11.2.0.2.
11.2 is backward compatible with Oracle Database 11.2.0.1.
11.1 is backward compatible with Oracle Database 11.1.
Location: Identifies the directory where the file is saved. You can change the directory by expanding the drop-down list, using the icons to the right, or selecting from the Directory Tree.
Directory Tree: Lists subdirectories and files under the Location directory. Selecting a subdirectory sets the value of Location. Selecting a file sets the value of File Name. To choose between seeing all files and only template files, set File Type.
The icons to the right of Location also control the content. The icons are identified by tool tips: Up one level, Desktop, Create new folder, List, and Details.
File Name: Enter the name of the XML file or select a file in the directory tree to overwrite it. By default, the object name is the file name with an xml extension.
File Type: Controls the files displayed in the directory tree. Select Template Files to see only XML files.
Schema: The schema in which the template is saved. You must have CREATE TABLE
privileges in that schema.
Table Name: The name of the templates table, which is always CUBE_TEMPLATES
in this release.
Filter: To restrict the list of saved templates, enter a SQL WHERE
clause. The following are examples of valid filters:
name LIKE '%SALES%' AND modified >= sysdate -7 version >='11.2' parent_object = 'GLOBAL'
Saved Templates: This table describes previously saved templates. Select a template to overwrite it. The columns are populated with the metadata for that template.
Name: The name of the template.
Description: A description of the template.
Type: The highest-level object saved in the template.
Modified: The date the template was saved.
Version: The version of Oracle Database that the analytic workspace metadata is compatible with.
Parent Object: The parent of the highest-level object saved in the template.
Name: The name of the template. Enter a name for the template or select a name from Saved Templates to overwrite it. The names need not be unique.
Description: A description of the template.
Comments: Any additional information to be saved with the template.
Type: Controls the object types shown in Saved Templates.