Mapping Window

Mapping identifies the data sources for dimensions and cubes. A mapping window contains:

Tool bar
Type of dimension tables
Schema navigation tree
Mapping canvas

Tool Bar

The following table describes the various tools.

Mapping Tools
Tool	Description
	Displays the graphical mapping canvas.
	Displays the tabular mapping canvas.
	Arranges the objects on the graphical mapping canvas and sort rows in the objects so that mapping lines do not intersect.
	Automatically maps source and target objects. The source must be a star schema, and the source and target names must correspond.
	Removes all mapping lines.

Type of Dimension Table(s)

Before mapping a dimension, identify the type of schema. This list does not appear for cubes.

Star Schema: All levels and attributes are in one source table.
Snowflake Schema: Levels are in two or more source tables with their attributes.
Other: Attributes for a level are in two or or more source tables.

If the analytic workspace supports multiple languages, you can map the attributes to a separate column for each language. The columns can be in separate tables without affecting your choice of schema.

Schema Navigation Tree

Provides access to the source tables and views, which you can drag-and-drop onto the mapping canvas. To minimize the schema tree, drag the divider to the left.

To peruse the first 1000 rows of a source table or view, right-click it and choose View Data from the pop-up menu.

Mapping Canvas

Two modes are available, a graphical mode and a tabular mode. You can switch modes by clicking the appropriate toolbar icon. The target objects in the analytic workspace are already available on the canvas.

Graphical mode. You can drag-and-drop source tables from the schema tree to the canvas. Then draw lines from the source columns to the target logical objects. To draw a line, click the output connector on the source column and drag it to the input connector on the target object.

To peruse the first 1000 rows of a source table or view, right-click it on the mapping canvas and choose View Data from the pop-up menu.

To simplify the canvas, minimize any objects that you are not currently mapping, and use the Auto Arrange Mappings tool to uncross the lines.

Tabular mode. You can drag-and-drop source columns from the schema tree to the target object in the table. The fully qualified name of the column appears in the Source Column. You can also type in equations to perform on the source data, and map the base level of dimensions to a higher level than the relational dimension keys. See the Related Topics.

If the attributes of a target dimension do not appear, then display the Attribute Property Sheet: General tab and select the levels that have attributes.