Wizards :: SAS(R) Data Integration Studio 4.9: User's Guide

New Object Wizards

Most new object wizards enable you to register objects, such as libraries and tables, so that they can be used in SAS Data Integration Studio jobs. One way to display these wizards is to right-click an appropriate destination folder in the Folders tree, then select New

Folder, or New

Job, and so on. The next table describes the new object wizards.

New Object Wizards
Wizard	Description
New Folder	Adds a folder in the Folders tree.
New Job	Adds metadata for a new SAS Data Integration Studio job.
New Table	Registers a single table that does not yet exist in physical storage, such as a table that is created when a job is executed for the first time.
New Transformation	Adds a new generated transformation. The wizard guides you through the steps of specifying SAS code for the transformation and saving the transformation to the metadata server. After the transformation is saved, it displays in the Transformations tree, Folders tree, and Inventory tree where it is available for use in any job.
New External File	Registers an external file, which is a file that is maintained by the machine operating environment or by a software product other than SAS. A flat file with comma-separated values is one example.
New Library	Registers a SAS library.
New Document	Registers a document that you can associate with one or more metadata objects.
New Note	Creates and registers a note that you can associate with one or more metadata objects.
New Cube (Cube Designer in add mode)	Creates and registers a SAS OLAP cube.
New OLAP Schema	Changes the OLAP schema associated with a cube.

Register Tables Wizards

Register Tables wizards enable you to register one or more selected tables, based on the physical structure of the tables. One way to display these wizards is to right-click an appropriate destination folder in the Folders tree, and then select Register Tables. Another way is to right-click the icon for the library that contains the physical tables, and then select Register Tables.

Cube Wizards

Cube wizards enable you to create and maintain SAS OLAP cubes. A SAS OLAP cube is a logical set of data that is organized and structured in a hierarchical, multidimensional arrangement. It is a data store that supports online analytical processing (OLAP). When you specify a cube, you specify the dimensions and measures for the cube along with information about how aggregations should be created and stored.

A cube can be quite complex. Accordingly, someone who is familiar with OLAP design and the business goals for a particular cube should create and maintain the cube. The main cube wizards in SAS Data Integration Studio are described in the following table.

Cube Wizards
Wizard	How to Display the Wizard	Description
Cube Designer (add mode)	Right-click an appropriate destination folder in the Folders tree, and then from the desktop select NewCube.	Creates and registers a SAS OLAP cube.
Cube Designer (update mode)	Right-click a cube, and then select Edit Cube Structure.	Maintains a cube.
Aggregation Tuning	Right-click a cube, and then select Aggregation Tuning.	Updates aggregations.
View Cube	Right-click a cube, and then select View Cube.	Displays the cube.
Export Code	Right-click a cube, and then select Export Code.	Saves the code for the cube to a file.
Calculated Members	Right-click a cube, and then select MaintainCalculated Members.	Adds, edits, and deletes the calculated members associated with the cubes that are registered to the current metadata server.
Change OLAP Schema	Right-click a cube, and then select MaintainChange OLAP Schema.	Changes the OLAP schema associated with a cube.

For more information about SAS OLAP cubes, see SAS OLAP Server User's Guide.

Data Surveyor Wizards

An optional data surveyor wizard enables you to extract, search, and navigate data from the SAP ERM system. One way to display the SAP data surveyor is to right-click an appropriate destination folder in the Folders tree, select Register Tables, and then select the data surveyor.

Optional Composite Software provides access to ERM systems such as Siebel, PeopleSoft, Oracle Applications, and Salesforce.com. For details about Composite Software and the data surveyor wizard for SAP ERM systems, see the SAS Intelligence Platform: Data Administration Guide.

For details about setting up the libraries, servers, and client software for Enterprise Resource Planning (ERP) systems, administrators should see the chapters about common data sources in the SAS Intelligence Platform: Data Administration Guide.

Metadata Import and Export Wizards

SAS Data Integration Studio enables you to import and export metadata in SAS Open Metadata Architecture format or in a format that is supported by a SAS Metadata Bridge.

The SAS Package wizards enable you to import and export metadata in SAS Open Metadata Architecture format. For example, you could use the SAS Package wizards to export a job from SAS Data Integration Studio in a test environment, and then import that job into SAS Data Integration Studio in a production environment.

SAS Package Wizards
Wizard	How to Display the Wizard	Description
Export SAS Package	In the Folders tree, right-click one or more objects to be exported, and then select ExportSAS Package.	Exports selected metadata objects to a SAS Package (SPK) file.
Import SAS Package	In the Folders tree, right-click a destination folder, and then select ImportSAS Package.	Imports SAS metadata that was exported to a SAS Package (SPK) file.

The Import and Export Metadata wizards enable you to work with metadata in a format that is supported by a SAS Metadata Bridge. You must license the appropriate bridge.

Import and Export Metadata Wizards
Wizard	How to Display the Wizard	Description
Export Metadata	In the Folders tree, right-click one or more objects to be exported, and then select ExportMetadata.	Exports table metadata that you select. You can export metadata in a format that is supported by a SAS Metadata Bridge.
Import Metadata	In the Folders tree, right-click a destination folder, and then select ImportMetadata.	Imports metadata in a format that is supported by a SAS Metadata Bridge. You have the option of comparing the imported metadata to existing metadata. You can view any changes in the Differences window and choose which changes to apply.