Skip Headers
Previous
Previous
 
Next
Next

Creating Cube Dimension Mappings

Mappings identify the flow of data from the relational source objects to the dimensional target objects. You typically map a cube dimension to a dimension table or view.

For a measure dimension, map it to the table created for this purpose. See "Creating Measure Dimensions and Pivot Cubes".

To map a cube dimension: 

  1. Under Cube Dimensions in the Connections navigator, right-click the name of the cube dimension and select Edit.

  2. In the Edit Cube Dimension dialog box, select Map.

  3. In the Query Builder subpage, click Select Sources.

  4. In the Source Selection dialog box, select one or more tables, views, or synonyms that contain the dimension members.

  5. Click OK to return to the Query Builder subpage.

  6. Click each field under Source Column, and select the appropriate column for each map object.

  7. To load only part of the data from the source, enter a WHERE clause.

  8. Check the generated SQL SELECT statement on the Query subpage (optional).

  9. Click OK.

NEXT: Creating Cubes