Home > OLAP Dialog Boxes and Wizards > Create from Template
![]() Previous |
![]() Next |
A template is an XML document that describes the metadata for dimensional objects. You can create an entire analytic workspace from a template or add dimensional objects to an existing analytic workspace.
The content of this dialog box changes depending on where the XML document is stored:
Create from File: The XML document is stored in a local disk file where SQL Developer can access it.
Create from Table: The XML document is stored in a table named CUBE_TEMPLATES
for which you have SELECT
privileges.
Contents: Shows the contents of the selected template in a hierarchical tree structure. When you select more than one template, only one of them is displayed.
Source: Shows the XML descriptions of the objects in the template. To search for an object within the template, enter the object name, type, or other text in the text field and click Find.
Options: Lists options that restrict the object definitions that are created from the template:
Modify Existing Objects: Merges the XML template definitions with the existing objects with the same name in the current analytic workspace. In a merge, object properties in the template overwrite existing object properties. Any object or properties that are not set in the template remain unchanged in the analytic workspace.
Import User-Defined OLAP DML Associated with Objects: Imports all analytic workspace objects that are associated with the imported objects in the template:
Analytic workspace: Imports all user-defined OLAP DML objects.
Cube: Imports all user-defined OLAP DML objects associated with the cube's calculated measures and build specifications.
Dimension: Imports no associated user-defined OLAP DML objects.
Related Topics
"Creating Dimensional Objects From XML Templates"
The template is stored in a directory for which you have read access.
Location: Select 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 in this box 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 of directory tree. The icons are identified by tool tips: Up one level, Desktop, Create new folder, List, and Details.
File Name: Select the file containing the XML document from the directory tree.
File Type: Controls the files displayed in the Directory Tree. Select Template Files to see only XML files.
The template is stored in a relational table for which you have SELECT
privileges in an Oracle database.
Schema: Select the schema where the template is stored.
Table Name: The name of the templates table, which is always CUBE_TEMPLATES
in this release.
Filter: Selects the templates listed in Saved Templates using a SQL WHERE
clause. Following are examples of valid filters:
name LIKE '%SALES%' AND modified >= sysdate -7 version >='11.2' parent_object = 'GLOBAL'
You can also use the Type field to restrict the list.
Saved Templates: The list of templates stored in the table. The following columns are populated with metadata describing the templates:
Name: Name of the template.
Description: Description of the template.
Type: Highest level object saved in the template.
Modified: Date the template was saved.
Version: Database version of the analytic workspace.
Parent Object: Parent of the highest level object saved in the template.
Name: The name of the template selected in Saved Templates.
Description: The description of the template.
Comments: Any additional information saved with the template.
Type: Controls the object types shown in Saved Templates.