Skip Headers
Previous
Previous
 
Next
Next

Creating Cube Mappings

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

To map a cube: 

  1. On the Create/Edit Cube dialog box, select Map.

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

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

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

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

  6. For the Join clause, click each field under Fact Table Column, and select the appropriate column to map to the dimension table column.

  7. Select an aggregation method to use if the source contains multiple rows with the exact same keys.

    For example, you can sum the values, or load just the first one and discard the others. The SQL subpage shows how the aggregation method is used in a SELECT statement.

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

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

  10. Click OK.

NEXT: Loading Data Into Dimensional Objects