Skip Headers
Previous
Previous
 
Next
Next

Create/Edit Cube Dimension: Map

Use this panel to identify the data sources for cube dimension. The panel has two subpages:

Query Builder

The query builder subpage identifies the mappable dimensional objects and their relational data sources.

A toolbar provides these functions:

Tool Description
Surrounding text describes clear_maps.png.
Clears all mappings.
Surrounding text describes refresh_source.png.

Surrounding text describes auto_map.png.
Automatically maps relational sources to dimensional target objects. The source must be a star schema, and the source and target names must match.

Sources (FROM Clause): The name of a table, view, or synonym that contains the dimension values. The source for a cube dimension is typically a dimension table in a star or snowflake schema. Click the Select Sources button for a list of available sources.

Select Sources: Displays the Source Selection dialog box, which you use to identify the source columns.

SELECT List

The SELECT list identifies the columns in the selected source that are mapped to the various dimensional objects.

Source Column: Identifies the column of the source table, view, or synonym that maps to a dimension object. The Sources (FROM Clause) field must have a value. Click a field to see a drop-down list of available source columns.

By default, all source columns are displayed. You can restrict this list on the Source Selection dialog box. Click the Select Sources button.

Map Object: Lists the levels and attributes of this dimension. This list is populated automatically.

Hierarchy: Lists the hierarchy that the map object belongs to.

WHERE Clause: Limits the number of values loaded into the cube dimension. Otherwise, all values from the source column are loaded.

SQL

The SQL subpage shows the SQL SELECT statement created by the entries on the Query Builder subpage. It is read-only.