Skip Headers
Previous
Previous
 
Next
Next

Create/Edit Cube: Map

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

Query Builder

The Query Builder subpage identifies the mappable cube objects and their relational data sources.

The Query Builder provides the following tools:

Icon Description
Clear Mappings Icon
Deletes all mappings and join clauses. The Source Column in the Select List is blank and the Join Clause panel is removed from the display.
Refresh Icon
Refreshes the source tables, views, or synonyms.
Auto Map Icon
Automatically maps the dimension and cube objects to columns in the selected relational object with similar names.

Sources: The name of a table, view, or synonym that contains the facts or foreign keys. The source for a cube is typically a fact 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.

Aggregate Measure Using: Select an aggregation method:

SELECT List: Identifies the relational source for each cube object:

Join Clause: Identifies the relationship between the dimension values in the fact table and the dimension values in the dimension tables. Click a field for a list of available columns.

WHERE Clause: Enter a WHERE clause if the fact table contains more data than you want to store in the cube.

SQL

The SQL subpage shows the SQL SELECT statement created by the entries on the Query Builder subpage.