Home > OLAP Dialog Boxes and Wizards > Create/Edit Cube Dimension:...
![]() Previous |
![]() Next |
Use this panel to identify the data sources for cube dimension. The panel has two subpages:
The query builder subpage identifies the mappable dimensional objects and their relational data sources.
A toolbar provides these functions:
Tool | Description |
---|---|
![]() |
Clears all mappings. |
![]() |
|
![]() |
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.
The SQL subpage shows the SQL SELECT
statement created by the entries on the Query Builder subpage. It is read-only.