Home > Creating Dimensional Objects > Creating Cube Mappings
![]() Previous |
![]() Next |
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:
On the Create/Edit Cube dialog box, select Map.
In the Query Builder subpage, click Select Sources.
In the Source Selection dialog box, select one or more tables, views, or synonyms that contain the dimension members.
Click OK to return to the Query Builder subpage.
Click each field under Source Column, and select the appropriate column for each map object.
For the Join clause, click each field under Fact Table Column, and select the appropriate column to map to the dimension table column.
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.
To load only part of the data from the source, enter a WHERE
clause.
Check the generated SQL SELECT
statement on the Query subpage (optional).
Click OK.