Wizards
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.
Table A1.13 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.
Wizards 639
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.
Table A1.14 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 New ð
Cube.
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 Maintain ð
Calculated 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 Maintain ð Change
OLAP Schema.
Changes the OLAP schema
associated with a cube.
For more information about SAS OLAP cubes, see SAS OLAP Server User's Guide.
640 Appendix 1 Main Windows and Wizards

Get SAS Data Integration Studio 4.9 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.